No announcement yet.

Upgraded from 3.7.4 to 3.8.4 - social groups not working...

  • Filter
  • Time
  • Show
Clear All
new posts

  • Muzza

    I had not fully extracted all of the new files and therefore hadn't uploaded them all!

    Now fixed!

    Leave a comment:

  • Muzza
    started a topic Upgraded from 3.7.4 to 3.8.4 - social groups not working...

    Upgraded from 3.7.4 to 3.8.4 - social groups not working...

    Social groups are now not working after upgrading to 3.8.4.

    A "database error" occurs when attempting to access the existing social groups:

    Database error in vBulletin 3.8.4:

    Invalid SQL:

    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 = 3
    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
    Any ideas?
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.