Error adding new category to the database. Returned id was 0.

[Jesh]

I am trying to add a new category, and after clicking on 'Add Category' in a subcategory, I am receiving an error: "Error adding new category to the database. Returned id was 0."

Any idea on what the id 0 means?

[Chuck S]

Can you try setting the debug option in global options to display error and then try again and let me know what the error is.

[Jesh]

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

Script:

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,'Zimbabwe','','18','yes',563,'','','','', '8', '1,3,4,8', '1,3,4,8', '1,2,3,4,5,6,7,8', '1,3,4,8', '', '2', '', '', '', '')

Result: Incorrect integer value: '' for column 'maximages' at row 1

Database handle: Resource id #54

[Jesh]

Maximages is showing " for the argument being passed...? wtf?

[Chuck S]

MYSQL errors in Fresh install on localhost

I would think mysql is in strict mode and you need to set that off.

[Jesh]

Thanks, all fixed now - thought I had it off, must have forgotten to change it when moving servers.

Thanks again.

Greg

[Chuck S]

No problem enjoy your day glad to help out.