Originally Posted by Danisty (Post 1733071)

This messed up my admin panel. I tried to edit the usergroups to allow them to view this in the menu and instead of editing the usergroup, it created a new custom group so now I have custom groups for administrator, moderator, etc. with the permission to view the on the menu but no change to the original group i tried to edit. Then I went in and checked to see if those custom groups had permission and they did not. If i tried to give the custom group permission, it created yet another custom group. I tried uninstalling this product but the option block is still on the usergroup permissions page except there is nothing written in the option block. I tried editing a different permission for my admin account and now I get this error. I can't change any permissions on my usergroups at all now!

Database error in vBulletin 3.8.1:

Invalid SQL:

### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO usergroup
(`title`, `description`, `usertitle`, `opentag`, `closetag`, `passwordexpires`, `passwordhistory`, `forumpermissions`, `genericpermissions`, `attachlimit`, `pmquota`, `pmpermissions`, `pmsendmax`, `pmthrottlequantity`, `calendarpermissions`, `wolpermissions`, `adminpermissions`, `genericpermissions2`, `genericoptions`, `profilepicmaxwidth`, `profilepicmaxheight`, `profilepicmaxsize`, `avatarmaxwidth`, `avatarmaxheight`, `avatarmaxsize`, `signaturepermissions`, `sigpicmaxwidth`, `sigpicmaxheight`, `sigpicmaxsize`, `sigmaxrawchars`, `sigmaxchars`, `sigmaxlines`, `sigmaxsizebbcode`, `sigmaximages`, `albumpermissions`, `albumpicmaxwidth`, `albumpicmaxheight`, `albumpicmaxsize`, `albummaxpics`, `albummaxsize`, `usercsspermissions`, `visitormessagepermissions`, `socialgrouppermissions`, `maximumsocialgroups`, `groupiconmaxsize`, `vbblog_general_permissions`, `vbblog_customblocks`, `vbblog_custompages`, `vbblog_entry_permissions`, `vbblog_comment_permissions`, `fcpermissions`, `ms_vopt_permissions`)
VALUES
('Administrators', '', 'Administrator', '<b><span style=\"color:#660198;\">', '</b></span>', '180', '360', '16777215', '2145386431', '0', '1000', '7', '20', '0', '63', '31', '3', '1', '55', '300', '300', '150000', '150', '150', '120000', '234623', '500', '75', '100000', '1500', '1000', '5', '3', '6', '255', '800', '800', '100000', '2000', '0', '63', '63', '65535', '5', '150000', '262142', '5', '5', '24575', '0', '0', '0');

MySQL Error : Unknown column 'ms_vopt_permissions' in 'field list'
Error Number : 1054
Request Date : Tuesday, February 3rd 2009 @ 04:04:40 PM
Error Date : Tuesday, February 3rd 2009 @ 04:04:40 PM
Script : http://www.allbeliefs.com/admincp/us....php?do=update
Referrer : http://www.allbeliefs.com/admincp/us...&usergroupid=6
IP Address : 72.230.88.206
Username : ?anisty
Classname : vB_Database
MySQL Version : 5.0.75

Originally Posted by Danisty (Post 1733086)

I deleted bitfield_ms_vopt_38.xml from my xml folder and reinstalled the old version. My usergroups are still messed up. No matter what edits I make to them, it just creates a new custom group that I also can't edit. I've checked on my forum that does not have this hack installed at all and there is no problem over there so I know it's not vb 3.8.1 that caused this problem. I also disabled the only other hack I upgraded today (https://vborg.vbsupport.ru/showthread.php?t=199975) and I'm still having the problem. Even when I disable the old version of this hack, I have this problem. This is a pretty big deal and I need a fix for this!

Originally Posted by Mosh (Post 1748368)

Neither version of this hack behaves like that. There have always been two links, one for the threads, the other for the posts, and has been since I released this hack.

Originally Posted by jilly (Post 1750306)

I think you should make it default that this is enabled for all usergroups. Due to my board's own weird purposes, I have well over 100 usergroups and now have to go in and edit each one, unless you might know a query I could run to set them all to yes. I don't know enough to figure that part out (lol) - I would imagine in most cases, this woudl be an option people would want all usergroups to have anyway, or at least the majority of their usergroups...

Originally Posted by Teresa (Post 1751058)

hmmm. Installed per instructions. Enabled in all usergroups per the query and double-checked.

Nothing is showing. Is there a hook I need somewhere that I may not have in my template?

www.guineapigcages.com/forum

vB 3.8.1

Also have this add-on installed: Member Search on Search Dropdown, 3.0

Thanks,
Teresa

Originally Posted by Mosh (Post 1748380)

That was because the ms_vopt_permissions field was deleted and the bitfield was still there.



If you have deleted bitfield_ms_vopt_38.xml from your xml folder and you are still having the error Unknown column 'ms_vopt_permissions' in 'field list', then the bitfield file is still there, and has not been deleted.

I am pretty sure this problem is due to mixing up old and new versions of this hack.

Make sure you delete the bitfield file, un-install the product, and check the following:

In the AdminCP, select Maintenance -> Execute SQL Query and run the following query:

[sql]describe usergroup;[/sql]

If there is a ms_vopt_permissions entry in the Field column, then running the following query will get rid of it:
[sql]ALTER TABLE usergroup DROP ms_vopt_permissions;[/sql]

That should fix your problem up. If it does not, then post back with the exact error.

Originally Posted by Mosh (Post 1751174)

The hook that needs to be in your navbar template is: