getting SQL error

[Pain86]

when i try to edit a user group i get this error

Database error in vBulletin 3.0.6:

Invalid SQL: UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
title = 'V.I.P',
description = '',
usertitle = 'V.I.P Member',
opentag = '#FF0000',
closetag = '',
passwordexpires = '0',
passwordhistory = '0',
ispublicgroup = '0',
canoverride = '0',
canviewarticles = '0',
canviewcomments = '0',
canpostarticles = '0',
cancomment = '0',
canedownart = '0',
canedothart = '0',
candelownart = '0',
candelothart = '0',
canfeature = '0',
cansearchart = '0',
canratearticles = '0',
canviewartmedia = '0',
attachlimit = '1000000',
avatarmaxwidth = '150',
avatarmaxheight = '150',
avatarmaxsize = '20000',
profilepicmaxwidth = '1000',
profilepicmaxheight = '1000',
profilepicmaxsize = '25000',
pmquota = '200',
pmsendmax = '5',
forumpermissions = '1438719',
pmpermissions = '0',
calendarpermissions = '31',
wolpermissions = '1',
adminpermissions = '0',
genericpermissions = '3932159',
genericoptions = '31'
WHERE usergroupid=12
mysql error: Unknown column 'canviewarticles' in 'field list'

mysql error number: 1054

any help?

[Zachery]

mysql error: Unknown column 'canviewarticles' in 'field list'

That is your problem.

[Pain86]

so what do i do to fix it?

[Paul M]

You have obviously installed some sort of articles hack, but it's not installed correctly. You need to re-install it properly, or post in the support topic for the hack you have installed.

[Dionysis]

or just add the column to the table. look up the exact mysql syntax for ALTER table

something like:

"ALTER TABLE <tablename> ADD canviewarticles SMALLINT NOT NULL DEFAULT '0'"

put that in the SQL query section of your phpmyadmin --> after you figure out the right settings.