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.

http://www.stokerockscene.co.uk/Photos/non-site/usergroups.jpg

[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.

ALTER TABLE `usergroup` DROP `jukeboxpermissions`;

[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.

[Stokerockscene]

when i try and rebuild bitfields it takes me to a white screen

[peterska2]

ok, make sure you have backed up then drop those two records from the datastore table too.

If that doesn't work, then I have no idea.

[Stokerockscene]

whats the sql code to drop a line of code from within a field

the two lines are in datastore > data

[peterska2]

I'm not sure. If you have phpmyadmin you can delete them directly from in there though.

[Stokerockscene]

i tried that, and my site went down lol :)

[peterska2]

Thats why I advised to take a backup then you can restore it if it goes wrong.

[Stokerockscene]

i did back up :)