新增表时报(1005, "Can't create table 'btpmnew.#sql-7ac_188' (errno:121)")错

最新推荐文章于 2022-05-26 20:07:25 发布

cai0611

最新推荐文章于 2022-05-26 20:07:25 发布

阅读量1.7k

点赞数

分类专栏： pthon 文章标签： table django python file manager mysql

本文链接：https://blog.csdn.net/cai0611/article/details/6865450

版权

pthon 专栏收录该内容

9 篇文章 0 订阅

订阅专栏

Creating table pm_snmpmonitorrecord
Traceback (most recent call last):
  File "manage.py", line 11, in <module>
    execute_manager(settings)
  File "C:\Python27\lib\site-packages\django\core\management\__init__.py", line 438, in execute_manager
    utility.execute()
  File "C:\Python27\lib\site-packages\django\core\management\__init__.py", line 379, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File "C:\Python27\lib\site-packages\django\core\management\base.py", line 191, in run_from_argv
    self.execute(*args, **options.__dict__)
  File "C:\Python27\lib\site-packages\django\core\management\base.py", line 220, in execute
    output = self.handle(*args, **options)
  File "C:\Python27\lib\site-packages\django\core\management\base.py", line 351, in handle
    return self.handle_noargs(**options)
  File "C:\Python27\lib\site-packages\django\core\management\commands\syncdb.py", line 99, in handle_noargs
    cursor.execute(statement)
  File "C:\Python27\lib\site-packages\django\db\backends\util.py", line 15, in execute
    return self.cursor.execute(sql, params)
  File "C:\Python27\lib\site-packages\django\db\backends\mysql\base.py", line 86, in execute
    return self.cursor.execute(query, args)
  File "C:\Python27\lib\site-packages\MySQLdb\cursors.py", line 174, in execute
    self.errorhandler(self, exc, value)
  File "C:\Python27\lib\site-packages\MySQLdb\connections.py", line 36, in defaulterrorhandler
    raise errorclass, errorvalue
_mysql_exceptions.OperationalError: (1005, "Can't create table 'btpmnew.#sql-7ac_188' (errno: 121)")
 
我用python.manage.py syncdb将表保存到数据库时报以上错，然后去查看表才发现原来是外键没有创建成功
然后百度了一下，原因找到了，就是其它的表中有外键的名称跟我新增的这张表的外键名称一样才导致创建键失败