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]

Originally Posted by Pain86

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.