manage.py syncdb fails following The flatpages app docs

[creecode]

I was following along with the The flatpages app docs ( ​http://www.djangoproject.com/documentation/flatpages ) and when I got to the manage.py syncdb step I got the following error.

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

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

execute_manager(settings)

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

utility.execute()

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

self.fetch_command(subcommand).run_from_argv(self.argv)

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

self.execute(*args, options.dict)

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

output = self.handle(*args, options)

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

return self.handle_noargs(options)

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

cursor.execute(statement)

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

self.errorhandler(self, exc, value)

File "/usr/lib/python2.5/site-packages/MySQLdb/connections.py", 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' }

...in 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.