15 Feb
If you’re trying to import an sql file using symfony propel-insert-sql and you get this error :
ERROR 1005 (HY000): Can't create table 'Table.frm' (errno: 150)
check this command output it’s really helpful :
mysql>SHOW ENGINE INNODB STATUS;
it will give you the detailed explanation about the most recent innoDB foreign key error.
If you are using a mysqldump file add these commands at the top and bottom of the sql file
SET FOREIGN_KEY_CHECKS = 0; -- TOP SET FOREIGN_KEY_CHECKS = 1; -- BOTTOM
that will disable constraints check
8 Responses
John
23|May|2008 1Thanks for the post! Ya saved me some time this morning :-)
Also, that’s a pretty cool plugin for displaying code (assuming its a plugin).
brainfault
24|May|2008 2you’re welcome ;-)
yes, the plugin is cool you can grab it from http://wordpress.org/extend/plugins/google-syntax-highlighter
Jan
10|Jun|2008 3good!
when I use solidDB ,I meet this question too.
^&^
Tom
29|Jun|2008 4Thanks for that initial post… exactly what I needed.
mark
29|Jul|2008 5i had sucessfully created table on mysql, but frm file the table i was create cann’t found.
please help me..
thanks.
Jacopo agile coach
30|Jul|2008 6Dont’ forget to have the referencing field type matching the referenced field type. Foreign key field must not be too narrow or too wide compared with referenced primary key.
Ciao!
CommanderZ
03|Sep|2008 7Positioning is broken in opera 9.52
Vajahat Ali
08|Sep|2008 8Thanks buddy for the help!!!
Leave a reply
Search
Tag Cloud
django gedit javascript jquery linux mysql oracle php pin propel python selectbox symfony textmateCategories
Blogroll
A design creation of Design Disease
Copyright © 2007 - Brainfault - is proudly powered by WordPress
InSense 1.0 Theme by Design Disease brought to you by HostGator Web Hosting.