PhotoPost Photo Gallery Sales PhotoPost Sales Toll Free Phone Number
Mon-Fri 9am-4pm EST
  PhotoPost Photo Sharing Photo Gallery    Visualize community tm
| | | | | | | | |

Go Back   PhotoPost Community > PhotoPost Support > PhotoPost Pro Support Forums > Photopost Pro Installation & Upgrades

Photopost Pro Installation & Upgrades If you're having install or upgrade problems

Reply
 
LinkBack Thread Tools Rate Thread Display Modes
Old April 26th, 2010, 10:17 AM   #1 (permalink)
Member
Verified Customer
 
Join Date: Jan 2010
Posts: 104
Error adding new category to the database. Returned id was 0.

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?
Jesh is offline   Reply With Quote
Old April 26th, 2010, 10:27 AM   #2 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 68,070
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.
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote
Old April 26th, 2010, 10:35 AM   #3 (permalink)
Member
Verified Customer
 
Join Date: Jan 2010
Posts: 104
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 is offline   Reply With Quote
Old April 26th, 2010, 10:37 AM   #4 (permalink)
Member
Verified Customer
 
Join Date: Jan 2010
Posts: 104
Maximages is showing " for the argument being passed...? wtf?
Jesh is offline   Reply With Quote
Old April 26th, 2010, 10:38 AM   #5 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 68,070
MYSQL errors in Fresh install on localhost

I would think mysql is in strict mode and you need to set that off.
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote
Old April 26th, 2010, 10:43 AM   #6 (permalink)
Member
Verified Customer
 
Join Date: Jan 2010
Posts: 104
Thanks, all fixed now - thought I had it off, must have forgotten to change it when moving servers.

Thanks again.

Greg
Jesh is offline   Reply With Quote
Old April 26th, 2010, 12:13 PM   #7 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 68,070
No problem enjoy your day glad to help out.
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Error adding new category to the database. Returned id was 0. clothahump Classifieds Bug Reports 8 September 17th, 2007 06:30 PM
Error adding new category to the database. Returned id was 0. goowa Classifieds Bug Reports 7 March 15th, 2007 06:55 AM
Error with 3.51: Error adding new category to the database. Returned id was 0. WebDork Photopost Pro Installation & Upgrades 15 July 17th, 2006 08:03 PM
Error adding new categoryu to the database. Rik Brown ReviewPost Installation & Upgrades 2 May 1st, 2006 03:34 PM
More problem - Error adding new category to the database. Returned id was 0. wrang Photopost Pro Installation & Upgrades 1 November 11th, 2005 06:41 AM


All times are GMT -5. The time now is 02:22 PM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0