PDA

View Full Version : Error Message?


Madbatty
09-06-2009, 12:06 PM
I recieve the following error message when I try to updated a user group

Database error in vBulletin 3.8.2:

Invalid SQL:
UPDATE vb_usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Crew',
`description` = 'Design Group',
`usertitle` = '',
`opentag` = '<b><span style=\'color:Blue\'>',
`closetag` = '</span></b>',
`passwordexpires` = '0',
`passwordhistory` = '0',
`ispublicgroup` = '0',
`canoverride` = '0',
`forumpermissions` = '16777207',
`genericpermissions` = '2112749567',
`attachlimit` = '0',
`pmquota` = '200',
`pmpermissions` = '3',
`pmsendmax` = '5',
`pmthrottlequantity` = '0',
`calendarpermissions` = '63',
`wolpermissions` = '29',
`adminpermissions` = '1',
`genericpermissions2` = '1',
`genericoptions` = '56',
`profilepicmaxwidth` = '500',
`profilepicmaxheight` = '300',
`profilepicmaxsize` = '80000',
`avatarmaxwidth` = '150',
`avatarmaxheight` = '150',
`avatarmaxsize` = '30000',
`signaturepermissions` = '235775',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '300',
`sigpicmaxsize` = '0',
`sigmaxrawchars` = '500',
`sigmaxchars` = '300',
`sigmaxlines` = '3',
`sigmaxsizebbcode` = '5',
`sigmaximages` = '0',
`albumpermissions` = '255',
`albumpicmaxwidth` = '1024',
`albumpicmaxheight` = '1024',
`albumpicmaxsize` = '1000000',
`albummaxpics` = '120',
`albummaxsize` = '0',
`usercsspermissions` = '63',
`visitormessagepermissions` = '47',
`socialgrouppermissions` = '65535',
`maximumsocialgroups` = '5',
`groupiconmaxsize` = '80000',
`profileviewpermissions` = '0',
`fcpermissions` = '4',
`minpoststoplay` = '0',
`minreptoplay` = '-1000',
`minreglengthtoplay` = '0'
WHERE usergroupid=10;

MySQL Error : Unknown column 'profileviewpermissions' in 'field list'
Error Number : 14
Request Date : xxxxxxxxxxxxx
Error Date : xxxxxxxxxxxxx
Script : /admincp/usergroup.php?do=update
Referrer : /admincp/usergroup.php?do=edit&usergroupid=10
IP Address : xxxxxxxxxxxxxx
Username : xxxxxxxxxxxxxx
Classname : vB_Database
MySQL Version : 5.0.67-userstats-log

Can someone please tell me how to get rid of that? Thx!

Lynne
09-06-2009, 03:45 PM
There is no column profileviewpermissions in the usergroup table in default vbulletin. So, that is caused by a modification. You either didn't completely uninstall one (uninstall also means to remove all files you uploaded for the mod) or one of them is causing problems and you should disable it.

Madbatty
09-06-2009, 04:38 PM
Fu**ing Hell Lynne I love you bro *kiss* everything is working again !!!