v5.5: "Edit Photo" doesn't work

[Matt Gordon]

I click on "Edit Photo" on any photo and get this error:

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

Script:

Query: SELECT p.id,p.cat,c.catname FROM pp_photos p LEFT JOIN pp_categories c ON c.id=p.cat WHERE p.storeid=6 OR p.id=

Result: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3

Database handle: Resource id #6

[Chuck S]

Have you uploaded all the new files and templates? The edit seems to work for me

You variable $storeid is empty and that column in the tables should be 0 if not used so if you look at the photos tables what is there? Did you forget to run any upgrades?

Content visible to verified customers only.

[Matt Gordon]

Yes, I uploaded everything on the list and then ran the upgrade.php (From 5.31 to 5.5). I just ran the upgrade again and got...

Preparing to update database...

Error performing MySQL command: ALTER TABLE pp_photos ADD allowrate INT(1) DEFAULT '1' NOT NULL, ADD allowcoms INT(1) DEFAULT '1' NOT NULL;
Error: Duplicate column name 'allowrate'

Error performing MySQL command: INSERT INTO pp_settings VALUES (220,'Number of minutes a user is allowed to edit a comment?','comtimeout','0 to disable. 86400 is one day.','0',2,7)
Error: Duplicate entry '220' for key 1


Upgrade complete! You may now remove the upgrade.php script.

[Matt Gordon]

In MySQL Administrator, I see this row in the pp_photos table:

storeid
Data Type: INT(12)
("Not Null" Checked)
(UNSIGNED NOT CHECKED)
(ZEROFILL CHECKED)
Default Value: 0

[Chuck S]

So for that Photo your trying to edit is storeid 0

See I am trying to determine why you would get that error since it should be passed the query as this and would be valid. Your storeid is empty which is not normal

Content visible to verified customers only.

[sensimilla]

Same here.. the java link option "edit photo" is not working at all..

[Chuck S]

There is no java link for edit photo it is a simple text link the same as it has always been

[max_view]

Same here... the edit link is not visable for user.

Usergroup has the permission to edit own posts and in Admin Comments Options--> Number of minutes a user is allowed to edit a comment = 900

Testphoto:
http://www.thephotoportal.de/photopo...20&limit=last7
test/test

[Chuck S]

You must set under edit usergroups options ability to edit photos for each usergroup you wish to edit their photos and you can only edit a photo if its your uploaded photo or your a mod or admin so your link is not a good test

If I upload a photo with the user you provided I have an edit photo link

http://www.thephotoportal.de/photopo...o=3843&cat=509

[max_view]

SORRY, Chuck... i took the wrong thread... yes thats right what you said...

but i mean edit the own comment... i back your pardon for the wrong posting.

my Usergruop "USER" cannot edit there own comments, thats what i mean.

[Chuck S]

If they can not edit comments then they cant but given what I see you are allowing them to.

[Matt Gordon]

Also,

It appears index thumbnails aren't being created. When I click on "Make Index Thumb" under a photo, I get the message that I've tagged the photo, but then it takes me to a screen that says, "Photo not found in the database!"

I've re-uploaded ALL files & templates.

Any ideas???

[Chuck S]

Link to your gallery? Photo not found in Database means the photo does not exist or maybe spider urls are on and your server does not process them. turn off in global options the spider setting to no.

Link to your gallery would help us to see your page