PDA

View Full Version : MySQL Error: Unknown column 'vbspacecomments' in 'field list'


ragintajin
10-24-2006, 06:44 PM
I'm trying to create a new Usergroup and I get this:

Database error in vBulletin 3.6.2:

Invalid SQL:

### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO usergroup
(`title`, `description`, `usertitle`, `opentag`, `closetag`, `passwordexpires`, `passwordhistory`, `ispublicgroup`, `canoverride`, `vbspacecomments`, `arcadepermissions`, `minpoststoplay`, `minreptoplay`, `minreglengthtoplay`, `forumpermissions`, `genericpermissions`, `attachlimit`, `pmquota`, `pmpermissions`, `pmsendmax`, `calendarpermissions`, `wolpermissions`, `adminpermissions`, `genericoptions`, `profilepicmaxwidth`, `profilepicmaxheight`, `profilepicmaxsize`, `avatarmaxwidth`, `avatarmaxheight`, `avatarmaxsize`, `signaturepermissions`, `sigpicmaxwidth`, `sigpicmaxheight`, `sigpicmaxsize`, `sigmaxrawchars`, `sigmaxchars`, `sigmaxlines`, `sigmaxsizebbcode`, `sigmaximages`)
VALUES
('Supporter', 'Helps keep the site alive', '', '<strong>', '</strong>', '0', '0', '0', '0', '0', '63', '', '', '', '775167', '268443207', '0', '70', '3', '5', '49', '1', '0', '63', '100', '100', '100000', '100', '120', '20000', '171519', '500', '100', '20000', '1000', '500', '0', '7', '0');

MySQL Error : Unknown column 'vbspacecomments' in 'field list'
Error Number : 1054
Date : Tuesday, October 24th 2006 @ 03:33:39 PM
Script : http://mysite.com/forums/admincp/usergroup.php?do=update
Referrer : http://mysite.com/forums/admincp/usergroup.php?do=add
Username : me
Classname : vb_database

I searched on vB.org and found this thread (https://vborg.vbsupport.ru/showthread.php?t=124511) that suggested I delete the bitfield_comments.xml file and rebuild the bitfields. When I do that, I get the above error along with this:

Warning: mysql_real_escape_string() expects parameter 1 to be string, array given in /includes/class_core.php on line 648
I've tried disabling Plugins and still no avail.

Any ideas?