View Single Post
Old December 12th, 2006, 11:25 AM   #8 (permalink)
magmf
Junior Member
Verified Customer
 
Join Date: Dec 2006
Posts: 15
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 vbuser u LEFT JOIN vbuserfield uf ON uf.userid=u.userid LEFT JOIN vbsession s ON s.userid=u.userid LEFT JOIN vbusertextfield t ON t.userid=u.userid LEFT JOIN vbavatar AS avatar ON (avatar.avatarid = u.avatarid) LEFT JOIN vbcustomavatar AS customavatar ON (customavatar.userid = u.userid) WHERE u.userid=36026 LIMIT 1

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

Database handle: Resource id #21


i Found this error in debug mode
magmf is offline   Reply With Quote