April 26th, 2010, 11:17 AM
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?
April 26th, 2010, 11:27 AM
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.
April 26th, 2010, 11:35 AM
We're sorry, but the system experienced an unrecoverable error. Please try again later.
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
April 26th, 2010, 11:37 AM
Maximages is showing " for the argument being passed...? wtf?
April 26th, 2010, 11:38 AM
I would think mysql is in strict mode and you need to set that off.
April 26th, 2010, 11:43 AM
Thanks, all fixed now - thought I had it off, must have forgotten to change it when moving servers.
April 26th, 2010, 01:13 PM
No problem enjoy your day glad to help out.
vBulletin® v3.8.1, Copyright ©2000-2014, Jelsoft Enterprises Ltd.