View Single Post
Old October 4th, 2008, 07:31 PM   #15 (permalink)
ArchangelX
Member
 
Join Date: Feb 2006
Location: Honolulu, HI
Posts: 83
Okay, I made the change, now I get this error. Must be a few things missing from 3.5. Really weird, because both Photopost Pro and Classifieds work fine. Gar.

Quote:
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.useridLEFT 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 'u.useridLEFT' in 'on clause'

Database handle: Resource id #11
ArchangelX is offline   Reply With Quote