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