manage.py reset appname fails to reset MySql database because of foreign key constraints
|Reported by:||Jacob Fenwick||Owned by:||nobody|
|Component:||Core (Management commands)||Version:||1.0|
|Has patch:||no||Needs documentation:||no|
|Needs tests:||no||Patch needs improvement:||no|
I'm running the latest Django from SVN on Windows XP using MySQL as the database.
When I try to reset the database the following happens:
C:\projects\django\foo>python manage.py reset fooapp You have requested a database reset. This will IRREVERSIBLY DESTROY any data for the "fooapp" application in the database "foo". Are you sure you want to do this? Type 'yes' to continue, or 'no' to cancel: yes Error: Error: weather couldn't be reset. Possible reasons: * The database isn't running or isn't configured correctly. * At least one of the database tables doesn't exist. * The SQL was invalid. Hint: Look at the output of 'django-admin.py sqlreset fooapp'. That's the SQL t his command wasn't able to run. The full error: (1217, 'Cannot delete or update a parent row: a foreign key cons traint fails')
If I run manage.py sqlreset fooapp and copy the generated SQL into the MySQL command line the tables are recreated correctly.