Django South - table already exists

Question

I am trying to get started with South.

I had an existing database.

I added South (syncdb, schemamigration --initial).

I updated models.py to add a field.

I ran ./manage.py schemamigration myapp --auto

It seemed to find the field and said I could apply this with ./manage.py migrate myapp

Doing that gave the error:

django.db.utils.DatabaseError: table "myapp_tablename" already exists

tablename is the first table listed in models.py.

I am running Django 1.2, South 0.7

Answer 1

since you already have the tables created in the database, you just need to run the initial migration as fake

./manage.py migrate myapp --fake

make sure that the schema of models is same as schema of tables in database.

Answer 2

Although the table "myapp_tablename" already exists error stop raising after I did ./manage.py migrate myapp --fake, the DatabaseError shows no such column: myapp_mymodel.added_field.

any hints?