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

WebDork · July 10th, 2006, 07:56 PM

I had this error with 3.5 and ugraded to 3.51 but error persists. I have checked my paths and all look okay (was a similar post on this error in the classified product).

I get the same error when trying to add a top level category or a sub category.

WebDork · July 10th, 2006, 08:01 PM

The original problem I am trying to solve is I get an error now when trying to upload new images... I was using mogrify, but that seemed to stop working so I switched to GD2 and I still get "There was an error uploading this photo. Please report to System Administrator." which is of course meaningless. My server logs arent reporting any errors. I know GD works because I use it in another script on the site to create thumbs from forum uploads.

Any ideas ?

Chuck S · July 10th, 2006, 10:40 PM

Make sure you have ran all applicable upgrade scripts. If would appear you have missed running an upgrade

WebDork · July 10th, 2006, 11:03 PM

Script was working fine for ages. I moved servers I think a month ago or so and when I went to upload it kicked up that error. I have copied all .php files across and various templates. I then went back and ran the upgrade.php but it said that all the tables had already been created etc...

WebDork · July 11th, 2006, 06:32 PM

Im still unable to add new categories or upload images. Any ideas what I can do to further check ?

edit: I cant add comments or ratings either. No error message - looks like it works, but returns page and no comments added.

WebDork · July 11th, 2006, 07:37 PM

So - I have reuploaded ALL files except the config file. I re-ran all the upgrades - this resulted in my forum with no files (they were still physically there on hdd, but forum didnt see them and scan removed them), I can regenerate all the thumbnails and medium sized images so I know GD is working. Permissions for data and uploads and their subdirs are all working. Im using php 4.x and mysql 4.x I can move images from dir to dir, but I cant post comments or ratings - no error message - looks like it works, but then then page isnt updated. Safe mode is set to off. register_globals = On - It was off previously, but no change in problem. I can change values in the database admin section. Have run a check and repair on the database - no problems. Have manually looked at the database and data looks fine (ie nothing I can spot)

http://www.arinamanta.com/phpinfo.php if it helps.

I get the same error regardless of what username I log in as.

Becoming frustrating as it is a members section for a friend of mine and we can no longer post updates

WebDork · July 11th, 2006, 07:45 PM

Again - dont know if it helps, but although comments dont display, the email notification of comments comes through eg

Angus has posted a reply about the following photo:

"DSCF5689" - http://www.arinamanta.com/members/sh....php?photo=435

Nice tri's

Chuck S · July 11th, 2006, 07:58 PM

we can not see your site cause it is locked down?

You sure your not using mysql 5? You can also set to display errors to on in the Admin => Global Options which will show us what the true error is here

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

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

Quote:

Originally Posted by Chuck S

You sure your not using mysql 5?

Client API version 4.1.12

Have PM'd you site access details.

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

When trying to post a comment:
We're sorry, but the system experienced an unrecoverable error. Please try again later.

Script: comments

Query: INSERT INTO pp_comments (id,username,userid,date,rating,comment,photo,cat,approved,ipaddress) values(NULL,'Angus','2',1152663704,6,'',1113,521,'1','203.206.240.163')

Result: Column 'id' cannot be null

Database handle: Resource id #7

Chuck S · July 12th, 2006, 12:31 AM

It would indeed appear your server is running mysql in strict mode. id should accept null since id is an auto increment field. We would have to look into this more in depth and do testing but see if your server can not run mysql in strict mode

Chuck S · July 12th, 2006, 09:48 AM

I just saw something on someone else's install. When he installed Photopost his mysql did not set the auto increment field id on most of the tables to auto_increment. Thus use phpmyadmin and check to ensure your id field on the tables are auto_increment

WebDork · July 13th, 2006, 07:46 PM

Quote:

Originally Posted by Chuck S

I just saw something on someone else's install. When he installed Photopost his mysql did not set the auto increment field id on most of the tables to auto_increment. Thus use phpmyadmin and check to ensure your id field on the tables are auto_increment

Yep - this seems to be the problem - Thanks !

Autoincrement is not set and default value is 0.

Is there any easy way to tell me which tables I need to change ?

Chuck S · July 13th, 2006, 09:02 PM

view all of em and check that id field

WebDork · July 17th, 2006, 09:03 PM

That fixed it. Thanks for that.