django - south :Getting error with migration

[Ram Ganesh]

Hi all

I got this error while migrating app in django. I am using mysql

FATAL ERROR - The following SQL query failed: ALTER TABLE `my_table` ADD CONSTRAINT `my_table_my_field_18bc0d26_uniq` UNIQUE (`my_field`)
The error was: (1062, "Duplicate entry '123' for key 'my_table_my_field_18bc0d26_uniq'")
 ! 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:   - no dry run output for delete_unique_column() due to dynamic DDL, sorry

 ! The South developers regret this has happened, and would
 ! like to gently persuade you to consider a slightly
 ! easier-to-deal-with DBMS (one that supports DDL transactions)
 ! NOTE: The error which caused the migration to fail is further up.

Mysql support south or not?

what should i do?

Thanks,

Ram Ganesh K

[Lachlan Musicman]

Hi Ram

Yep, South supports MySQL - it's that MySQL doesn't support
schema-altering statements in transactions.

The problem is clearly stated - you are trying to make a field unique
despite the data in that field *not* being unique.

In particular, it looks like you have two entries with value '123'

I would restore the DB from a backup and either remove the unique
constraint or one of the records and then running south again?


Cheers
L.

> --
> You received this message because you are subscribed to the Google Groups
> "Django users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to django-users...@googlegroups.com.
> To post to this group, send email to django...@googlegroups.com.
> Visit this group at http://groups.google.com/group/django-users.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/django-users/26a2dd0b-5c75-4af4-8eb5-c66c6d5bc71e%40googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.



--
You have to be really clever to come up with a genuinely dangerous
thought. I am disheartened that people can be clever enough to do that
and not clever enough to do the obvious thing and KEEP THEIR IDIOT
MOUTHS SHUT about it, because it is much more important to sound
intelligent when talking to your friends.
This post was STUPID.
-----------------------------------------------------------------------------------------------------------
The Most Terrifying Thought Experiment of All Time
http://www.slate.com/articles/technology/bitwise/2014/07/roko_s_basilisk_the_most_terrifying_thought_experiment_of_all_time.html