PDA

View Full Version : Usergroup DB error..!?


Gamelobby
06-30-2009, 08:26 PM
New problem..

I'm guessing it has nothing to do with the Arcade mod. BUT...

When i try to give usergroups access to arcade, it gives me this error.

Database error in vBulletin 3.8.3:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Registered Users',
`description` = '',
`usertitle` = '',
`opentag` = '<span style=\"color: grey;\">',
`closetag` = '</span>',
`passwordexpires` = '0',
`passwordhistory` = '0',

`forumpermissions` = '12317183',
`genericpermissions` = '1579685575',
`awardpermissions` = '1',
`arcadepermissions` = 'Array',
`minpoststoplay` = '0',
`minreptoplay` = '-1000',
`minreglengthtoplay` = '0',
`mgc_cb_evo_permissions` = '0'
WHERE usergroupid=2;

MySQL Error : Unknown column 'mgc_cb_evo_permissions' in 'field list'
Error Number : 1054
Request Date : Tuesday, June 30th 2009 @ 02:12:20 PM
Error Date : Tuesday, June 30th 2009 @ 02:12:21 PM
Script : http://www.example.com/***/forums/admincp/usergroup.php?do=update
Referrer : http://www.example.com/***/forums/admincp/usergroup.php?do=edit&usergroupid=2
IP Address : **.***.**.***
Username : *********
Classname : vB_Database
MySQL Version : 5.0.67.d7-ourdelta-log

Now the interesting part is that the error relates to a "mgc_cb_evo" chatbox, but that chatbox is not the one that is installed on this board.!!

So im guessing in my dealings earlier today when i had DB issues on another board that is using that mgc chatbox it got screwed up, so i guess im wondering how do i remove this from THIS boards DB.?

On a side note i had issues earlier that may have caused this, but i dont know how, or why.
I was upgrading another board (seperate DB) and in that process somehow got this DB confused, & had the wrong board on the wrong url. But all is fixed now except for this.


Thanks

--------------- Added 1246397481 at 1246397481 ---------------

Also.. FYI. If i disable the Cyb chatbox it works.!

--------------- Added 1246397684 at 1246397684 ---------------

Got it. Sorry to post without trying more.

I just installed the mgc_chatbox then uninstalled it.

Lynne
06-30-2009, 08:35 PM
Now the interesting part is that the error relates to a "mgc_cb_evo" chatbox, but that chatbox is not the one that is installed on this board.!!

....

Also.. FYI. If i disable the Cyb chatbox it works.!
That doesn't make sense. If the chatbox isn't installed on this board, how can you disable it on this board and have it work?

Make sure you have no leftover files from the chatbox uploaded to your server regarding the chatbox modification.

Gamelobby
07-01-2009, 11:24 PM
No i disabled the Cyb chatbox which is the one that is installed, it is the MGC chatbox that was not installed on the board, but i must have installed it in the past and it didn't all get deleted when i uninstalled it.

MAORBARI
07-01-2009, 11:31 PM
in includes dir delete all files with the word MGC after enter XML DIR and delete all files with the word MGC in the name.

Dismounted
07-02-2009, 05:00 AM
If the above poster was not clear enough - you need to remove the modification's files when you uninstall it. Especially the ones in /includes/xml (which is causing the errors).

MAORBARI
07-02-2009, 07:52 AM
If the above poster was not clear enough - you need to remove the modification's files when you uninstall it. Especially the ones in /includes/xml (which is causing the errors).

i sorry for my bad english..