easy-thumbnails icon indicating copy to clipboard operation
easy-thumbnails copied to clipboard

easy_thumnails_thumbnails unique constraint error for name, storage_hash

Open jpatel3 opened this issue 12 years ago • 0 comments

While running jenkins in local on test db creation it fails with below error -

Could not remove foreign key contraint: Cannot find a FOREIGN KEY constraint on table easy_thumbnails_source, column storage_new_id Could not remove foreign key contraint: Cannot find a FOREIGN KEY constraint on table easy_thumbnails_thumbnail, column storage_new_id ! 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: = ALTER TABLE easy_thumbnails_thumbnail ADD CONSTRAINT easy_thumbnails_thumbnail_name_5459dbdb6853bb81_uniq UNIQUE (name, storage_hash) []....... ...... File "/Library/Python/2.7/site-packages/easy_thumbnails/migrations/0015_auto__del_unique_thumbnail_name_storage_hash__add_unique_thumbnail_sou.py", line 12, in forwards db.delete_unique('easy_thumbnails_thumbnail', ['name', 'storage_hash']) File "/Library/Python/2.7/site-packages/south/db/generic.py", line 479, in delete_unique raise ValueError("Cannot find a UNIQUE constraint on table %s, columns %r" % (table_name, columns)) ValueError: Cannot find a UNIQUE constraint on table easy_thumbnails_thumbnail, columns ['name', 'storage_hash']

Any idea what might be causing the issue?

Thanks.

jpatel3 avatar Mar 08 '13 17:03 jpatel3