Opened 10 years ago

Closed 10 years ago

Last modified 10 years ago

#9348 closed (duplicate) 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
Severity: Keywords: mysql reset
Cc: Triage Stage: Unreviewed
Has patch: no Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: no UI/UX: 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 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 ' 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 sqlreset fooapp and copy the generated SQL into the MySQL command line the tables are recreated correctly.

Change History (3)

comment:1 Changed 10 years ago by Jacob Fenwick

Disregard my comment about the SQL statements working when I pasted them directly into MySQL, they still didn't work.

comment:2 Changed 10 years ago by Russell Keith-Magee

Resolution: duplicate
Status: newclosed

Essentially a duplicate of [2493]

comment:3 Changed 10 years ago by Mike Scott

Err russel means #2493 not [2493]

Note: See TracTickets for help on using tickets.
Back to Top