The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
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 ------------- |
#2
|
|||
|
|||
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. |
#3
|
||||
|
||||
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).
|
#4
|
|||
|
|||
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.
|
#5
|
|||
|
|||
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. |
#6
|
||||
|
||||
Quote:
|
#7
|
|||
|
|||
More specifically, that is the reason i didnt give the answer, hoping that the user might learn something on their own.
|
#8
|
|||
|
|||
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. |
#9
|
||||
|
||||
MonCher, did you read the above messages? The fix to your problem is posted.
|
#10
|
|||
|
|||
Quote:
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. |
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|