South - How to force certain migration?

Question

I have a migration, 003, that creates a new table, but for some reason, South isn't creating a new table after executing that migration: I am doing the following command:

[kelp@web187 goals]$ python2.7 manage.py migrate main 0003_auto__add_nudge
Running migrations for main:
 - Migrating backwards to just after 0003_auto__add_nudge.
 < main:0006_auto__add_field_nudge_status

But I get the following error:

django.db.utils.DatabaseError: relation "main_nudge" does not exist

It doesn't exist because the migration 003 is supposed to create it. Why do I get this error?

Can you show the actual migration. Include the backwards too, because you are executing that one. — Vladislav Mitov, Sep 11 '12 at 07:45

score 73 · Accepted Answer · answered Sep 11 '12 at 08:04

73

It seems like you've faked migration 0006 forward, you should fake it backward too:

manage.py migrate --fake yourapp 0005

This will set the current migration to 0005.

Apparently, you want to migrate back to 0002:

manage.py migrate --fake yourapp 0002

And then start over at 0003:

manage.py migrate yourapp

answered Sep 11 '12 at 08:04

jpic

32,891
5
112
113

25

Also useful to note the 'zero' keyword works here. If you delete a table and want South to recreate it, you can `manage.py migrate --fake yourapp zero` and then `manage.py migrate yourapp` – IMFletcher Sep 09 '13 at 21:39
2

@IMFletcher Thank you for the tip about the "zero" migration. Note that it also work with Django 1.7 migrations. – Gandirham Sep 05 '14 at 13:29
1

The --fake yourapp zero saved me so much headache!! It works great with Django1.8. – Charles Smith Jan 08 '16 at 10:38
"zero" It works great with Django 1.11, its amazing – Juan Diego Ramirez Oct 12 '22 at 22:00

South - How to force certain migration?

1 Answers1