View Full Version : v5.5: "Edit Photo" doesn't work
October 4th, 2006, 09:01 AM
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.
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
October 4th, 2006, 09:09 AM
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?
storeid int(12) NOT NULL default '0',
October 4th, 2006, 09:14 AM
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.
October 4th, 2006, 09:19 AM
In MySQL Administrator, I see this row in the pp_photos table:
Data Type: INT(12)
("Not Null" Checked)
(UNSIGNED NOT CHECKED)
Default Value: 0
October 4th, 2006, 09:36 AM
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
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=0
October 4th, 2006, 01:43 PM
Same here.. the java link option "edit photo" is not working at all..
October 4th, 2006, 03:18 PM
There is no java link for edit photo it is a simple text link the same as it has always been
October 5th, 2006, 09:36 AM
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
October 5th, 2006, 10:05 AM
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
October 5th, 2006, 10:25 AM
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.
October 5th, 2006, 02:09 PM
If they can not edit comments then they cant but given what I see you are allowing them to.
October 6th, 2006, 10:19 AM
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.
October 6th, 2006, 10:29 AM
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
vBulletin® v3.8.1, Copyright ©2000-2014, Jelsoft Enterprises Ltd.