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 me the below error Option1 : I tried

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 contains one or two English Letters and

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 write less code and have to think about fewer of the

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 is migration which generates error: 2020_08_08_093303_create_dynamic_field.php This is migration asociated with it: 2020_07_29_101958_proforms.php Answer This looks odd to me: It looks like

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 any caches ? Any hints for me ? Answer When dropping

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 command on the Artisan CLI. Use a specific