The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
Getting database error please help urgently
wen im trying to edit usergroup im getting this database error
Database error in vBulletin 3.6.10: Invalid SQL:UPDATE usergroup SET ### UPDATE QUERY GENERATED BY fetch_query_sql() ###`title` = 'Unregistered / Not Logged In',`description` = '',`usertitle` = 'Guest',`opentag` = '',`closetag` = '',`passwordexpires` = '0',`passwordhistory` = '0',`mgccustomusergroupperms` = '0',`nbmsgshowchatbox` = '',`forumpermissions` = '131077',`genericpermissions` = '33554433',`pmquota` = '50',`pmpermissions` = '0',`pmsendmax` = '0',`calendarpermissions` = '1',`wolpermissions` = '0',`genericoptions` = '40',`profilepicmaxwidth` = '100',`profilepicmaxheight` = '100',`profilepicmaxsize` = '65535',`avatarmaxwidth` = '80',`avatarmaxheight` = '80',`avatarmaxsize` = '20000',`signaturepermissions` = '0',`sigpicmaxwidth` = '500',`sigpicmaxheight` = '100',`sigpicmaxsize` = '10000',`sigmaxrawchars` = '1000',`sigmaxchars` = '500',`sigmaxlines` = '0',`sigmaxsizebbcode` = '7',`sigmaximages` = '4',`adminpermissions` = '0'WHERE usergroupid=1; MySQL Error : Unknown column 'mgccustomusergroupperms' in 'field list'Error Number : 1054Date : Saturday, April 26th 2008 @ 10:03:53 PMScript : http://punjabiz-home.com/forum/admin...updateReferrer : http://punjabiz-home.com/forum/admin...sergroupid=1IP Address : 58.106.111.141Username : ADMINClassname : vB_Database plz help me someone |
#2
|
||||
|
||||
This is from a modification you have installed. Disable your plugins to see if it goes away. Then turn them on one by one to figure out which one is causing the problem. Then post in the modification thread to see if someone can help you fix it (or read the thread to see if it's already been fixed).
|
#3
|
|||
|
|||
i just did that but same thing
|
#4
|
||||
|
||||
Did you disable them through config.php? edit config.php and add this line right under <?php
PHP Code:
|
#5
|
||||
|
||||
Have you installed any modifications with MGC in the title or as an abbreviation? That seems to be tho one that is causing you problems. Also, make sure you haven't edited anythinginside of the file from vB. You may have forgotten to remove the code when you uninstalled the product.
|
#6
|
|||
|
|||
yeah i had installed MGC shoutbox but uninstalled it cause it didn;t work
|
#7
|
||||
|
||||
Quote:
ALTER TABLE x DROP mgccustomusergroupperms; Just replace x with the table name (which i don't see in your first post and I cannot look up right now) and make sure you include your table prefix. That should fix your problem. |
#8
|
|||
|
|||
Query
ALTER TABLE 1054 DROP mgccustomusergroupperms vBulletin Message An error occurred while attempting to execute your query. The following information was returned. error number: 1064 error desc: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1054 DROP mgccustomusergroupperms' at line 1 |
#9
|
||||
|
||||
Quote:
|
#10
|
|||
|
|||
how do i find the table name??
|
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|