django迁移文件出现django.db.utils.InternalError: (1050, "Table 'tb_goods_visit' already exists"),问题解决
Traceback (most recent call last): File "manage.py", line 22, in <module> execute_from_command_line(sys.argv) File "D:\python_learn\meiduo_project\env\lib\site-packages\django\core\management\__init__.py", line 364, in execute_from_command_line utility.execute() File "D:\python_learn\meiduo_project\env\lib\site-packages\django\core\management\__init__.py", line 356, in execute self.fetch_command(subcommand).run_from_argv(self.argv) File "D:\python_learn\meiduo_project\env\lib\site-packages\django\core\management\base.py", line 283, in run_from_argv self.execute(*args, **cmd_options) File "D:\python_learn\meiduo_project\env\lib\site-packages\django\core\management\base.py", line 330, in execute output = self.handle(*args, **options) File "D:\python_learn\meiduo_project\env\lib\site-packages\django\core\management\commands\migrate.py", line 202, in handle post_migrate_state = executor.migrate( File "D:\python_learn\meiduo_project\env\lib\site-packages\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 "D:\python_learn\meiduo_project\env\lib\site-packages\django\db\migrations\executor.py", line 145, in _migrate_all_forwards state = self.apply_migration(state, migration, fake=fake, fake_initial=fake_initial) File "D:\python_learn\meiduo_project\env\lib\site-packages\django\db\migrations\executor.py", line 244, in apply_migration state = migration.apply(state, schema_editor) File "D:\python_learn\meiduo_project\env\lib\site-packages\django\db\migrations\migration.py", line 129, in apply operation.database_forwards(self.app_label, schema_editor, old_state, project_state) File "D:\python_learn\meiduo_project\env\lib\site-packages\django\db\migrations\operations\models.py", line 97, in database_forwards schema_editor.create_model(model) File "D:\python_learn\meiduo_project\env\lib\site-packages\django\db\backends\base\schema.py", line 303, in create_model self.execute(sql, params or None) File "D:\python_learn\meiduo_project\env\lib\site-packages\django\db\backends\base\schema.py", line 120, in execute cursor.execute(sql, params) File "D:\python_learn\meiduo_project\env\lib\site-packages\django\db\backends\utils.py", line 79, in execute return super(CursorDebugWrapper, self).execute(sql, params) File "D:\python_learn\meiduo_project\env\lib\site-packages\django\db\backends\utils.py", line 64, in execute return self.cursor.execute(sql, params) File "D:\python_learn\meiduo_project\env\lib\site-packages\django\db\utils.py", line 94, in __exit__ six.reraise(dj_exc_type, dj_exc_value, traceback) File "D:\python_learn\meiduo_project\env\lib\site-packages\django\utils\six.py", line 685, in reraise raise value.with_traceback(tb) File "D:\python_learn\meiduo_project\env\lib\site-packages\django\db\backends\utils.py", line 62, in execute return self.cursor.execute(sql) File "D:\python_learn\meiduo_project\env\lib\site-packages\django\db\backends\mysql\base.py", line 101, in execute return self.cursor.execute(query, args) File "D:\python_learn\meiduo_project\env\lib\site-packages\pymysql\cursors.py", line 170, in execute result = self._query(query) File "D:\python_learn\meiduo_project\env\lib\site-packages\pymysql\cursors.py", line 328, in _query conn.query(q) File "D:\python_learn\meiduo_project\env\lib\site-packages\pymysql\connections.py", line 517, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "D:\python_learn\meiduo_project\env\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result result.read() File "D:\python_learn\meiduo_project\env\lib\site-packages\pymysql\connections.py", line 1075, in read first_packet = self.connection._read_packet() File "D:\python_learn\meiduo_project\env\lib\site-packages\pymysql\connections.py", line 684, in _read_packet packet.check_error() File "D:\python_learn\meiduo_project\env\lib\site-packages\pymysql\protocol.py", line 220, in check_error err.raise_mysql_exception(self._data) File "D:\python_learn\meiduo_project\env\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception raise errorclass(errno, errval) django.db.utils.InternalError: (1050, "Table 'tb_goods_visit' already exists")
1.使用命令 python manage.py migrate --fake 先进行表结构的同步
2.完成后删除make_migrations表中最新的迁移数据,在进行迁移即可
壬戌之秋,七月既望,苏子与客泛舟游于赤壁之下。清风徐来,水波不兴。举酒属客,诵明月之诗,歌窈窕之章。少焉,月出于东山之上,徘徊于斗牛之间。白露横江,水光接天。纵一苇之所如,凌万顷之茫然。浩浩乎如冯虚御风,而不知其所止;飘飘乎如遗世独立,羽化而登仙。
于是饮酒乐甚,扣舷而歌之。歌曰:“桂棹兮兰桨,击空明兮溯流光。渺渺兮予怀,望美人兮天一方。”客有吹洞箫者,倚歌而和之。其声呜呜然,如怨如慕,如泣如诉,余音袅袅,不绝如缕。舞幽壑之潜蛟,泣孤舟之嫠妇。
苏子愀然,正襟危坐而问客曰:“何为其然也?”客曰:“月明星稀,乌鹊南飞,此非曹孟德之诗乎?西望夏口,东望武昌,山川相缪,郁乎苍苍,此非孟德之困于周郎者乎?方其破荆州,下江陵,顺流而东也,舳舻千里,旌旗蔽空,酾酒临江,横槊赋诗,固一世之雄也,而今安在哉?况吾与子渔樵于江渚之上,侣鱼虾而友麋鹿,驾一叶之扁舟,举匏樽以相属。寄蜉蝣于天地,渺沧海之一粟。哀吾生之须臾,羡长江之无穷。挟飞仙以遨游,抱明月而长终。知不可乎骤得,托遗响于悲风。”
苏子曰:“客亦知夫水与月乎?逝者如斯,而未尝往也;盈虚者如彼,而卒莫消长也。盖将自其变者而观之,则天地曾不能以一瞬;自其不变者而观之,则物与我皆无尽也,而又何羡乎!且夫天地之间,物各有主,苟非吾之所有,虽一毫而莫取。惟江上之清风,与山间之明月,耳得之而为声,目遇之而成色,取之无禁,用之不竭,是造物者之无尽藏也,而吾与子之所共适。”
客喜而笑,洗盏更酌。肴核既尽,杯盘狼籍。相与枕藉乎舟中,不知东方之既白。