Usergroup Update Error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • daPLAYBOY
    New Member
    • Aug 2006
    • 20
    • 4.1.x

    Usergroup Update Error

    Upgraded to 3.8.3, and went to update Usergroup permissions and got this error which prevents me from going forward ...

    PHP Code:
    Database error in vBulletin 3.8.3:

    Invalid SQL:
    UPDATE usergroup SET

    ### UPDATE QUERY GENERATED BY fetch_query_sql() ###
        
    `title` = 'Admin',
        `
    description` = '',
        `
    usertitle` = 'Somebody',
        `
    opentag` = '<b><font color=\"#CD0000\"><i>',
        `
    closetag` = '</i></font></b>',
        `

    WHERE usergroupid=6;

    MySQL Error   : Unknown column 'nbmsgshowchatbox' in 'field list'

    MySQL Version : 5.0.81-community 
    hope you can assist!

    Thanks!
    Last edited by daPLAYBOY; Sun 16 Aug '09, 3:18pm.
  • copiertalk
    Senior Member
    • Oct 2005
    • 851
    • 3.7.x

    #2
    you have a chat box or had a chat box installed and it is causing the error.

    MySQL Error : Unknown column 'nbmsgshowchatbox' in 'field list'
    www.Copiertalk.com - Everything Copier , Printer, Fax

    Comment

    • daPLAYBOY
      New Member
      • Aug 2006
      • 20
      • 4.1.x

      #3
      yes, you're right...have just removed the XML from the ftp includes/xml for that hack, and rebuilt the bitfields...all is well... Thanks for your time!

      Comment

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