“General error: 1005 Can’t create table” Using Laravel Schema Build and Foreign Keys

by

I’ve been having the same problem. I just noticed the following note at the very bottom of the Laravel Schema docs:

Note: The field referenced in the foreign key is very likely an auto increment and therefore automatically an unsigned integer. Please make sure to create the foreign key field with unsigned() as both fields have to be the exact same type, the engine on both tables has to be set to InnoDB, and the referenced table must be created before the table with the foreign key.

For me, as soon as I set my foreign key fields as such:

$table->integer('author')->unsigned();

I had no problem.

EDIT: Also, make sure that the fields in the foreign table are already created, otherwise this may fail with the same error.

More Related Contents:

  1. MySQL Creating tables with Foreign Keys giving errno: 150
  2. MySQL Error 1215: Cannot add foreign key constraint
  3. Mysql error 1452 – Cannot add or update a child row: a foreign key constraint fails
  4. MySQL Cannot Add Foreign Key Constraint
  5. Laravel Migration Error: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes
  6. How to find all tables that have foreign keys that reference particular table.column and have values for those foreign keys?
  7. Can a foreign key reference a non-unique index?
  8. MySQL – Conditional Foreign Key Constraints
  9. MySql Error 150 – Foreign keys
  10. How to change the foreign key referential action? (behavior)
  11. How to truncate a foreign key constrained table?
  12. Force InnoDB to recheck foreign keys on a table/tables?
  13. Is it possible to reference one column as multiple foreign keys?
  14. How to insert values in table with foreign key using MySQL?
  15. Show constraints on tables command
  16. Is there a way to “limit” the result with ELOQUENT ORM of Laravel?
  17. How can I implement single table inheritance using Laravel’s Eloquent?
  18. Meaning of “n:m” and “1:n” in database design
  19. Laravel join with 3 Tables
  20. Laravel Eloquent group by most recent record
  21. MySQL Errno 150
  22. How to use django models with foreign keys in different DBs?
  23. How to remove constraints from my MySQL table?
  24. MySQL DROP all tables, ignoring foreign keys
  25. MySQL “ERROR 1005 (HY000): Can’t create table ‘foo.#sql-12c_4’ (errno: 150)”
  26. MySQL errorno 121
  27. Laravel Eloquent Ignore Casing
  28. Creating MYSQL Procedure in Laravel 4 Migrations
  29. MySQL Relationships
  30. Laravel – search with multiple keywords against multiple columns with the search result to be ordered in relevance

Leave a Comment