Django raise MigrationSchemaMissing(Unable to create the django_migrations table (%s) % exc)(亲测)
raise MigrationSchemaMissing(“Unable to create the django_migrations table (%s)” % exc)
django.db.migrations.exceptions.MigrationSchemaMissing: Unable to create the django_migrations table ((1064, “You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘(6) NOT NULL)’ at line 1”))
在使用Django迁移数据时报错
………
主要报错:
raise MigrationSchemaMissing(“Unable to create the django_migrations table (%s)” % exc)
django.db.migrations.exceptions.MigrationSchemaMissing: Unable to create the django_migrations table ((1064, “You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘(6) NOT NULL)’ at line 1”))
Django 执行迁移生成表:
python manage.py migrate
报错:
raise MigrationSchemaMissing(“Unable to create the django_migrations table (%s)” % exc
原因:
Django2.1不再支持MySQL5.5,必须5.6版本以上
查mysql版本和Django版本:
mysql版本:
Django版本:
果然,mysql版本为5.5.62,Django版本为2.1.2,出现问题
解决办法:
二选一
(1)Django降级到2.0
pip install Django==2.0.0 -i https://pypi.douban.com/simple
(2)MySQL升级(自己使用的方案)
参考:http://www.cnblogs.com/yebaofang/p/9863678.html
————————————————
版权声明:本文为CSDN博主「A_Tester」的原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接及本声明。
原文链接:https://blog.csdn.net/weixin\_38917807/article/details/83825719
还没有评论,来说两句吧...