Django常见错误

这是我用django2.2连接MySQL5.5，迁移时报错

django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required;

解决方案

找到python安装目录下的base.py文件，"C:\Python37\lib\site-packages\django\db\backends\mysql\base.py

注释掉以下两行

    if version < (1, 3, 3):
         raise ImproperlyConfigured("mysqlclient 1.3.3 or newer is required; you have %s" % Database.__version__) 

然后执行迁移语句
接着问题又来了

query = query.decode(errors=‘replace’)
AttributeError: ‘str’ object has no attribute ‘decode’

解决方案

打开File "C:\Python37\lib\site-packages\django\db\backends\mysql\operations.py",把146行的decode修改为encode
原：query = query.decode(errors='replace')
改：query = encode.decode(errors='replace')

Bug

(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降到2.0
MySQL升级

总结

Djando2.1以上不在支持MySQL5.5，各位开发的时候要注意版本之间的兼容问题.