I have a database table that kicks back the following error message:

"Warning #1366 Incorrect integer value:"

I looked that up on the internet and it says that an empty string is not a valid value, but this is an auto increment field, so one would think it is never empty.

The record layout for this field is: teamID int(6) NOT NULL AUTO_INCREMENT

It doesn't kick out an error when it runs in the php module, only when I insert with phpMayAdmin and even though it states the error, it still correctly INSERTS into the table.

Any help would be appreciated.

Thanks,
robkir

    An empty string is certainly not a valid value for the field definition you posted; a string is not an integer... it's a string. Thus, you should either omit the column altogether from the query or use NULL as its value.

      Hi bradgrafelman,

      Thanks for the info. I fixed the problem.

      robkir

        Write a Reply...