"Moderated Items" error message

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • beishe8
    Senior Member
    • Oct 2005
    • 6782
    • 4.2.X

    "Moderated Items" error message

    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
    Last edited by beishe8; Sun 10 Feb '08, 1:49am.


    vB5 is unequivocally the best forum software, but not yet...
  • Jose Amaral Rego
    Senior Member
    • Feb 2005
    • 11058
    • 1.1.x

    #2
    It would seem that is a 'Bug' that has been reported and fixed in next version release

    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...