The Arcive of vBulletin Modifications Site.

bilgesat · #1 02-05-2018, 03:37 PM

how can i fix this error.
it happens when i add a new group

PHP Code:


			Database error in vBulletin 3.8.9:

Invalid SQL:

### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO usergroup
    (`title`, `description`, `usertitle`, `opentag`, `closetag`, `passwordexpires`, `passwordhistory`, `ispublicgroup`, `canoverride`, `forumpermissions`, `genericpermissions`, `attachlimit`, `pmquota`, `pmpermissions`, `pmsendmax`, `pmthrottlequantity`, `calendarpermissions`, `wolpermissions`, `adminpermissions`, `genericpermissions2`, `genericoptions`, `profilepicmaxwidth`, `profilepicmaxheight`, `profilepicmaxsize`, `avatarmaxwidth`, `avatarmaxheight`, `avatarmaxsize`, `signaturepermissions`, `sigpicmaxwidth`, `sigpicmaxheight`, `sigpicmaxsize`, `sigmaxrawchars`, `sigmaxchars`, `sigmaxlines`, `sigmaxsizebbcode`, `sigmaximages`, `albumpermissions`, `albumpicmaxwidth`, `albumpicmaxheight`, `albumpicmaxsize`, `albummaxpics`, `albummaxsize`, `usercsspermissions`, `visitormessagepermissions`, `socialgrouppermissions`, `maximumsocialgroups`, `groupiconmaxsize`, `vbspacecomments`, `hhroptions`)
VALUES
    ('Yerli ', 'Yerli ', '', '', '', '', '', '0', '0', '651271', '2626563', '1000000', '0', '0', '5', '', '0', '1', '0', '0', '41', '100', '100', '25000', '50', '50', '20000', '0', '', '', '', '', '', '', '7', '', '0', '', '', '', '', '', '0', '0', '0', '', '', '0', '0');

MySQL Error   : Unknown column 'vbspacecomments' in 'field list'
Error Number  : 1054
Request Date  : Monday, February 5th 2018 @ 08:16:58 PM
Error Date    : Monday, February 5th 2018 @ 08:16:58 PM
Script        : http://www.bilgesat.net/admincp/usergroup.php?do=update
Referrer      : http://www.bilgesat.net/admincp/usergroup.php?do=add
IP Address    : *************
Username      : admin
Classname     : vB_Database
MySQL Version : 5.5.57-cll

Dave · #2 02-05-2018, 03:54 PM

Try this https://vborg.vbsupport.ru/showthread.php?t=124511