Usergroups problem - need help fixing it
 

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.

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.

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'

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

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

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

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

is that it or is there a second page?

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

try rebuilding bitfields again.