MigrationSchemaMissing: Unableto createthe django_migrations

比眉伴天荒 2022-10-17 00:52 20阅读 0赞

pycharm执行python manage.py migrate时，报错

> 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 correspon  
> ds to your MySQL server version for the right syntax to use near '(6) NOT NULL)' at line 1"))

这是因为Django2.1不再支持MySQL5.5，必须5.6版本以上。。。

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTMyODgxOTA_size_16_color_FFFFFF_t_70][]

所以需要重装mysql为5.6

如果使用的是phpstudy，重装方法[https://shijianfeng.blog.csdn.net/article/details/117428897][https_shijianfeng.blog.csdn.net_article_details_117428897]

[https://blog.csdn.net/weixin\_42591674/article/details/89875981][https_blog.csdn.net_weixin_42591674_article_details_89875981]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTMyODgxOTA_size_16_color_FFFFFF_t_70]: /images/20221014/ec444d799ea840c58d33a431f75150ab.png
[https_shijianfeng.blog.csdn.net_article_details_117428897]: https://shijianfeng.blog.csdn.net/article/details/117428897
[https_blog.csdn.net_weixin_42591674_article_details_89875981]: https://blog.csdn.net/weixin_42591674/article/details/89875981