页面提示：MySQL Error: Field 'user_agent' doesn't have a default value
MYSQL数据库链接正确
安装网页程序时MYSQL数据库错误
答案:2 悬赏:20 手机版
解决时间 2021-06-02 11:24
- 提问者网友：感性作祟
- 2021-06-02 05:44
最佳答案
- 五星知识达人网友：山河有幸埋战骨
- 2021-06-02 07:20
解决方法一：
打开my.ini，查找
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
修改为
sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
然后重启MYSQL
解决方法二：
MySQL 5 uses a strict mode which needs to be disabled.
In Windows, Goto Start-->;Programs-->MySQL->MySQL Instance Config Wizard. Follow through the Reconfigure Instance option-->Detailed Configuration-->Continue Next a few screens. At the bottom under Enable TCP/IP option there is 'Enable Strict Mode'. Deslect this option (no tick). Save changes and MySQL will restart.
打开my.ini，查找
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
修改为
sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
然后重启MYSQL
解决方法二：
MySQL 5 uses a strict mode which needs to be disabled.
In Windows, Goto Start-->;Programs-->MySQL->MySQL Instance Config Wizard. Follow through the Reconfigure Instance option-->Detailed Configuration-->Continue Next a few screens. At the bottom under Enable TCP/IP option there is 'Enable Strict Mode'. Deslect this option (no tick). Save changes and MySQL will restart.
全部回答
- 1楼网友：山君与见山
- 2021-06-02 08:13
'user_agent' 没有插入值 就会报错
你可以在PHPMYADMIN中把'user_agent' 字段默认值设置为NULL即可
我要举报
如以上问答信息为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！
大家都在看
推荐资讯