Database

[Yasser Hamed]

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

[Floris]

That is correct, maxnewtime is unknown in 3.8.0 beta 1.

This is probably from a plugin not compatible with 3.8

[R a K a n]

These are your orders to grow alone

 ALTER TABLE `usergroup` ADD `maxnewtime` INT( 11 ) DEFAULT '0' NOT NULL ; 

  ALTER TABLE `usergroup` ADD `maxnewpost` INT( 11 ) DEFAULT '0' NOT NULL ; 

 ALTER TABLE `usergroup` ADD `maxnewposttime` INT( 11 ) DEFAULT '0' NOT NULL ; 

[Floris]

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.