How do I fix MySQL error 150?

How do I fix MySQL error 150?

Altering a table returns an error (errno: 150) if a foreign key definition is incorrectly formed for the altered table. Dropping an index required by a foreign key constraint. The foreign key constraint must be removed before dropping the index.

How do you bypass a foreign key constraint?

Right-click the constraint and select Modify. In the grid under Table Designer, click Enforce Foreign Key Constraint and select No from the drop-down menu. Click Close.

How do I add a foreign key to delete cascade in MySQL?

Alter table to remove Foreign Key or add DELETE CASCADE (MySQL)

1. Step 1 : Get the Foreign Key Name. SHOW CREATE TABLE tableName;
2. Step 2: Drop the Foreign Key. Alter table tableName drop foreign key FK4C5B93445F11A0B7.
3. Step 3: Now add the foreign key constraint back again, this time with ON DELETE CASCADE.

What to do if FOREIGN KEY constraint is incorrectly formed?

CREATE TABLE user ( id INT PRIMARY KEY NOT NULL AUTO_INCREMENT, username VARCHAR (50) NOT NULL, password VARCHAR (64) NOT NULL ); CREATE UNIQUE INDEX user_username_uindex ON user (username); However the second table doesn’t get created and instead throws the error mentioned in the title: “Foreign key constraint is incorrectly formed”.

How to fix Laravel errno 150 foreign key constraint incorrectly formed?

You need to either add the unsigned clause to the id field definitions, or remove the unsigned clause from the foreign key fields. This answer is not better than the six answers before it but it is a more comprehensive answer on what causes laravel-errno-150-foreign-key-constraint-is-incorrectly-formed and how to fix specifically for laravel.

How to avoid mismatch foreign key data type?

In the foreign key column use unsignedBigInteger to avoid mismatch foreign key data type problem . For example let us assume we have two tables questions and replies In my case, the new laravel convention was causing this error. Just by a simple swap of the table creation id did the trick. $table->bigIncrements (‘id’); // was the error.

What causes the latest foreign key error in MySQL?

There is an easy way to find what causes this error you can use: SHOW ENGINE INNODB STATUS; This will show more details on error under section: “LATEST FOREIGN KEY ERROR”. Thanks for contributing an answer to Stack Overflow!