خطئ في المجموعات الإجتماعية
 

السلام عليكم


لذي مشكلة في المجموعات الإجتماعية ارجو المساعة

اقتباس:
Database error in vBulletin 3.8.0:

Invalid SQL:

SELECT SQL_CALC_FOUND_ROWS
gm.*, user.*, gm.ipaddress AS messageipaddress
,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, customavatar.width_thumb AS avwidth_thumb, customavatar.height_thumb AS avheight_thumb, filedata_thumb, NOT ISNULL(customavatar.userid) AS hascustom

FROM groupmessage AS gm
LEFT JOIN user AS user ON (gm.postuserid = user.userid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
LEFT JOIN deletionlog AS deletionlog ON (gm.gmid = deletionlog.primaryid AND deletionlog.type = 'groupmessage')

WHERE gm.groupid = 6
AND (gm.state IN ('visible','moderation','deleted'))

ORDER BY gm.dateline DESC
LIMIT 0, 10;

MySQL Error : Unknown column 'gm.groupid' in 'where clause'
Error Number : 1054
Request Date : Wednesday, May 6th 2009 @ 05:27:13 PM
Error Date : Wednesday, May 6th 2009 @ 05:27:13 PM
Script : http://www.alghiwane.net/vb/group.php?groupid=6
...
MySQL Version : 4.1.21-standard-log