Usergroups problem - need help fixing it

[Stokerockscene]

A few months back installed vb jukebox and another plugin, i no longer needed these plugins so i uninstalled them recently.

Now both products have gone, in my usergroup settings i am left with 2 tables at the bottom with no text, just radio buttons where the 2 plugins used to be.

I cannot update any usergroup settings because i get an sql db error about the plugins, thing is i have searched the database and site and cannot find any link to these plugins what-so-ever.

Can anybody please help me get rid of these 2 tables as i am pissing in the wind now.

[peterska2]

try rebuilding your bitfields by going to admincp/index.php?do=rebuildbitfields but before doing that, make sure that there are no XML files called bitfield_ for these two modifications in the includes/xml directory.

[Stokerockscene]

i love you, problem solved

ok im wrong, the tables have gone but when i submit changes i get an sql db error:

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Administrators',
`description` = '',
`usertitle` = 'Administrator',
`opentag` = '<COLOR=\"White\"><strong><i>',
`closetag` = '</i></strong></COLOR>',
`passwordexpires` = '180',
`passwordhistory` = '360',
`forumpermissions` = '1048575',
`attachlimit` = '0',
`pmquota` = '100',
`pmpermissions` = '3',
`pmsendmax` = '10',
`calendarpermissions` = '63',
`wolpermissions` = '31',
`adminpermissions` = '3',
`genericpermissions` = '205520831',
`genericoptions` = '31',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '80',
`avatarmaxheight` = '80',
`avatarmaxsize` = '20000',
`jukeboxpermissions` = '0',
`ecdownloadpermissions` = '0'
WHERE usergroupid=6;

MySQL Error : Unknown column 'jukeboxpermissions' in 'field list'

[peterska2]

run this query, but backup your database first just in case it goes wrong.

[sql]ALTER TABLE `usergroup` DROP `jukeboxpermissions`;[/sql]

[Stokerockscene]

MySQL said: Documentation
#1091 - Can't DROP 'jukeboxpermissions'; check that column/key exists

[peterska2]

ok, can you get the structure of your usergroup table and post it here inside [ code][/code] tags please.

[Stokerockscene]

   	 Field   	Type  	Collation  	Attributes  	Null  	Default  	Extra  	Action
	 usergroupid  	smallint(5) 	  	UNSIGNED 	No  	  	auto_increment  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
	 title  	varchar(100) 	latin1_swedish_ci 	  	No  	  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
	 description  	varchar(250) 	latin1_swedish_ci 	  	No  	  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
	 usertitle  	varchar(100) 	latin1_swedish_ci 	  	No  	  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
	 passwordexpires  	smallint(5) 	  	UNSIGNED 	No  	0  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
	 passwordhistory  	smallint(5) 	  	UNSIGNED 	No  	0  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
	 pmquota  	smallint(5) 	  	UNSIGNED 	No  	0  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
	 pmsendmax  	smallint(5) 	  	UNSIGNED 	No  	5  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
	 pmforwardmax  	smallint(5) 	  	UNSIGNED 	No  	5  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
	 opentag  	varchar(100) 	latin1_swedish_ci 	  	No  	  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
	 closetag  	varchar(100) 	latin1_swedish_ci 	  	No  	  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
	 canoverride  	smallint(5) 	  	UNSIGNED 	No  	0  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
	 ispublicgroup  	smallint(5) 	  	UNSIGNED 	No  	0  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
	 forumpermissions  	int(10) 	  	UNSIGNED 	No  	0  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
	 pmpermissions  	int(10) 	  	UNSIGNED 	No  	0  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
	 calendarpermissions  	int(10) 	  	UNSIGNED 	No  	0  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
	 wolpermissions  	int(10) 	  	UNSIGNED 	No  	0  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
	 adminpermissions  	int(10) 	  	UNSIGNED 	No  	0  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
	 genericpermissions  	int(10) 	  	UNSIGNED 	No  	0  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
	 genericoptions  	int(10) 	  	UNSIGNED 	No  	0  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
	 attachlimit  	int(10) 	  	UNSIGNED 	No  	0  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
	 avatarmaxwidth  	smallint(5) 	  	UNSIGNED 	No  	0  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
	 avatarmaxheight  	smallint(5) 	  	UNSIGNED 	No  	0  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
	 avatarmaxsize  	int(10) 	  	UNSIGNED 	No  	0  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
	 profilepicmaxwidth  	smallint(5) 	  	UNSIGNED 	No  	0  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
	 profilepicmaxheight  	smallint(5) 	  	UNSIGNED 	No  	0  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
	 profilepicmaxsize  	int(10) 	  	UNSIGNED 	No  	0  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext

[peterska2]

is that it or is there a second page?

[Stokerockscene]

Thats it.

I think i have found where the problem is, i found jukeboxpermissions and ecdownloadpermissions (2 culprits) in table: datastore > bitfields.

it's all a bit of a mess though

[peterska2]

try rebuilding bitfields again.