Re: Database management commands

On Thu, Oct 27, 2011 at 12:33 PM, Daniele Procida <daniele@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+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/django-users?hl=en.