PhotoPost Community - View Single Post

stmpspaz · October 24th, 2006, 08:47 PM

We just upgraded to 5.5 and are no longer able to edit photos - either via admin or users to edit their own uploads.

Users get an error that they are not authorized wait to proceed, then a screen that says photo is not there.

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

Script: editphoto

Query: SELECT p.id,p.cat,c.catname FROM photos p LEFT JOIN 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 #7

October 24th, 2006, 08:47 PM	#1 (permalink)
stmpspaz Member Verified Customer Join Date: Jun 2003 Posts: 110	Unable to Edit Photos We just upgraded to 5.5 and are no longer able to edit photos - either via admin or users to edit their own uploads. Users get an error that they are not authorized wait to proceed, then a screen that says photo is not there. Admin gets: We're sorry, but the system experienced an unrecoverable error. Please try again later. Script: editphoto Query: SELECT p.id,p.cat,c.catname FROM photos p LEFT JOIN 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 #7