vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Database Error (https://vborg.vbsupport.ru/showthread.php?t=204567)

Mysterious2207 02-07-2009 05:05 PM
Database Error
 
Got this sent to my email after one of my admins tried to edit one of the user group settings.

Code:
Database error in vBulletin 3.8.1:

Invalid SQL:
UPDATE vbusergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
        `title` = 'Registered Users',
        `description` = '',
        `usertitle` = '',
        `opentag` = '',
        `closetag` = '',
        `passwordexpires` = '0',
        `passwordhistory` = '0',
        `hhroptions` = '0',
        `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',
        `forumpermissions` = '12317183',
        `genericpermissions` = '1579685063',
        `attachlimit` = '0',
        `pmquota` = '50',
        `pmpermissions` = '3',
        `pmsendmax` = '5',
        `pmthrottlequantity` = '0',
        `calendarpermissions` = '63',
        `wolpermissions` = '1',
        `adminpermissions` = '0',
        `genericpermissions2` = '1',
        `genericoptions` = '62',
        `profilepicmaxwidth` = '100',
        `profilepicmaxheight` = '100',
        `profilepicmaxsize` = '65535',
        `avatarmaxwidth` = '80',
        `avatarmaxheight` = '80',
        `avatarmaxsize` = '20000',
        `signaturepermissions` = '137215',
        `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` = '51063',
        `maximumsocialgroups` = '5',
        `groupiconmaxsize` = '65535'
WHERE usergroupid=2;

MySQL Error  : Unknown column 'mgc_cb_evo_permissions' in 'field list'
Error Number  : 1054
Request Date  : Saturday, February 7th 2009 @ 06:34:30 PM
Error Date    : Saturday, February 7th 2009 @ 06:34:30 PM
Script        : http://rslocated.net/admincp/usergroup.php?do=update
Referrer      : http://rslocated.net/admincp/usergroup.php?do=edit&usergroupid=2
IP Address    : 76.108.228.93
Username      : Dan [Heatrepeat]
Classname    : vb_database
MySQL Version : 5.0.67-community
* That happens when i click on update.



Also, their are alot of blanks. This is how it looks:
https://vborg.vbsupport.ru/external/2009/02/93.jpg


I headed over to the forums at www.vbulletin.com and they had told me that
"There is no 'mgc_cb_evo_permissions' field in the default vB database. That query and error is from an add-on you installed. You will need to either remove that add-on or ask for help in the appropriate thread over at www.vbulletin.org. "

How do i know what ad-on it was?

Lynne 02-07-2009 05:21 PM
If you clicked install on the modification, then it should show up in your list of Installed Modification under User CP.

Or you could do a search on the term "mgc_cb_evo*" also in the mods forums and see if it comes up.

Mysterious2207 02-07-2009 05:29 PM
Quote:
Originally Posted by Lynne (Post 1737178)
If you clicked install on the modification, then it should show up in your list of Installed Modification under User CP.

Or you could do a search on the term "mgc_cb_evo*" also in the mods forums and see if it comes up.
Its this mod:
https://vborg.vbsupport.ru/showthread.php?t=168992

I had already uninstalled it, so it doesnt show up in my products. What do i do next?

Lynne 02-07-2009 05:31 PM
You need to make sure that when you uninstall a mod, you also remove all files you uploaded with the mod - like ones in the includes/xml/ directory.

Mysterious2207 02-07-2009 05:33 PM
Quote:
Originally Posted by Lynne (Post 1737185)
You need to make sure that when you uninstall a mod, you also remove all files you uploaded with the mod - like ones in the includes/xml/ directory.
Okay, thank you very much for the help.


All times are GMT. The time now is 11:40 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.01022 seconds
  • Memory Usage 1,731KB
  • 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
  • (5)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