Adding category problem

rhys · May 22nd, 2007, 11:50 AM

Hi,

I'm having problems adding categories. Any attempt to add a subcategory, or add a new top level category results in the error:

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

There is no problem with users adding albums.

I've not tried using it until now so I don't know if it has ever been operational.

Any ideas

Rhys

v5.62 btw

Chuck S · May 22nd, 2007, 01:01 PM

In Admin => Global Options set the debug setting to display errors then try adding a category and tell us the exact error here

rhys · May 22nd, 2007, 01:06 PM

This is what I got:

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,'testcategoryname','testcategorydescription','1','yes',1,'','','','', '', '', '', '', '', 'd:/webs/photopost/overlay2.png', '1', '0', '', '', '')

Result: Out of range value adjusted for column 'maximages' at row 1

Database handle: Resource id #5

rhys · May 22nd, 2007, 01:51 PM

think i have sorted the problem

i found a reference to the same problem in another thread and have turned off mysql safe mode

rhys.

btw, it's a nice piece of software

can i add sending ecards to multiple recipients to the wish list ;-)

Chuck S · May 22nd, 2007, 02:27 PM

Yep turning off strict mode should be fine

You can place suggestions for the products in their respective support forums under the suggestions subforum

chartwell · June 18th, 2007, 12:26 PM

I'm having this same error... Anybody know how I can go about turning off mysql safe mode?

Chuck S · June 18th, 2007, 02:15 PM

It is mysql strict mode and your host could do that for you.

chartwell · June 20th, 2007, 09:07 PM

My hosting company won't allow me to do this with any of their shared hosting. Is there another workaround for it?

Chuck S · June 20th, 2007, 09:13 PM

Do you have phpmyadmin access to view the actual database tables?

chartwell · June 20th, 2007, 09:26 PM

yes, I do

Chuck S · June 20th, 2007, 09:32 PM

you can send that url and access to support@photopost.com as well as url and admin login to photopost and we shall see if we can come up with something

touba · September 16th, 2007, 05:15 AM

hi all,

i have exactly the same problem...

but it's strange, it is a new problem, before i can add sub-categories, now i don't

why ?

i didn't change anything...

ps: i have ads classifieds, photopost gallery and reviewpost all in the same database and i have only this problem with ads

Chuck S · September 16th, 2007, 11:33 AM

What is your exact error? Turn on admin global options debug setting to DISPLAY ERRORS.

See if you can post us your exact mysql error.

touba · September 16th, 2007, 05:07 PM

Quote:

Originally Posted by Chuck S

What is your exact error? Turn on admin global options debug setting to DISPLAY ERRORS.

See if you can post us your exact mysql error.

how can i do that ?

Chuck S · September 16th, 2007, 05:28 PM

As the quoted statement says Go to Admin => Global Options and set the debug switch there to display errors and when you try adding a cat you should get the true error displaying now.

touba · September 17th, 2007, 03:44 AM

thanks ChuckS

Code:

Content visible to verified customers only.

Chuck S · September 17th, 2007, 09:05 AM

In adm-misc.php at the top try adding this line in bold

Code:

Content visible to verified customers only.

touba · September 17th, 2007, 02:50 PM

ok chuck i will try... 'cause unforunately i have big trouble to connect to my ftp server...

i'll be back for... feedback !

thank you very much for your eternal support

Chuck S · September 17th, 2007, 03:32 PM

Not a problem talk with ya later.

truthbio · October 9th, 2007, 05:11 PM

Similar problem here. I can add a new catagory if I manually go into my database but cant add it from the admin cp. I read about about the mysql safe mode being off. I checked that and it is set to off. But anyways here is what I get...

Code:

Content visible to verified customers only.

Debug mode shows this...

Code:

Content visible to verified customers only.