The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
Issue on UCP: Social Group Messages
when i select Social Group Messages in my UCP i've the following error ...
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 nWmoderation AS moderation INNER JOIN nWgroupmessage AS groupmessage ON (moderation.primaryid = groupmessage.gmid AND type = 'groupmessage') LEFT JOIN nWuser AS user ON (groupmessage.postuserid = user.userid) LEFt JOIN nWsocialgroup AS socialgroup ON (groupmessage.groupid = socialgroup.groupid) LEFT JOIN nWavatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN nWcustomavatar AS customavatar ON(customavatar.userid = user.userid) WHERE 1=1 AND moderation.dateline >= 1198343179 ORDER BY groupmessage.dateline DESC LIMIT 0, 10; MySQL Error : Column: 'type' in on clause is ambiguous Error Number : 1052 Date : Monday, January 21st 2008 @ 06:06:19 PM Script : http://www.nowhine.net/board/moderation.php?do=viewgms&type=moderated Referrer : http://www.nowhine.net/board/moderation.php?do=viewvms&type=moderated IP Address : XXX.XXX.XXX.XXX Username : ADMIN Classname : vb_database MySQL Version : 4.0.27-standard-log PS. i've just updated my board @ Beta 4 |
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|