#1366 - Incorrect integer value: 'NULL' for column 'cid' at row 1
mybb, mysql
Solution
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.
Problem
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.