Opened 12 years ago

Last modified 12 years ago

#8200 closed syncdb fails following The flatpages app docs — at Initial Version

Reported by: creecode Owned by: nobody
Component: Uncategorized Version: master
Severity: Keywords:
Cc: Triage Stage: Unreviewed
Has patch: no Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: no UI/UX: no


I was following along with the The flatpages app docs ( ) and when I got to the syncdb step I got the following error.

# syncdb
Creating table django_flatpage
Traceback (most recent call last):

File "[stuff deleted]/", line 11, in <module>


File "/usr/lib/python2.5/site-packages/django/core/management/", line 272, in execute_manager


File "/usr/lib/python2.5/site-packages/django/core/management/", line 219, in execute


File "/usr/lib/python2.5/site-packages/django/core/management/", line 72, in run_from_argv

self.execute(*args, options.dict)

File "/usr/lib/python2.5/site-packages/django/core/management/", line 86, in execute

output = self.handle(*args, options)

File "/usr/lib/python2.5/site-packages/django/core/management/", line 168, in handle

return self.handle_noargs(options)

File "/usr/lib/python2.5/site-packages/django/core/management/commands/", line 91, in handle_noargs


File "/usr/lib/python2.5/site-packages/MySQLdb/", line 166, in execute

self.errorhandler(self, exc, value)

File "/usr/lib/python2.5/site-packages/MySQLdb/", line 35, in defaulterrorhandler

raise errorclass, errorvalue

_mysql_exceptions.OperationalError: (1005, "Can't create table './[stuff deleted]/#sql-48d_41.frm' (errno: 150)")

After some investigation I discovered this error occurs because I use...

DATABASE_OPTIONS = { 'init_command' : 'SET storage_engine = INNODB' } my project settings file, I'm using MySQL for my database. I need to use INNODB files because I am using the binary log feature of MySQL for data recovery in case of disaster. I am using rev 7568 of the development trunk.

Any advice on a work-around welcome.

Change History (0)

Note: See TracTickets for help on using tickets.
Back to Top