Thread: Forum Home Enhancements - [AJAX] Advanced Forum Statistics
View Single Post
  #4  
Old 18 Mar 2016, 14:27
klaush klaush is offline
 
Join Date: Oct 2005
More details:

Invalid SQL:
SELECT user.userid, user.usergroupid, user.username, user.posts, IF(displaygroupid=0, usergroupid, displaygroupid) AS displaygroupid,

user.avatarid, user.avatarrevision
,
avatar.avatarpath,NOT ISNULL(customavatar.userid) AS hascustomavatar,
customavatar.dateline AS avatardateline, customavatar.width AS avwidth, customavatar.height AS avheight
FROM vb3_user


LEFT JOIN vb_avatar AS avatar ON(avatar.avatarid = user.avatarid)
LEFT JOIN vb_customavatar AS customavatar ON(customavatar.userid = user.userid)

ORDER BY joindate DESC LIMIT 0, 10;

MySQL-Fehler : Unknown column 'user.userid' in 'field list'
Fehler-Nr. : 1054
__________________
Greetings

Klaus
Reply With Quote