vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Usergroup DB error..!? (https://vborg.vbsupport.ru/showthread.php?t=217527)

Gamelobby 06-30-2009 07:26 PM
Usergroup DB error..!?
 
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.
Code:
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 [DATE]1246397481[/DATE] at [TIME]1246397481[/TIME] ---------------

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

--------------- Added [DATE]1246397684[/DATE] at [TIME]1246397684[/TIME] ---------------

Got it. Sorry to post without trying more.

I just installed the mgc_chatbox then uninstalled it.

Lynne 06-30-2009 07:35 PM
Quote:
Originally Posted by Gamelobby (Post 1840369)
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 10: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 10: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 04: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 06:52 AM
Quote:
Originally Posted by Dismounted (Post 1841200)
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..


All times are GMT. The time now is 06:52 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02293 seconds
  • Memory Usage 1,725KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (6)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete