I tried to syncdb an app a friend of mine wrote using sqlite3 on my local mysql server. The syncdb throws the following error:
Traceback (most recent call last):
File "D:\My Documents\Dev\open knesset\repository\MyProject\bin\django- script.py", line 37, in <module>
djangorecipe.manage.main('myproject.settings')
File "d:\my documents\dev\myproject\repository\myproject\eggs\djangorecipe-0.2 0-py2.6.egg\djangorecipe\manage.py", line 16, in main
management.execute_manager(mod)
File "d:\my documents\dev\myproject\repository\myproject\parts\django\django\c ore\management__init__.py", line 438, in execute_manager
utility.execute()
File "d:\my documents\dev\myproject\repository\myproject\parts\django\django\c ore\management__init__.py", line 379, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "d:\my documents\dev\myproject\repository\myproject\parts\django\django\c ore\management\base.py", line 191, in run_from_argv
self.execute(args, *options.dict)
File "d:\my documents\dev\myproject\repository\myprojectparts\django\django\co re\management\base.py", line 218, in execute
output = self.handle(args, *options)
File "d:\my documents\dev\myproject\repository\myproject\parts\django\django\c ore\management\base.py", line 347, in handle
return self.handle_noargs(**options)
File "d:\my documents\dev\myproject\repository\myproject\eggs\south-0.7.1-py2. 6.egg\south\management\commands\syncdb.py", line 73, in handle_noargs
syncdb.Command().execute(**options)
File "d:\my documents\dev\open knesset\repository\open- knesset\parts\django\django\core\management\base.py", line 218, in execute
File "d:\my documents\dev\open knesset\repository\open- knesset\parts\django\django\core\management\base.py", line 347, in handle
File "d:\my documents\dev\open knesset\repository\open- knesset\parts\django\django\core\management\commands\syncdb.py", line 95, in handle_noargs
cursor.execute(statement)
File "d:\my documents\dev\myproject\repository\myproject\parts\django\django\d b\backends\util.py", line 15, in execute
return self.cursor.execute(sql, params)
File "d:\my documents\dev\myproject\repository\myproject\parts\django\django\d b\backends\mysql\base.py", line 86, in execute
return self.cursor.execute(query, args)
File "C:\Python26\lib\site-packages\MySQLdb\cursors.py", line 173, in execute
self.errorhandler(self, exc, value)
File "C:\Python26\lib\site-packages\MySQLdb\connections.py", line 36, in defaulterrorhandler
raise errorclass, errorvalue
_mysql_exceptions.OperationalError: (1071, 'Specified key was too long; max key length is 767 bytes')
How can I solve this?
Got a reference to the model? I suspect you have a db_index=True on a TextField
Log in to post a comment.
I tried to syncdb an app a friend of mine wrote using sqlite3 on my local
mysql server. The syncdb throws the following error:
Traceback (most recent call last):
File "D:\My Documents\Dev\open knesset\repository\MyProject\bin\django-
script.py", line 37, in <module>
djangorecipe.manage.main('myproject.settings')
File "d:\my documents\dev\myproject\repository\myproject\eggs\djangorecipe-0.2
0-py2.6.egg\djangorecipe\manage.py", line 16, in main
management.execute_manager(mod)
File "d:\my documents\dev\myproject\repository\myproject\parts\django\django\c
ore\management__init__.py", line 438, in execute_manager
utility.execute()
File "d:\my documents\dev\myproject\repository\myproject\parts\django\django\c
ore\management__init__.py", line 379, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "d:\my documents\dev\myproject\repository\myproject\parts\django\django\c
ore\management\base.py", line 191, in run_from_argv
self.execute(args, *options.dict)
File "d:\my documents\dev\myproject\repository\myprojectparts\django\django\co
re\management\base.py", line 218, in execute
output = self.handle(args, *options)
File "d:\my documents\dev\myproject\repository\myproject\parts\django\django\c
ore\management\base.py", line 347, in handle
return self.handle_noargs(**options)
File "d:\my documents\dev\myproject\repository\myproject\eggs\south-0.7.1-py2.
6.egg\south\management\commands\syncdb.py", line 73, in handle_noargs
syncdb.Command().execute(**options)
File "d:\my documents\dev\open knesset\repository\open-
knesset\parts\django\django\core\management\base.py", line 218, in execute
output = self.handle(args, *options)
File "d:\my documents\dev\open knesset\repository\open-
knesset\parts\django\django\core\management\base.py", line 347, in handle
return self.handle_noargs(**options)
File "d:\my documents\dev\open knesset\repository\open-
knesset\parts\django\django\core\management\commands\syncdb.py", line 95, in
handle_noargs
cursor.execute(statement)
File "d:\my documents\dev\myproject\repository\myproject\parts\django\django\d
b\backends\util.py", line 15, in execute
return self.cursor.execute(sql, params)
File "d:\my documents\dev\myproject\repository\myproject\parts\django\django\d
b\backends\mysql\base.py", line 86, in execute
return self.cursor.execute(query, args)
File "C:\Python26\lib\site-packages\MySQLdb\cursors.py", line 173, in execute
self.errorhandler(self, exc, value)
File "C:\Python26\lib\site-packages\MySQLdb\connections.py", line 36, in
defaulterrorhandler
raise errorclass, errorvalue
_mysql_exceptions.OperationalError: (1071, 'Specified key was too long; max key length is 767 bytes')
How can I solve this?
Got a reference to the model? I suspect you have a db_index=True on a
TextField