Mirmo Dynamics - Tag - mysql - Comments

SQLSTATE[HY000]: General error: 1005 Can't create table '*' (errno: 150) - Sander Versluys

Sander Versluys — Sat, 05 Dec 2009 18:55:27 +0100

Thanks for the tip! I'm using Doctrine ORM and use the auto identifier feature. But when writing Many-To-Many classes you have to explicitly declare the length and type of the foreign keys and they did not match the defaults so i changed it appropriately and now it works! Woho! Txn ;-)

SQLSTATE[HY000]: General error: 1005 Can't create table '*' (errno: 150) - Liam Zanoni

Liam Zanoni — Sun, 26 Jul 2009 21:31:06 +0200

This issue most commonly occurs, I think, because the referenced column is not a primary key.

SQLSTATE[HY000]: General error: 1005 Can't create table '*' (errno: 150) - denderello

denderello — Sat, 16 May 2009 09:14:32 +0200

Thanks! Saved me a lot of time. I had to delete the old tables, too. After that everything worked fine.