Clicking on "Social Group Messages" results in :
Code:
Database error in vBulletin 3.7.0 Beta 4: Invalid SQL: SELECT SQL_CALC_FOUND_ROWS groupmessage.*, user.*, groupmessage.ipaddress AS messageipaddress, socialgroup.name ,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight FROM moderation AS moderation INNER JOIN groupmessage AS groupmessage ON (moderation.primaryid = groupmessage.gmid AND 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 moderation.dateline >= 1200047027 ORDER BY groupmessage.dateline DESC LIMIT 0, 10; MySQL Error : Column 'type' in on clause is ambiguous Error Number : 1052 Date : Sunday, February 10th 2008 @ 10:23:47 AM Script : [URL]http://www.********.***/****/moderation.php?do=viewgms&type=moderated[/URL] Referrer : [URL]http://www.********.***/****/moderation.php?do=viewvms&type=moderated&styleid=11[/URL] IP Address : ***.**.***.** Username : **** Classname : vb_database MySQL Version : 4.1.14
Comment