Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

大佬 看来在centOS玩上面有点点不兼容还是咋地 #14

Closed
leixyou opened this issue Nov 9, 2016 · 4 comments
Closed

大佬 看来在centOS玩上面有点点不兼容还是咋地 #14

leixyou opened this issue Nov 9, 2016 · 4 comments

Comments

@leixyou
Copy link

leixyou commented Nov 9, 2016

Traceback (most recent call last):
File "./manage.py", line 22, in
execute_from_command_line(sys.argv)
File "/usr/local/lib/python3.5/site-packages/Django-1.10.3-py3.5.egg/django/core/management/init.py", line 367, in execute_from_command_line
utility.execute()
File "/usr/local/lib/python3.5/site-packages/Django-1.10.3-py3.5.egg/django/core/management/init.py", line 359, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/usr/local/lib/python3.5/site-packages/Django-1.10.3-py3.5.egg/django/core/management/base.py", line 294, in run_from_argv
self.execute(*args, **cmd_options)
File "/usr/local/lib/python3.5/site-packages/Django-1.10.3-py3.5.egg/django/core/management/base.py", line 345, in execute
output = self.handle(*args, **options)
File "/usr/local/lib/python3.5/site-packages/Django-1.10.3-py3.5.egg/django/core/management/commands/migrate.py", line 204, in handle
fake_initial=fake_initial,
File "/usr/local/lib/python3.5/site-packages/Django-1.10.3-py3.5.egg/django/db/migrations/executor.py", line 115, in migrate
state = self._migrate_all_forwards(state, plan, full_plan, fake=fake, fake_initial=fake_initial)
File "/usr/local/lib/python3.5/site-packages/Django-1.10.3-py3.5.egg/django/db/migrations/executor.py", line 145, in _migrate_all_forwards
state = self.apply_migration(state, migration, fake=fake, fake_initial=fake_initial)
File "/usr/local/lib/python3.5/site-packages/Django-1.10.3-py3.5.egg/django/db/migrations/executor.py", line 244, in apply_migration
state = migration.apply(state, schema_editor)
File "/usr/local/lib/python3.5/site-packages/Django-1.10.3-py3.5.egg/django/db/migrations/migration.py", line 129, in apply
operation.database_forwards(self.app_label, schema_editor, old_state, project_state)
File "/usr/local/lib/python3.5/site-packages/Django-1.10.3-py3.5.egg/django/db/migrations/operations/models.py", line 96, in database_forwards
schema_editor.create_model(model)
File "/usr/local/lib/python3.5/site-packages/Django-1.10.3-py3.5.egg/django/db/backends/base/schema.py", line 295, in create_model
self.execute(sql, params or None)
File "/usr/local/lib/python3.5/site-packages/Django-1.10.3-py3.5.egg/django/db/backends/base/schema.py", line 112, in execute
cursor.execute(sql, params)
File "/usr/local/lib/python3.5/site-packages/Django-1.10.3-py3.5.egg/django/db/backends/utils.py", line 79, in execute
return super(CursorDebugWrapper, self).execute(sql, params)
File "/usr/local/lib/python3.5/site-packages/Django-1.10.3-py3.5.egg/django/db/backends/utils.py", line 64, in execute
return self.cursor.execute(sql, params)
File "/usr/local/lib/python3.5/site-packages/Django-1.10.3-py3.5.egg/django/db/utils.py", line 94, in exit
six.reraise(dj_exc_type, dj_exc_value, traceback)
File "/usr/local/lib/python3.5/site-packages/Django-1.10.3-py3.5.egg/django/utils/six.py", line 685, in reraise
raise value.with_traceback(tb)
File "/usr/local/lib/python3.5/site-packages/Django-1.10.3-py3.5.egg/django/db/backends/utils.py", line 62, in execute
return self.cursor.execute(sql)
File "/usr/local/lib/python3.5/site-packages/Django-1.10.3-py3.5.egg/django/db/backends/mysql/base.py", line 110, in execute
return self.cursor.execute(query, args)
File "/usr/local/lib/python3.5/site-packages/MySQLdb/cursors.py", line 250, in execute
self.errorhandler(self, exc, value)
File "/usr/local/lib/python3.5/site-packages/MySQLdb/connections.py", line 42, in defaulterrorhandler
raise errorvalue
File "/usr/local/lib/python3.5/site-packages/MySQLdb/cursors.py", line 247, in execute
res = self._query(query)
File "/usr/local/lib/python3.5/site-packages/MySQLdb/cursors.py", line 411, in _query
rowcount = self._do_query(q)
File "/usr/local/lib/python3.5/site-packages/MySQLdb/cursors.py", line 374, in _do_query
db.query(q)
File "/usr/local/lib/python3.5/site-packages/MySQLdb/connections.py", line 270, in query
_mysql.connection.query(self, query)
django.db.utils.OperationalError: (1071, 'Specified key was too long; max key length is 767 bytes')

@phith0n
Copy link
Owner

phith0n commented Nov 9, 2016

Mooder(Django)不建议使用Mysql作为数据库,请使用Postgres作为数据库。
另外,你这是Mysql引擎Innodb的特点,不要什么都往CentOS上扯。
建议不具备技术基础的用户使用Docker安装Mooder。
Referer: http://stackoverflow.com/questions/1814532/1071-specified-key-was-too-long-max-key-length-is-767-bytes

@phith0n phith0n closed this as completed Nov 9, 2016
@leixyou
Copy link
Author

leixyou commented Nov 10, 2016

可是在ubuntu上却用mysql可以用啊 引擎也是INNODB

@phith0n
Copy link
Owner

phith0n commented Nov 10, 2016

说明可能你装的mysql太老了,stackoverflow上这个问题是11年问的,这都5年了。

@leixyou
Copy link
Author

leixyou commented Nov 10, 2016

谢谢大佬提示 终于弄到了centOS上了

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants