Column 'id' cannot be null

[Uncle Krusty]

I thought I saw the answer to this problem but I'm not able to locate it now. Any ideas?

Script: bulkupload

Query: INSERT INTO pp_photos (id,user,userid,cat,date,title,description,keywords,bigimage,width,height,filesize,medwidth,medheight,medsize,approved,lastpost, watermarked,allowprint,extra1,extra2,extra3,extra4,extra5,extra6,ipaddress,allowrate,allowcoms) values(NULL,'Uncle Krusty', 3, 500, 1189745161, 'P1010016', '', '', 'P1010016.JPG', 640, 480, 70809, 0, 0, 0, 1, 1189745161, 'yes','yes','','','','','','','76.87.120.84','1','1')

Result: Column 'id' cannot be null

Database handle: Resource id #34

[Chuck S]

I would suspect the id field on your photos table has lost its auto increment status. If you need assistance with altering database tables. Basically in your database viewer in your hosting panel try viewing the database and tell me what happens when you run this query and if it fixes things.

ALTER TABLE pp_photos CHANGE id id INT(12) NOT NULL AUTO_INCREMENT;