PDA

View Full Version : Super Mod permission Troubles


xTerMn8R
12-19-2004, 04:22 PM
Hi All , I'm trying to add a few feature to my Super Mods permissions and I keep getting a MySQL error 1054 I belive that contains the following:

Database error in vBulletin 3.0.3:

Invalid SQL: UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
title = 'Super Moderators',
description = '',
usertitle = 'Super Moderator',
opentag = '',
closetag = '',
passwordexpires = '0',
passwordhistory = '0',
shoutview = '0',
shoutpost = '0',
shoutmaxdaily = '0',
shoutedit = '0',
shoutdelete = '0',
shouthdelete = '0',
shouteditothers = '0',
shoutdeleteothers = '0',
shouthdeleteothers = '0',
shoutip = '0',
shoutcoventry = '0',
shouthierarchy = '2',
attachlimit = '0',
avatarmaxwidth = '150',
avatarmaxheight = '150',
avatarmaxsize = '40000',
profilepicmaxwidth = '100',
profilepicmaxheight = '100',
profilepicmaxsize = '65535',
pmquota = '50',
pmsendmax = '0',
forumpermissions = '393215',
pmpermissions = '3',
calendarpermissions = '31',
wolpermissions = '15',
adminpermissions = '3',
genericpermissions = '3104623',
genericoptions = '31'
WHERE usergroupid=5
mysql error: Unknown column 'shoutview' in 'field list'

mysql error number: 1054




Any help will be appreciated ...

Thanks...

Paul M
12-19-2004, 05:42 PM
The error tells you what's wrong - you are trying to insert data into a field called "shoutview", and no such field exists in the "usergroup" table you are attempting to update.

xTerMn8R
12-21-2004, 03:27 PM
Ok How do I fix it ?

Paul M
12-21-2004, 05:53 PM
Install the shoutbox hack (https://vborg.vbsupport.ru/showthread.php?t=68861) properly I would think, since those fields appear to be related to it.