django Warning: (3135, "'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes

waketzheng

于 2017-09-05 11:18:40 发布

阅读量2.1w

点赞数

分类专栏： python django 文章标签： django

本文链接：https://blog.youkuaiyun.com/jaket5219999/article/details/77849213

版权

python 同时被 2 个专栏收录

89 篇文章

订阅专栏

django

17 篇文章

订阅专栏

python manage.py runserver 出现如下警告:

/home/wenjie/work/blockchain-display/env/lib/python3.6/site-packages/pymysql/cursors.py:166: Warning: (3135, "'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.")
result = self._query(query)
/home/wenjie/work/blockchain-display/env/lib/python3.6/site-packages/pymysql/cursors.py:166: Warning: (3090, "Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release.")
result = self._query(query)

settings中做类似如下修改后, 不再报警:

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'OPTIONS': {
            'sql_mode': 'traditional',
        }
    }
}

参考: https://code.djangoproject.com/ticket/15940