Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
1.4k views
in Technique[技术] by (71.8m points)

mysql - #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.

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)

I think your MySQL Server is running in strict mode.

This can be fixed in one of two ways, but you may have to get your hosting company to do this for you.

Method 1: Open the "my.ini" file within the MySQL installation directory and look for something like...

# Set the SQL mode to strict
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

Replace with:

# Set the SQL mode to strict
sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

Method 2:

You may be able to run an SQL query within your database management tool such as phpMyAdmin which can normally be found from your web hosting control panel:

SET @@global.sql_mode= '';

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...