PhotoPost Community - View Single Post - Error with 3.51: Error adding new category to the database. Returned id was 0.

WebDork · July 11th, 2006, 08:17 PM

Thanks for tip re turning on debug... Gave me following when I tried to add a category.

We're sorry, but the system experienced an unrecoverable error. Please try again later.

Script: adm-cats

Query: INSERT INTO pp_categories (id,catname,description,catorder,thumbs,parent,header,footer,headtags,password,ugnoview,ugnoupload,ugnopost,ugnoanno,ugnovote,watermark,sortorder,frames,maximages,ratingtype,ismember) VALUES(NULL,'aaa','','19','yes',1,'','','','', '', '', '', '5,1,3,4,2', '', '', '2', '0', '', '', '')

Result: Column 'id' cannot be null

Database handle: Resource id #6

July 11th, 2006, 08:17 PM	#9 (permalink)
WebDork Member Verified Customer Join Date: Apr 2002 Location: Sydney, Australia Posts: 99	Thanks for tip re turning on debug... Gave me following when I tried to add a category. We're sorry, but the system experienced an unrecoverable error. Please try again later. Script: adm-cats Query: INSERT INTO pp_categories (id,catname,description,catorder,thumbs,parent,header,footer,headtags,password,ugnoview,ugnoupload,ugnopost,ugnoanno,ugnovote,watermark,sortorder,frames,maximages,ratingtype,ismember) VALUES(NULL,'aaa','','19','yes',1,'','','','', '', '', '', '5,1,3,4,2', '', '', '2', '0', '', '', '') Result: Column 'id' cannot be null Database handle: Resource id #6