#9348: manage.py reset appname fails to reset MySql database because of foreign key constraints -----------------------------+---------------------------------------------- Reporter: jfenwick | Owner: nobody Status: new | Milestone: Component: django-admin.py | Version: 1.0 Keywords: mysql reset | Stage: Unreviewed Has_patch: 0 | -----------------------------+---------------------------------------------- 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. -- Ticket URL: <http://code.djangoproject.com/ticket/9348> Django <http://code.djangoproject.com/> The Web framework for perfectionists with deadlines. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django updates" group. To post to this group, send email to django-updates@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-updates?hl=en -~----------~----~----~----~------~----~------~--~---