Database error in vBulletin 3
2:
Invalid SQL:
SELECT SQL_CALC_FOUND_ROWS
groupmessage.*, user.*, groupmessage.ipaddress AS messageipaddress, socialgroup.name
,deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason
,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight
FROM deletionlog AS deletionlog
INNER JOIN groupmessage AS groupmessage ON (deletionlog.primaryid = groupmessage.gmid AND deletionlog.type = 'groupmessage')
LEFT JOIN user AS user ON (groupmessage.postuserid = user.userid)
LEFt JOIN socialgroup AS socialgroup ON (groupmessage.groupid = socialgroup.groupid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
WHERE 1=1
AND deletionlog.dateline >= 1250055179
ORDER BY groupmessage.dateline DESC
LIMIT 0, 5;
MySQL Error : Unknown column 'groupmessage.groupid' in 'on clause'
Error Number : 1054
Request Date : Friday, September 11th 2009 @ 12:32:59 AM
Error Date : Friday, September 11th 2009 @ 12:32:59 AM
Script : http://www..net/vb/moderation.php?do...s&type=deleted
Referrer :
IP Address : 000000
Username : 0000000
Classname : vB_Database
MySQL Version : 5.0.81-community
مشكلة وارجوا الحل يااخوان