我正在尝试运行现有项目。我已还原了数据库并安装了所有必需的依赖项。While运行syncdb时,出现以下错误。你知道吗
[root@localhost ]# python manage.py syncdb
Traceback (most recent call last):
File "manage.py", line 11, in <module>
execute_manager(settings)
File "/usr/local/lib/python2.7/site-packages/django/core/management/__init__.py", line 459, in execute_manager
utility.execute()
File "/usr/local/lib/python2.7/site-packages/django/core/management/__init__.py", line 382, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/usr/local/lib/python2.7/site-packages/django/core/management/base.py", line 196, in run_from_argv
self.execute(*args, **options.__dict__)
File "/usr/local/lib/python2.7/site-packages/django/core/management/base.py", line 231, in execute
self.validate()
File "/usr/local/lib/python2.7/site-packages/django/core/management/base.py", line 266, in validate
num_errors = get_validation_errors(s, app)
File "/usr/local/lib/python2.7/site-packages/django/core/management/validation.py", line 103, in get_validation_errors
connection.validation.validate_field(e, opts, f)
File "/usr/local/lib/python2.7/site-packages/django/db/backends/mysql/validation.py", line 14, in validate_field
db_version = self.connection.get_server_version()
File "/usr/local/lib/python2.7/site-packages/django/db/backends/mysql/base.py", line 415, in get_server_version
self.cursor().close()
File "/usr/local/lib/python2.7/site-packages/debug_toolbar/utils/tracking/__init__.py", line 9, in wrapped
return callback(original, *args, **kwargs)
File "/usr/local/lib/python2.7/site-packages/debug_toolbar/panels/sql.py", line 21, in cursor
result = original(self)
File "/usr/local/lib/python2.7/site-packages/django/db/backends/__init__.py", line 306, in cursor
cursor = self.make_debug_cursor(self._cursor())
File "/usr/local/lib/python2.7/site-packages/django/db/backends/mysql/base.py", line 387, in _cursor
self.connection = Database.connect(**kwargs)
File "/usr/local/lib/python2.7/site-packages/MySQL_python-1.2.3-py2.7-linux-i686.egg/MySQLdb/__init__.py", line 81, in Connect
return Connection(*args, **kwargs)
File "/usr/local/lib/python2.7/site-packages/MySQL_python-1.2.3-py2.7-linux-i686.egg/MySQLdb/connections.py", line 215, in __init__
self.set_character_set(charset)
File "/usr/local/lib/python2.7/site-packages/MySQL_python-1.2.3-py2.7-linux-i686.egg/MySQLdb/connections.py", line 294, in set_character_set
super(Connection, self).set_character_set(charset)
_mysql_exceptions.ProgrammingError: (2014, "Commands out of sync; you can't run this command now")
正如@Kalinakov提到的,这个错误是由于在代码中不正确地使用了游标造成的。请搜索游标.执行然后开始调试。你知道吗
也看看下面的帖子,其中提到了为什么会出现这种错误,以及解决方法是什么- Ways to avoid MySQLdb's "Commands out of sync; you can't run this command now" (2014) exception
让我们开始一个小的调试之旅:
1)数据库配置是否正确? 让我们在没有mySQL数据库和SQlite的情况下尝试一下。如果没有任何编程错误-SQLite将直接启动并同步数据库。为此你得去你的办公室
settings.py
并将数据库重新配置为如下所示:} }
2)现在,运行
syncdb
,看看它是否有效。如果现在可以使用,您可能需要重新配置数据库:name
、password
、host
和port
。如果SQlite不工作-请回到这里告诉我们有确切的错误消息。你在复合sql语句吗?你知道吗
例如:游标.执行('show databases;show tables;')?你知道吗
如果是这样,试着把它们分开:
你知道吗游标.执行('') 光标.关闭 重新连接 重复
相关问题 更多 >
编程相关推荐