id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
8200	manage.py syncdb fails following The flatpages app docs	creecode	nobody	"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."		closed	Uncategorized	dev		worksforme			Unreviewed	0	0	0	0	0	0