PDA

View Full Version : SQL error when updating usergroups


carolmyt
05-07-2005, 10:51 PM
I'm getting an SQL error when I try to save changes to usergroup permissions. I'm new to SQL, so I'm really not sure what it means or how I fix it. Any help would be appreciated.

Database error in vBulletin 3.0.6:

Invalid SQL: UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
title = 'Moderators',
description = '',
usertitle = '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 = '3',
attachlimit = '500000',
avatarmaxwidth = '130',
avatarmaxheight = '160',
avatarmaxsize = '20000',
profilepicmaxwidth = '100',
profilepicmaxheight = '100',
profilepicmaxsize = '65535',
pmquota = '50',
pmsendmax = '5',
uttstore_discount = '0',
forumpermissions = '2748927',
pmpermissions = '1',
calendarpermissions = '31',
wolpermissions = '3',
adminpermissions = '0',
genericpermissions = '2629263',
genericoptions = '22'
WHERE usergroupid=7
mysql error: Unknown column 'shoutview' in 'field list'

mysql error number: 1054

TIA

Marco van Herwaarden
05-07-2005, 10:55 PM
Looks like you installed the Shoutbox hack, but didn't make the database changes.

carolmyt
05-07-2005, 11:21 PM
There are no database edits. At least, they aren't in the instructions I have.

Paul M
05-08-2005, 12:23 AM
They are probably done by an Install routine you have to run.

Marco van Herwaarden
05-08-2005, 08:43 AM
I suggest you take this question to the support thread for the Shoutbox hack. More chance of a quick and good reply there.

carolmyt
05-08-2005, 02:37 PM
Thanks. I have posted this over at the Shoutbox thread, no response. It seems other people have had this problem, too. I ran the installer, it went to completion with no problems.