The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
![]()
when i try to edit a user group i get this error
Code:
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 |
#2
|
||||
|
||||
![]() Quote:
|
#3
|
|||
|
|||
![]()
so what do i do to fix it?
|
#4
|
||||
|
||||
![]()
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.
|
#5
|
|||
|
|||
![]()
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. |
![]() |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|