Tag: laravel-migrations

Laravel Migration Error: SQLSTATE[42000]: Syntax error or access violation: 1091 with mysql

laravel laravel-9 laravel-migrations mysql php

I am learning migration in Laravel. I have created a migration file and migrations seems to work fine from command line. But inside my mysql file the username column is not created after migration. Migration file: users table in mysql database: No username column created And when refresh my migration it gives…

Laravel database, what data type should I use to store a passport number?

laravel laravel-8 laravel-migrations mysql php

I’m in the process of developing a Client Registration page for a travel agent. The client needs to save the passport number as a record in the MySQL database. I would like to know the data type ideal for mentioning in the migrations page for storing a Passport number. Usually, a passport number contain…

Should I add ‘ before integers when making an ENUM field

enums laravel laravel-migrations migration php

I want to create a Migration and this Migration has a field named is_active which takes one of 1 or 0 values. So I tried: But I wonder, if this alright or I should write it this way: So which one is true ? Answer You can read in the PHP Docs that string ‘0’,int 0,float 0.0 are considered as

Laravel migration: “Foreign key constraint is incorrectly formed”)

laravel laravel-migrations mysql php

My migration fails when I try to execute php artisan migrate or php artisan migrate:refresh with this error: Code Users Table (migrated successfully) Address Table (fails with error) Answer One of the reasons to work with a framework such as Laravel is syntactic sugar. By following their conventions, you writ…

Running migration from old branch in Laravel

laravel laravel-migrations php

I have a migration file in a Laravel project that sits on a slightly-older branch. In newer branches, newer migrations have been created and ran in production. I have ran the migration in my local …

SQLSTATE[42000]: Syntax error or access violation: 1072 Key column ‘proform_id’ doesn’t exist in table

laravel laravel-migrations mysql php web-frameworks

After php artisan migrate:fresh I get error: SQLSTATE[42000]: Syntax error or access violation: 1072 Key column ‘proform_id’ doesn’t exist in table (SQL: alter table proforms add constraint proforms_proform_id_foreign foreign key (proform_id) references proforms (id) on delete cascade) This …

Laravel 6.5.1 migration Errno: Syntax error or access violation 1064

laravel laravel-migrations php

I tried to do the migration and I ran into this error: Syntax error or access violation 1064. I looked at other similar problems but I couldn’t find the solution to this problem. Please help, and …

Laravel – Change default value eloquent

eloquent laravel laravel-migrations php

Is possible to modify the default value response from Laravel Eloquent? I have an API and my database has a migration payment. My payment has a column integer status. $table->integer(‘status’)-&…

Drop Unique Index Laravel

laravel laravel-5 laravel-migrations php

I kept getting this while run php artisan migrate SQLSTATE[42000]: Syntax error or access violation: 1091 Can’t DROP ’email’; check that column/key exists While I see that email is exist on my database. My migration script. I was trying to drop the unique constraint. Did I forget to clear an…

Laravel Add a new column to existing table in a migration

laravel laravel-migrations php

I can’t figure out how to add a new column to my existing database table using the Laravel framework. I tried to edit the migration file using… In terminal, I execute php artisan migrate:install and migrate. How do I add new columns? Answer To create a migration, you may use the migrate:make comma…