Announcement

Collapse
No announcement yet.

Database

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

  • Database

    If I Chang Promiss


    Database error in vBulletin 3.8.0 Beta 1:

    Invalid SQL:
    UPDATE usergroup SET

    ### UPDATE QUERY GENERATED BY fetch_query_sql() ###
    `title` = 'Super Modertor',
    `description` = '',
    `usertitle` = 'Super Modertor',
    `opentag` = '',
    `closetag` = '',
    `passwordexpires` = '180',
    `passwordhistory` = '360',
    `forumpermissions` = '16777215',
    `genericpermissions` = '2013265727',
    `maxnewthread` = '0',
    `maxnewtime` = '',
    `maxnewpost` = '',
    `maxnewposttime` = '',
    `attachlimit` = '0',
    `pmquota` = '50',
    `pmpermissions` = '7',
    `pmsendmax` = '7',
    `pmthrottlequantity` = '0',
    `calendarpermissions` = '63',
    `wolpermissions` = '31',
    `adminpermissions` = '3',
    `genericpermissions2` = '1',
    `genericoptions` = '55',
    `profilepicmaxwidth` = '100',
    `profilepicmaxheight` = '100',
    `profilepicmaxsize` = '65535',
    `avatarmaxwidth` = '150',
    `avatarmaxheight` = '150',
    `avatarmaxsize` = '20000',
    `signaturepermissions` = '237567',
    `sigpicmaxwidth` = '500',
    `sigpicmaxheight` = '100',
    `sigpicmaxsize` = '10000',
    `sigmaxrawchars` = '0',
    `sigmaxchars` = '0',
    `sigmaxlines` = '0',
    `sigmaxsizebbcode` = '7',
    `sigmaximages` = '0',
    `albumpermissions` = '255',
    `albumpicmaxwidth` = '600',
    `albumpicmaxheight` = '600',
    `albumpicmaxsize` = '100000',
    `albummaxpics` = '100',
    `albummaxsize` = '0',
    `usercsspermissions` = '63',
    `visitormessagepermissions` = '63',
    `socialgrouppermissions` = '32767',
    `maximumsocialgroups` = '5',
    `groupiconmaxsize` = '65535'
    WHERE usergroupid=6;

    MySQL Error : Unknown column 'maxnewtime' in 'field list'
    Error Number : 1054
    Request Date : Friday, October 17th 2008 @ 12:53:44 AM
    Error Date : Friday, October 17th 2008 @ 12:53:44 AM
    Script : http://www.xxx.com/vb/admincp/usergroup.php?do=update
    Referrer : http://www.xxx.com/vb/admincp/usergr...&usergroupid=6
    IP Address : 41.196.49.168
    Username : S P E E D
    Classname : vB_Database
    MySQL Version : 5.0.51a-community
    I Dispaly Prodect
    Yasser Hamdy

  • #2
    That is correct, maxnewtime is unknown in 3.8.0 beta 1.

    This is probably from a plugin not compatible with 3.8

    Comment


    • #3
      These are your orders to grow alone

      PHP Code:
       ALTER TABLE `usergroupADD `maxnewtimeINT11 ) DEFAULT '0' NOT NULL 
      PHP Code:
        ALTER TABLE `usergroupADD `maxnewpostINT11 ) DEFAULT '0' NOT NULL 
      PHP Code:
       ALTER TABLE `usergroupADD `maxnewposttimeINT11 ) DEFAULT '0' NOT NULL 

      Comment


      • #4
        Please note that we do not recommend to just take over custom queries made by other users on the site. If they break your forum, we can't support you.

        Best advice: Make backup of everything before you try.

        Comment

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