PhotoPost Community - View Single Post

centralp · July 13th, 2006, 05:17 AM

We installed PP 3 weeks ago and have been testing since.
Just tried rating a photo yesterday and as soon as the rating is submitted, clicking on that photo resulted in an error. Tried another photo and got the same problem. Error message is:
"We're sorry, but the system experienced an unrecoverable error. Please try again later.

Script:

Query: SELECT u.username,u.homepage,u.usertitle,u.posts,u.joindate,uf.field2,s.host,t.signature,avatar.avatarpath, NOT ISNULL(customavatar.filedata) AS hascustomavatar,u.avatarrevision FROM user u LEFT JOIN userfield uf ON uf.userid=u.userid LEFT JOIN session s ON s.userid=u.userid LEFT JOIN usertextfield t ON t.userid=u.userid LEFT JOIN avatar AS avatar ON (avatar.avatarid = u.avatarid) LEFT JOIN customavatar AS customavatar ON (customavatar.userid = u.userid) WHERE u.userid=1 LIMIT 1

Result: Unknown column 'uf.field2' in 'field list'

Database handle: Resource id #10"

Appreciated if U can point us in the right direction to resolve this problem.

July 13th, 2006, 05:17 AM	#4 (permalink)
centralp Junior Member Verified Customer Join Date: Jun 2006 Posts: 1	Error Message We installed PP 3 weeks ago and have been testing since. Just tried rating a photo yesterday and as soon as the rating is submitted, clicking on that photo resulted in an error. Tried another photo and got the same problem. Error message is: "We're sorry, but the system experienced an unrecoverable error. Please try again later. Script: Query: SELECT u.username,u.homepage,u.usertitle,u.posts,u.joindate,uf.field2,s.host,t.signature,avatar.avatarpath, NOT ISNULL(customavatar.filedata) AS hascustomavatar,u.avatarrevision FROM user u LEFT JOIN userfield uf ON uf.userid=u.userid LEFT JOIN session s ON s.userid=u.userid LEFT JOIN usertextfield t ON t.userid=u.userid LEFT JOIN avatar AS avatar ON (avatar.avatarid = u.avatarid) LEFT JOIN customavatar AS customavatar ON (customavatar.userid = u.userid) WHERE u.userid=1 LIMIT 1 Result: Unknown column 'uf.field2' in 'field list' Database handle: Resource id #10" Appreciated if U can point us in the right direction to resolve this problem.