October 4th, 2008, 01:53 PM
|
#11 (permalink)
|
| Member
Join Date: Feb 2006 Location: Honolulu, HI
Posts: 83
|
Oooh...I see. Thanks alot Chuck, I get it now...so I should add a new field for sig.pic? That's kinda strange though 'cuz all of my sigs are working for my forum? Weird. 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,u.sigpicrevision,p.filename,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 sigpic p ON p.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: Table 'hawaiita_hawaiitalks.sigpic' doesn't exist
Database handle: Resource id #11
| Do you know what the exact query I should run is? Thanks ever so much!
|
| |