Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 06-22-2009, 03:37 PM
MonCher MonCher is offline
 
Join Date: Oct 2008
Location: The OC
Posts: 52
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Database Error - Invalid SQL - Update Usergroup Set

vB Version 3.8.2

I received a few error codes in the last couple of days. Does anyone know what I should do with the following error code...

P.S. I did have another Invalid SQL and I ran a repair on the SQL database .... it's really difficult to even get a repair ticket to SiteGround... you just get a series of questions and answers. I'm not sure that running the repair will solve the issue listed below.

It looks like it's asking me to update the moderators - userdroup #7. But I don't understand
Unknown column 'mgc_cb_evo_permissions' in 'field list'. Do you know what am I missing?

Thanks

---------------------
Database error in vBulletin 3.8.2:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Moderators',
`description` = '',
`usertitle` = 'Your Friendly Moderator',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '0',
`forumpermissions` = '12320767',
`genericpermissions` = '1592727247',
`attachlimit` = '0',
`pmquota` = '50',
`pmpermissions` = '7',
`pmsendmax` = '5',
`pmthrottlequantity` = '0',
`calendarpermissions` = '63',
`wolpermissions` = '1',
`adminpermissions` = '0',
`genericpermissions2` = '1',
`genericoptions` = '62',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '50',
`avatarmaxwidth` = '80',
`avatarmaxheight` = '80',
`avatarmaxsize` = '20000',
`signaturepermissions` = '237567',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '10000',
`sigmaxrawchars` = '1000',
`sigmaxchars` = '500',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '4',
`albumpermissions` = '255',
`albumpicmaxwidth` = '600',
`albumpicmaxheight` = '600',
`albumpicmaxsize` = '100000',
`albummaxpics` = '100',
`albummaxsize` = '0',
`usercsspermissions` = '63',
`visitormessagepermissions` = '63',
`socialgrouppermissions` = '51199',
`maximumsocialgroups` = '5',
`groupiconmaxsize` = '50',
`mgc_cb_evo_permissions` = '0',
`mgc_cb_evo_refreshrate` = '30',
`mgc_cb_evo_nbmsg_show` = '',
`mgc_cb_evo_nbmsg_perday_show` = '',
`mgc_cb_evo_max_chats_perday` = '0',
`vbblog_general_permissions` = '521214',
`vbblog_customblocks` = '5',
`vbblog_custompages` = '5',
`vbblog_entry_permissions` = '8191',
`vbblog_comment_permissions` = '974'
WHERE usergroupid=7;

MySQL Error : Unknown column 'mgc_cb_evo_permissions' in 'field list'
Error Number : 1054
Request Date : Saturday, June 20th 2009 @ 06:14:23 PM
Error Date : Saturday, June 20th 2009 @ 06:14:23 PM
Script : http://www.4datetalk.com/forums/admi....php?do=update
Referrer : http://www.4datetalk.com/forums/admi...&usergroupid=7
IP Address : 71.134.158.124
Username : admin
Classname : vB_Database
MySQL Version : 4.1.22-standard-log
Reply
Forward
-------------
Reply With Quote
  #2  
Old 06-22-2009, 04:05 PM
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Location: Michigan
Posts: 3,733
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

1. Remove the hack completely thats related to your error.

2. This is not a server issue, its an installed modification error, please post in the correct forum.
Reply With Quote
  #3  
Old 06-22-2009, 04:46 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

As Anthony stated, this is an error related to a modification. The column 'mgc_cb_evo_permissions' is not a default vbulletin one. You've either installed a modification incorrectly, or not uninstalled it correctly (you need to remove all files related to a modification when you uninstall it, not just disable the plugins).
Reply With Quote
  #4  
Old 06-22-2009, 05:03 PM
MonCher MonCher is offline
 
Join Date: Oct 2008
Location: The OC
Posts: 52
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thank you Lynne and Snakes. I was confused, I thought the server was causing the problem. Now, I can see exactly what you're referring to. It was probably the upgrade to 3.8.2... I didn't realize the hack wasn't upgraded at the same time -- my fault.
Reply With Quote
  #5  
Old 06-22-2009, 05:23 PM
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Location: Michigan
Posts: 3,733
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

It has nothing to do with a upgrade, please read the error msg again.

MySQL Error : Unknown column 'mgc_cb_evo_permissions' in 'field list'

Remove the hack completely from your site, if you do not know what all the hack did when you installed it, re-download it, view its contents and then verify that you removed everything to do with the said hack.

Hacks/Modifications are NOT default functions of the vbulletin system, therefore no hacks/addons that you dl from here or any other site will get upgraded by the default vbulletin system. The vbulletin blog is not even updated with the default vbulletin, its a totally separate program.
Reply With Quote
  #6  
Old 06-23-2009, 09:52 AM
Dismounted's Avatar
Dismounted Dismounted is offline
 
Join Date: Jun 2005
Location: Melbourne, Australia
Posts: 15,047
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by snakes1100 View Post
MySQL Error : Unknown column 'mgc_cb_evo_permissions' in 'field list'

Remove the hack completely from your site, if you do not know what all the hack did when you installed it, re-download it, view its contents and then verify that you removed everything to do with the said hack.
More specifically, you have not removed a bitfield_*.xml file from the /includes/xml directory.
Reply With Quote
  #7  
Old 06-23-2009, 03:12 PM
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Location: Michigan
Posts: 3,733
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Dismounted View Post
More specifically, you have not removed a bitfield_*.xml file from the /includes/xml directory.
More specifically, that is the reason i didnt give the answer, hoping that the user might learn something on their own.
Reply With Quote
  #8  
Old 06-23-2009, 03:20 PM
MonCher MonCher is offline
 
Join Date: Oct 2008
Location: The OC
Posts: 52
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

OMG!!! I removed the chatbox yesterday thinking that was the problem. I just
received a message from Cybernetec saying it had nothing to do with the problem.
I emailed a guy that does some work on the site and he said he doesn't understand
how to fix database errors like these.

I'm lost!!!
Going back to read about bitfield_*.xml files and the includes/xml directory again to
see how I've missed which hack this is.
Reply With Quote
  #9  
Old 06-23-2009, 03:28 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

MonCher, did you read the above messages? The fix to your problem is posted.
Reply With Quote
  #10  
Old 06-23-2009, 05:49 PM
MonCher MonCher is offline
 
Join Date: Oct 2008
Location: The OC
Posts: 52
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Dismounted View Post
More specifically, you have not removed a bitfield_*.xml file from the /includes/xml directory.
Thanks so much Lynne and Dismounted...
I needed to sit back and break for a second...
I'm really trying!

I pretty sure Dismounted gave me the answer here. I read everything again in the manual about removing a product. I know how to do that part after removing the chatbox yesterday. What I'm concerned about is removing the wrong bitfield_*.xml file... just like I removed the wrong hack yesterday. I can't locate the hack that it is associated with. I've had a few hacks put in by paid sources within the past 2 weeks like:

PhotoPost Pro
vBa Links Directory
VBa Dynamics
VBSEO

I don't have the files associated with those hacks because I paid for their installation. So, I think that removing a file bitfield_*.xml without knowing the hack and removing it will create more problems . I think I should send the error to the vendors who installed the hacks.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 09:43 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04188 seconds
  • Memory Usage 2,260KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (3)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (10)postbit_onlinestatus
  • (10)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete