Django Is telling me table already exists on syncdb - can't figure out why

Question

Posted the model at http://pastebin.com/f609771cc

getting error: (yes it's windows) File "C:\Python25\lib\site-packages\MySQLdb\connections.py", line 35, in defaulterrorhandler raise errorclass, errorvalue _mysql_exceptions.OperationalError: (1050, "Table 'memorial_music' already exists")

scanned the whole project directory and memorial_music is only referenced twice

once as a table name and once as table name 'memorial_music_category'

this one has me scratching my head, any ideas?

Answer 1

The complaint is that the table already exists in the database. Django cannot update an existing table. You either need to drop the table from the MySQL database, and syncdb again, or manually adjust the table schema to the model.

Answer 2

django-mptt was the culprit

renamed table for memorial_music to memorial_music_library and everything went smooth

thank you django for manage.py sqlall appname