On Thu, Oct 27, 2011 at 12:33 PM, Daniele Procida <dani...@vurt.org> wrote: > I keep getting errors like this: > > _mysql_exceptions.OperationalError: (1005, "Can't create table > 'arkestra_medic_dev.#sql-51b_4a8' (errno: 150)") > > when running database management commands (syncdb, south migrate). > > Sometimes those commands work, sometimes they don't; it happens across a > variety of apps. > > I am working on a database that was exported from one system and has been > imported into a new one. > > Running Django 1.3.1. I'm pretty sure the issue is something to do with my > database/setup, rather than anything in the apps involved. > > Any suggestions greatly appreciated. > > Daniele > >
errno 150 indicates that you tried to create an innodb table with an incorrectly formed foreign key constraint. http://dev.mysql.com/doc/refman/5.0/en/innodb-error-codes.html Are you trying to reference a myisam table from an innodb table, or are does the type of the column you are specifying as a foreign key not match the type of the primary key of the table you are referencing? Cheers Tom -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
