No announcement yet.

SQL error

  • Filter
  • Time
  • Show
Clear All
new posts

  • SQL error

    We are getting this error since upgrading to 3.8:

    Database error in vBulletin 3.8.0:

    Invalid SQL:

    SELECT count(*)as cnt,max(dateline) as lastupdate
    FROM groupmessage
    WHERE groupid='1';

    MySQL Error : Unknown column 'groupid' in 'where clause'
    Error Number : 1054

  • #2
    vBulletin 3.8.0 doesn't have a groupid field. This is either a file left over from 3.7.X and needs to be updated or an out of date plugin or product. You can make sure that all of your vBulletin files are up to date under Maintenance -> Diagnostics -> Suspect File Versions.
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API - Full / Mobile
    Vote for your favorite feature requests and the bugs you want to see fixed.


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