The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
Database Error
As I open Usergroups in AdminCP and into UserGroup Manager and from there I select Registered Users and into the persmissions setup, in this part there are many like Forum Viewing Permissions Attachment Permissions ect, before this I have a table an unidentified table with no name and four elements ! I cannot modify any permissions as soon as I try I get this error !!!!
Database error in vBulletin 3.8.4: Invalid SQL: UPDATE turkceusergroup SET ### UPDATE QUERY GENERATED BY fetch_query_sql() ### `title` = 'Registered Users', `description` = '', `usertitle` = '', `opentag` = '', `closetag` = '', `passwordexpires` = '0', `passwordhistory` = '0', `profileviewpermissions` = '15', `forumpermissions` = '12317183', `genericpermissions` = '1546131143', `attachlimit` = '100000', `pmquota` = '50', `pmpermissions` = '3', `pmsendmax` = '5', `pmthrottlequantity` = '0', `calendarpermissions` = '63', `wolpermissions` = '1', `adminpermissions` = '0', `genericpermissions2` = '1', `genericoptions` = '62', `profilepicmaxwidth` = '65535', `profilepicmaxheight` = '10000', `profilepicmaxsize` = '65535', `avatarmaxwidth` = '110', `avatarmaxheight` = '110', `avatarmaxsize` = '30000', `signaturepermissions` = '235519', `sigpicmaxwidth` = '500', `sigpicmaxheight` = '100', `sigpicmaxsize` = '20000', `sigmaxrawchars` = '1000', `sigmaxchars` = '500', `sigmaxlines` = '0', `sigmaxsizebbcode` = '7', `sigmaximages` = '5', `albumpermissions` = '255', `albumpicmaxwidth` = '600', `albumpicmaxheight` = '600', `albumpicmaxsize` = '100000', `albummaxpics` = '100', `albummaxsize` = '0', `usercsspermissions` = '63', `visitormessagepermissions` = '63', `socialgrouppermissions` = '51063', `maximumsocialgroups` = '5', `groupiconmaxsize` = '65535' WHERE usergroupid=2; MySQL Error : Unknown column 'profileviewpermissions' in 'field list' Error Number : 1054 Request Date : Thursday, October 15th 2009 @ 11:48:34 PM Error Date : Thursday, October 15th 2009 @ 11:48:34 PM Script : http://mysite.com/myforum/admincp/us....php?do=update Referrer : http://mysite.com/myforum/admincp/us...&usergroupid=2 IP Address : xx.xx.xx.xxx Username : xxxxx Classname : vB_Database MySQL Version : 5.0.32-Debian_7etch11-log please assist |
#2
|
||||
|
||||
Try disabling your modifications/plugins and see if you still have this problem.
Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php PHP Code:
|
#3
|
|||
|
|||
I have tried this method, just as you said, but result is the same ! SoI guess the plugins are not causeing this ?
|
#4
|
||||
|
||||
You may want to put in a Support Ticket if it isn't your modifications causing the problem.
|
#5
|
|||
|
|||
Forgive my ignorence, but how do put a support ticket Lynne ?
|
#6
|
||||
|
||||
<a href="http://members.vbulletin.com/membersupport_contactform.php" target="_blank">Support Ticket System</a>
|
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|