vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   mysql error in usergroup manager (https://vborg.vbsupport.ru/showthread.php?t=205446)

biggeorge 02-15-2009 12:31 PM
mysql error in usergroup manager
 
Hopefully someone can help me with this error. It's only occurring in the AdminCP in the usergroup manager. Whether I make a change or not, as soon as I click the SAVE button it tosses this error. I'm no expert, but it looks like the Bump - Debump mod. I uninstalled the mod but it's not helping. I've searched my database and cannot find bumpthreadspermissions... but as I said, I'm no expert.

Any help will be more than appreciated.

Code:
Database error in vBulletin 3.8.1:

Invalid SQL:
UPDATE ebusergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
        `title` = 'Registered Users',
        `description` = '',
        `usertitle` = '',
        `opentag` = '',
        `closetag` = '',
        `passwordexpires` = '0',
        `passwordhistory` = '0',
        `bumpthreadspermissions` = '0',
        `bumpthreadslimit` = '',
        `itraderpermissions` = '3',
        `forumpermissions` = '12316927',
        `genericpermissions` = '1577236163',
        `attachlimit` = '0',
        `pmquota` = '1000',
        `pmpermissions` = '1',
        `pmsendmax` = '5',
        `pmthrottlequantity` = '0',
        `calendarpermissions` = '63',
        `wolpermissions` = '1',
        `adminpermissions` = '0',
        `genericpermissions2` = '1',
        `genericoptions` = '62',
        `profilepicmaxwidth` = '250',
        `profilepicmaxheight` = '250',
        `profilepicmaxsize` = '99999',
        `avatarmaxwidth` = '65',
        `avatarmaxheight` = '65',
        `avatarmaxsize` = '20000000',
        `signaturepermissions` = '245759',
        `sigpicmaxwidth` = '320',
        `sigpicmaxheight` = '240',
        `sigpicmaxsize` = '20000',
        `sigmaxrawchars` = '1000',
        `sigmaxchars` = '500',
        `sigmaxlines` = '0',
        `sigmaxsizebbcode` = '7',
        `sigmaximages` = '2',
        `albumpermissions` = '239',
        `albumpicmaxwidth` = '600',
        `albumpicmaxheight` = '600',
        `albumpicmaxsize` = '100000',
        `albummaxpics` = '100',
        `albummaxsize` = '0',
        `usercsspermissions` = '63',
        `visitormessagepermissions` = '55',
        `socialgrouppermissions` = '51063',
        `maximumsocialgroups` = '5',
        `groupiconmaxsize` = '99999',
        `awardpermissions` = '1',
        `fcpermissions` = '1'
WHERE usergroupid=2;

MySQL Error  : Unknown column 'bumpthreadspermissions' in 'field list'
Error Number  : 1054
Request Date  : Sunday, February 15th 2009 @ 09:24:35 AM
Error Date    : Sunday, February 15th 2009 @ 09:24:35 AM
Script        : http://www.extremebusa.com/extreme/admincp/usergroup.php?do=update
Referrer      : http://www.extremebusa.com/extreme/admincp/usergroup.php?do=edit&usergroupid=2
IP Address    : 71.233.34.243
Username      : BigGeorge
Classname    : vb_database
MySQL Version : 4.1.22-standard

biggeorge 02-15-2009 12:37 PM
1 Attachment(s)
I've also noticed this table - which looks like a remneant from the Bump Debump mod.

Attachment 94927

vbplusme 02-15-2009 12:43 PM
looks like usergroup.php still has a query to it too. It deleted the table but not the calls in the file or at least one of the plugins. I think if you copy a clean usergroup.php to your site the error will go away but you will still have some clean up to do in plugins maybe.

snakes1100 02-15-2009 02:54 PM
It appears that you didn't totally remove that addon.

Check your includes/xml folder and make sure there are no remaining files for that addon in that folder.

Make sure when you run the uninstall, it actually removes everything that it added, ie tables, fields, phrases etc

If the addon itself isnt removing all the tables/fields that it added, you will have a harder time removing it.

biggeorge 02-15-2009 04:04 PM
Quote:
Originally Posted by vbplusme (Post 1744803)
looks like usergroup.php still has a query to it too. It deleted the table but not the calls in the file or at least one of the plugins. I think if you copy a clean usergroup.php to your site the error will go away but you will still have some clean up to do in plugins maybe.
I initially tried uploading a clean usergroup.php and that didn't work.

Quote:
Originally Posted by snakes1100 (Post 1744922)
It appears that you didn't totally remove that addon.

Check your includes/xml folder and make sure there are no remaining files for that addon in that folder.
the bumpdebump xml was indeed in there. I deleted it, opened the usergroups manager in the admincp and it instantly rebuilt the tables! Everything is back to normal.

Thank you both for your help :D

snakes1100 02-15-2009 04:13 PM
Your welcome.

Although Busa's are a tad slow! :D


All times are GMT. The time now is 04:48 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
  • (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