database migration failure
syncdb
works fine, but ./manage.py migrate
fails at
askbot:0012_delete_some_unused_models
with error:
django.db.utils.IntegrityError: (1217, 'Cannot delete or update a parent row: a foreign key constraint fails')
This is with askbot running as an app alongside our own django app. We also use south, our own migrations work fine.
One worry is that, even during the syncdb
, django was reporting:
(1146, "Table 'anywhere.askbot_badgedata' doesn't exist")
But it didn't stop it from doing the syncdb, or the first few migrations. More possibly pertinent traceback:
! Error found during real run of migration! Aborting.
! Since you have a database that does not support running
! schema-altering statements in transactions, we have had
! to leave it in an interim state between migrations.
You *might* be able to recover with: = CREATE TABLE `askbot_authkeyuserassociation`
[etc etc]
Comments