Django & South: Adding new field but DatabaseError occurs "table already exists"
django, django-south, python
Solution
You need to do `schemamigration app --initial` first without your new field, then `migrate app --fake 0001` (or whichever migration number it returned) to set the south database to that state (tables already created).
Add your new field, then run `schemamigration myapp --auto`, then migrate.
Problem
In trying to add a new field to a preexisting Model/table, I get a DatabaseError with 'table already exists.' I have run migrations before this one so I am a bit puzzled why adding a new field would pop up this error. Commands executed: ``` python manage.py schemamigration app --auto python manage.py migrate app ``` Previous SO questions like this were answered with faking a migration. ``` python manage.py migrate app --fake python manage.py migrate app ``` The problem that arises from this is that the column is not created. So when you runserver, you will see a DatabaseError 'no such column'. As far as my model, I am only adding a CharField. Thanks in advance for your help-