Bug Database error

[Morrus]

Installed OK. Went to give myself ability to view the downloads area and got the following database error.

Database error in vBulletin 4.2.2:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
	`title` = 'Administrators',
	`description` = '',
	`usertitle` = 'Administrator',
	`opentag` = '<font color=\"#4CC417\">',
	`closetag` = '</font>',
	`passwordexpires` = '0',
	`passwordhistory` = '0',
	`dbtech_vbshoppermissions` = '43',
	`dbtech_userthreads_permissions` = '0',
	`dbtech_vbquiz_permissions` = '30',
	`dbtech_vbquiz_entry_permissions` = '6',
	`dbtech_vbquiz_maxretries` = '0',
	`dbtech_vbquiz_entryminrep` = '0',
	`dbtech_vbquiz_entryminposts` = '0',
	`dbtech_vbquiz_admin_permissions` = '254',
	`dbtech_vbactivitypermissions` = '3',
	`dbtech_vbactivity_requestdelay` = '1',
	`dbtech_vbactivity_nominatedelay` = '1',
	`usernamechangepermissions` = '15',
	`dbtech_username_changedelay` = '21',
	`dbtech_username_historylimit` = '5',
	`dbtech_username_numchanges` = '5',
	`dbtech_username_minposts` = '',
	`dndccpermissions` = '1',
	`psiwd_options` = '1',
	`forumpermissions` = '134217727',
	`attachlimit` = '0',
	`vbblog_general_permissions` = '524286',
	`vbblog_customblocks` = '5',
	`vbblog_custompages` = '5',
	`vbblog_entry_permissions` = '57343',
	`vbblog_comment_permissions` = '3038',
	`trgpermissions` = '15',
	`dbtech_usertagpermissions` = '2',
	`creditspermissions` = '28',
	`credits_charge` = '1',
	`vw_misc` = '2',
	`genericpermissions` = '2112880639',
	`pmquota` = '1000',
	`pmpermissions` = '7',
	`pmsendmax` = '5',
	`pmthrottlequantity` = '0',
	`calendarpermissions` = '63',
	`wolpermissions` = '31',
	`adminpermissions` = '3',
	`genericpermissions2` = '7',
	`genericoptions` = '62',
	`profilepicmaxwidth` = '100',
	`profilepicmaxheight` = '100',
	`profilepicmaxsize` = '1000000',
	`avatarmaxwidth` = '100',
	`avatarmaxheight` = '100',
	`avatarmaxsize` = '5000',
	`signaturepermissions` = '499711',
	`sigpicmaxwidth` = '500',
	`sigpicmaxheight` = '100',
	`sigpicmaxsize` = '20000',
	`sigmaxrawchars` = '0',
	`sigmaxchars` = '0',
	`sigmaxlines` = '0',
	`sigmaxsizebbcode` = '7',
	`sigmaximages` = '0',
	`sigmaxvideos` = '0',
	`albumpermissions` = '255',
	`albumpicmaxwidth` = '800',
	`albumpicmaxheight` = '800',
	`albummaxpics` = '100',
	`albummaxsize` = '0',
	`usercsspermissions` = '191',
	`visitormessagepermissions` = '63',
	`socialgrouppermissions` = '229375',
	`maximumsocialgroups` = '5',
	`groupiconmaxsize` = '10000000',
	`dbtech_vbquiz_permissions_pro` = '678',
	`dbtech_downloadspermissions` = '63',
	`dbtech_downloads_delay` = '0'
WHERE usergroupid=6;

MySQL Error   : Unknown column 'dbtech_username_minposts' in 'field list'
Error Number  : 1054
Request Date  : Tuesday, November 5th 2013 @ 12:15:12 PM
Error Date    : Tuesday, November 5th 2013 @ 12:15:12 PM
Script        : http://www.enworld.org/forum/admincp/usergroup.php?do=update
Referrer      : http://www.enworld.org/forum/admincp/usergroup.php?do=edit&usergroupid=6
IP Address    : 81.101.96.161
Username      : Morrus
Classname     : vB_Database
MySQL Version : 5.5.29

 

[Morrus]

Note that I cannot edit the usergroup at all now (even non downloads settings) so this is a fairly urgent issue.

 

[Fillip H.]

You appear to have uninstalled the Username Change mod without correctly removing the files. If this is the case, please delete all the files that came with the mod and then rebuild the bitfields, then try editing usergroups again.

 

[Morrus]

You appear to have uninstalled the Username Change mod without correctly removing the files. If this is the case, please delete all the files that came with the mod and then rebuild the bitfields, then try editing usergroups again.

No, Username Change has not been uninstalled. It's still there.

I have *now* uninstalled Username Change, and everything's working again.

 

[Fillip H.]

It should be safe to re-install the mod, it seems like it was not installed or upgraded correctly originally.