Incorrect integer value: '' for column 'id' at row 1

[rarebit]

Hi,

 

I wrote some code a fair while ago now and just trying to use it again. The code works fine on my Linux distro, but on Windows i'm getting an error...

 

 

 

MYSQL ERROR: Incorrect integer value: '' for column 'id' at row 1

USING: INSERT INTO log_rec VALUES('','127.0.0.1','1370900361','404','GET','xyz',xyz','xyz')

 

Basically 'id' is an int not null autoincrement, and I pass it an empty string.

 

Do you know what the issue is?

[requinix]

You can't use an empty string for an INT AUTO_INCREMENT. Either omit the column entirely or use NULL (or 0) as the value.

[rarebit]

You're a star, thankyou