#1366-错误的整数值:第1行的"cid"列为"NULL" [英] #1366 - Incorrect integer value: 'NULL' for column 'cid' at row 1

问题描述

我已经使用XAMPP安装了MyBB local，并且运行顺利.但是，当我在服务器上执行此操作时，它会给我错误.

I have installed MyBB local using XAMPP and it goes smoothly. But when I do it on the server it give me errors.

MyBB自己创建并插入了大量数据，我发现错误出在以下查询中:

MyBB creates and inserts a lot of data by itself and I found out the errors are in queries like:

INSERT INTO... VALUES ('NULL', ...)

在我的本地主机MySQL上(两者均为5.5.27)接受这种查询，其中'NULL'作为字符串传递.但是在服务器中，如标题所示，它会显示错误#1366.

On my localhost MySQL (which is 5.5.27 for both) accepts this kind of query, where 'NULL' is passed as a String. But in the server it gives an error #1366 as the title says.

问题在于更改查询不是一个选择，因为它是很多查询，所以任何人都可以将其配置为可以工作的一个主意?

The problem is that changing the query is not an option since it is A LOT of queries, so anyone has an idea where I can configure this to work?

谢谢.

推荐答案

问题是对于MySQL(在这种情况下) 'NULL'与NULL 不同.

The problem is that for MySQL (in this case) 'NULL' is not the same as NULL.

由于该列需要数字数据，因此您的语句不起作用，而以下内容将起作用:

Due to the fact that the column is expecting numeric data your statement does not work while the following would work:

INSERT INTO ... VALUES (NULL, ...)

......也许您可以更改服务器的MySQL模式正在运行.

... maybe you can change the MySQL mode the server is running on.

这篇关于#1366-错误的整数值:第1行的"cid"列为"NULL"的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！