The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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.
|
#3
|
|||
|
|||
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' |
#4
|
|||
|
|||
run this query, but backup your database first just in case it goes wrong.
[sql]ALTER TABLE `usergroup` DROP `jukeboxpermissions`;[/sql] |
#5
|
|||
|
|||
MySQL said: Documentation
#1091 - Can't DROP 'jukeboxpermissions'; check that column/key exists |
#6
|
|||
|
|||
ok, can you get the structure of your usergroup table and post it here inside [ code][/code] tags please.
|
#7
|
|||
|
|||
Code:
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 |
#8
|
|||
|
|||
is that it or is there a second page?
|
#9
|
|||
|
|||
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 |
#10
|
|||
|
|||
try rebuilding bitfields again.
|
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|