I'm running on Windows 7, Python 2.4 and Django 1.2.1
I'm trying to change one table "facility" by dropping it and then
letting syncdb recreate it. I thought syncdb was supposed to ignore
already created tables, but that does not appear to be the case.
What am I doing wrong?
>python manage.py syncdb
Creating table facility
Creating table Assessment
Traceback (most recent call last):
File "manage.py", line 11, in ?
execute_manager(settings)
File
"c:\alltools\python\Lib\site-packages\django\core\management\__init__.py
", line 438, in execute_manager
utility.execute()
File
"c:\alltools\python\Lib\site-packages\django\core\management\__init__.py
", line 379, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File
"c:\alltools\python\Lib\site-packages\django\core\management\base.py",
line 191, in run_from_argv
self.execute(*args, **options.__dict__)
File
"c:\alltools\python\Lib\site-packages\django\core\management\base.py",
line 218, in execute
output = self.handle(*args, **options)
File
"c:\alltools\python\Lib\site-packages\django\core\management\base.py",
line 347, in handle
return self.handle_noargs(**options)
File
"c:\alltools\python\Lib\site-packages\django\core\management\commands\sy
ncdb.py", line 95, in handle_noargs
cursor.execute(statement)
File
"c:\alltools\python\Lib\site-packages\django\db\backends\util.py", line
15, in execute
return self.cursor.execute(sql, params)
File
"c:\alltools\python\Lib\site-packages\django\db\backends\mysql\base.py",
line 86, in execute
return self.cursor.execute(query, args)
File
"c:\alltools\python\lib\site-packages\mysql_python-1.2.2-py2.4-win32.egg
\MySQLdb\cursors.py", line 166, in execute
File
"c:\alltools\python\lib\site-packages\mysql_python-1.2.2-py2.4-win32.egg
\MySQLdb\connections.py", line 35, in defaulterrorhandler
_mysql_exceptions.OperationalError: (1050, "Table 'assessment' already
exists")
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en.
