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.
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.