Announcement

Collapse
No announcement yet.

Database error in vBulletin 4.2.0

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • [Forum] Database error in vBulletin 4.2.0

    Database error in vBulletin 4.2.0:

    Invalid SQL:
    UPDATE usergroup SET

    ### UPDATE QUERY GENERATED BY fetch_query_sql() ###
    `title` = 'SuperStar',
    `description` = '',
    `usertitle` = 'SuperStar',
    `opentag` = '<span style=\"colorrange\" title=\"SuperStar\"><b>',
    `closetag` = '</span></b>',
    `passwordexpires` = '0',
    `passwordhistory` = '0',
    `ispublicgroup` = '0',
    `canoverride` = '0',
    `forumpermissions` = '96205047',
    `genericpermissions` = '1579687623',
    `attachlimit` = '1000000',
    `pmquota` = '50',
    `pmpermissions` = '7',
    `pmsendmax` = '5',
    `pmthrottlequantity` = '0',
    `calendarpermissions` = '63',
    `wolpermissions` = '1',
    `adminpermissions` = '0',
    `genericpermissions2` = '0',
    `genericoptions` = '8',
    `profilepicmaxwidth` = '100',
    `profilepicmaxheight` = '100',
    `profilepicmaxsize` = '25000',
    `avatarmaxwidth` = '50',
    `avatarmaxheight` = '50',
    `avatarmaxsize` = '20000',
    `signaturepermissions` = '0',
    `sigpicmaxwidth` = '0',
    `sigpicmaxheight` = '0',
    `sigpicmaxsize` = '0',
    `sigmaxrawchars` = '0',
    `sigmaxchars` = '0',
    `sigmaxlines` = '0',
    `sigmaxsizebbcode` = '7',
    `sigmaximages` = '0',
    `sigmaxvideos` = '0',
    `albumpermissions` = '0',
    `albumpicmaxwidth` = '0',
    `albumpicmaxheight` = '0',
    `albummaxpics` = '0',
    `albummaxsize` = '0',
    `usercsspermissions` = '0',
    `visitormessagepermissions` = '0',
    `socialgrouppermissions` = '0',
    `maximumsocialgroups` = '0',
    `groupiconmaxsize` = '0',
    `mgc_cb_evo_permissions` = '0',
    `mgc_cb_evo_refreshrate` = '30',
    `mgc_cb_evo_nbmsg_show` = '',
    `mgc_cb_evo_nbmsg_perday_show` = '',
    `mgc_cb_evo_nbthreads_perday_show` = '0',
    `mgc_cb_evo_max_chats_perday` = '0'
    WHERE usergroupid=19;

    MySQL Error : Unknown column 'mgc_cb_evo_permissions' in 'field list'
    Error Number : 1054
    Request Date : Friday, March 1st 2013 @ 09:21:32 PM
    Error Date : Friday, March 1st 2013 @ 09:21:33 PM
    Script : http://www.wwe-tv.com/admincp/usergroup.php?do=update
    Referrer : http://www.wwe-tv.com/admincp/usergr...usergroupid=19
    IP Address : 204.93.60.61
    Username : Desi.Boy
    Classname : vB_Database
    MySQL Version : 5.1.68-cll

  • #2
    That error is from a modification. You will need to uninstall it completely (go through the installation instructions backwards) in order to get rid of the error.

    Please don't PM or VM me for support - I only help out in the threads.
    vBulletin Manual & vBulletin 4.0 Code Documentation (API)
    Want help modifying your vbulletin forum? Head on over to vbulletin.org
    If I post CSS and you don't know where it goes, throw it into the additional.css template.

    W3Schools &lt;- awesome site for html/css help

    Comment


    • #3
      To be more specific it's a chatbox modification and you probably didn't delete the files you uploaded to /includes/xml/ directory.

      Comment


      • #4
        okat thank you sir

        Comment

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