ERROR: "Out of range value adjusted for column"

yahyac

When inserting the shopping cart into my database, I get the following error:

"Out of range value adjusted for column blah blah"

The value that causes the error is the quantity field in the mysql database. This happens when i try to enter a null value for quantity, which is something i will need to do every now and then.

So for now, i simply set quantity to zero before inserting, in those particular cases.

So what is the deal with this error. I have read that it is because of mysql 5.0 and the tighter requirements it has on data.

I've read several sites on google and many immediately say "mysql bug". But i know it is bad to yell "bug!" when in reality, it is most likely a coding problem. So is it that you can't insert a null value into an INT attribute?

Has anyone had this issue before?

Thanks.

iNFERiON

You should be able to insert a null value into an int field, for example by doing this:

mysql_query("INSERT INTO `cart` (product, amount) VALUES ('Deodorant', NULL)");

I know it at least works for auto_increment fields, I have used the above method for that before with success, like:

mysql_query("INSERT INTO `table` (id, name, description) VALUES (NULL, 'Something', 'Little story here'");

Hope that explains a bit.

yahyac

Okay. Well, have you specifically had to insert a NULL value into an INT mysql field that is NOT auto-increment.

Your auto-increment example would work, of course, because the value will not be null. It WILL have a value.

You can read on these links where it talks about the tighter requirements of mysql 5.0 (do you have 5.0 installed) and how mysql 5.0 handles out-of-range issues:
1) http://www.samspublishing.com/articles/article.asp?p=374690&seqNum=3&rl=1

2) http://www.maianscriptworld.co.uk/forum/index.php?action=vthread&forum=3&topic=54

3) http://sourceforge.net/mailarchive/forum.php?thread_id=8881499&forum_id=31882

Ideas? Or again, is this just the reality of mysql 5.0, that you can't insert NULL into an INT field?