PDA

View Full Version : Getting database error please help urgently

Senti.Jatt
04-27-2008, 02:09 AM
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/admincp/usergroup.php?do=updateReferrer : http://punjabiz-home.com/forum/admincp/usergroup.php?do=edit&usergroupid=1IP Address : 58.106.111.141Username : ADMINClassname : vB_Database

plz help me someone
Lynne
04-27-2008, 02:21 AM
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).
Senti.Jatt
04-27-2008, 02:45 AM
i just did that but same thing :(
Lynne
04-27-2008, 02:51 AM
Did you disable them through config.php? edit config.php and add this line right under <?php

define('DISABLE_HOOKS', true);
To completely disable mods, you also need to take a look in includes/xml and remove any xml files in there that are from modifications you have installed.
King Kovifor
04-27-2008, 03:09 AM
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.
Senti.Jatt
04-27-2008, 03:11 AM
yeah i had installed MGC shoutbox but uninstalled it cause it didn;t work
King Kovifor
04-27-2008, 03:23 AM
yeah i had installed MGC shoutbox but uninstalled it cause it didn;t work

It would appear that MGC Chat Box doesn't uninstall the tables it added. Try running this query:

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.
Senti.Jatt
04-27-2008, 03:35 AM
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
King Kovifor
04-27-2008, 03:42 AM
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

Your table name is not 1054, I don not see it in the error message above. As I said, I can't look it up, so you won't be able to do it until someone tells you the name or you find it out yourself.
Senti.Jatt
04-27-2008, 03:50 AM
how do i find the table name??
King Kovifor
04-27-2008, 03:52 AM
how do i find the table name??

Go into the maintenance section and choose the back up option. I'd there a usergroup table within that list?
Senti.Jatt
04-27-2008, 04:14 AM
Query
ALTER TABLE usergroup DROP mgccustomusergroupperms

vBulletin Message
An error occurred while attempting to execute your query. The following information was returned.
error number: 1091
error desc: Can't DROP 'mgccustomusergroupperms'; check that column/key exists


says this now :(
King Kovifor
04-27-2008, 04:24 AM
I cannot look it up, but can you post the install codes from the product XML inside of this thread.
Dismounted
04-27-2008, 04:57 AM
It's already dropped ;). The error says that the column does not exist. You have forgotten to remove the bitfield_*.xml file in the /includes/xml directory.
Senti.Jatt
04-27-2008, 06:59 AM
It's already dropped ;). The error says that the column does not exist. You have forgotten to remove the bitfield_*.xml file in the /includes/xml directory.


thanks bro i removed those files and its workin fine now thanks both of u
King Kovifor
04-27-2008, 12:45 PM
It's already dropped ;). The error says that the column does not exist. You have forgotten to remove the bitfield_*.xml file in the /includes/xml directory.

Man, doing this at 1 am isn't a good idea.