#1366 - Incorrect integer value: 'NULL' for column 'cid' at row 1
I have installed MyBB local using XAMPP and it goes smoothly. But when I do it on the server it give me errors.
MyBB creates and inserts a lot of data by itself and I found out the errors are in queries like:
INSERT INTO... VALUES ('NULL', ...)
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?
Thanks in advance.
Answer
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, ...)
... maybe you can change the MySQL mode the server is running on.