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. On 21 August 2014 23:54, Ram Ganesh <ramganes...@gmail.com> wrote: > > 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 > > > -- > 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+unsubscr...@googlegroups.com. > To post to this group, send email to django-users@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 -- 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+unsubscr...@googlegroups.com. To post to this group, send email to django-users@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/CAGBeqiOR-Xt5ekvnJLMuKnjvnNsjP6r0WuPM-jSVUNO-Poz3sg%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
