SQL Errors

[Exitilus]

As of lately I've been getting alot of e-mails with a SQL Error.

An error was encountered during execution of the 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=731 LIMIT 1

The query returned with an errorcode of:

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

If you need assistence or feel this is a 'bug'; please report it to our support forums at: http://www.photopost.com/members/forum/f66/index.html

To turn off these emails, set $debug=0 in your config-inc.php file.

[Chuck S]

Your vb has been modified from its default to remove the location field for the user profile which we look for on comments

I would suggest you add field2 back into your userfield table of vb otherwise you need to define a new field and update our vb3.php file to change field2 to another field you want to pull user location from

[Exitilus]

Ahhh Ok. Yah I just changed that Thanks. Now I need to see if i can change that field back to 2 *L*