PDA

View Full Version : user group Database Error


malluroses
12-16-2008, 09:14 PM
Hai there

problem with user group adding and updating

when ever i add it i get this data base error

Database error in vBulletin 3.7.3:

Invalid SQL:

### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO usergroup
(`title`, `description`, `usertitle`, `opentag`, `closetag`, `passwordexpires`, `passwordhistory`, `ispublicgroup`, `canoverride`, `vbtube`, `fcpermissions`, `displayorder`, `gwallpaperpermissions`, `wpexcludecatlist`, `vbppermissions`, `vbp_discountrate`, `vbp_paycheckamount`, `vbp_secondarycost`, `vbp_primarycost`, `forumpermissions`, `genericpermissions`, `attachlimit`, `pmquota`, `pmpermissions`, `pmsendmax`, `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`)
VALUES
('Rising Member', 'Rising Member', 'Rising Member', '', '', '', '0', '0', '0', '0', '0', '', '0', '', '0', '', '', '', '', '651511', '203954059', '1000000', '0', '0', '5', '0', '1', '0', '0', '41', '100', '100', '25000', '50', '50', '20000', '245759', '', '', '', '', '', '', '7', '', '0', '', '', '', '', '', '0', '0', '0');

MySQL Error : Unknown column 'wpexcludecatlist' in 'field list'
Error Number : 1054
Request Date : Tuesday, December 16th 2008 @ 05:12:38 PM
Error Date : Tuesday, December 16th 2008 @ 05:12:38 PM
Script : http://****/usergroup.php?do=update
Referrer : http://****/usergroup.php?do=add
IP Address : **
Username : ****
Classname : vb_database
MySQL Version : 4.1.22-standard-log

Can someone please guide me through???

Lynne
12-16-2008, 10:39 PM
That's from a modification you installed. You need to disable it or have it fixed in order to get rid of the error. If you need help with a modification, you need to post in the modification thread.