mysql error in usergroup manager

[biggeorge]

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.

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]

I've also noticed this table - which looks like a remneant from the Bump Debump mod.

Attachment 94927

[vbplusme]

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]

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]

Originally Posted by vbplusme

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.

Originally Posted by snakes1100

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

[snakes1100]

Your welcome.

Although Busa's are a tad slow!