Simple Machines Community Forum

SMF Support => SMF 2.0.x Support => Topic started by: private bob4 on June 06, 2017, 11:45:16 PM

Title: Can't Select Board Permissions in Modify Usergroup
Post by: private bob4 on June 06, 2017, 11:45:16 PM
This is a confusing error I've been struggling with for a couple hours now.

While in the admin panel and attempting to modify a usergroup, when I click on a specific board and give permissions to that user group and hit save, it does not actually save and it deselects the box that I checked. This happens for people with all permissions to edit membergroups. While using "Select All" checkmark box, it will save some of the boards' permissions but not all of them. The ones I cannot select normally are the same ones that I can't select while hitting "Select All." However, if I modify the individual boards' permissions, and select the user group, that does successfully save and it works that way.

Sorry if that was confusing, it's hard to describe.

SMF Information.
PHP 7
SMF 2.0.14
Debian 8.8
NGinx
MariaDB

Edit: I attached an MP4 showing what I tried to describe since I can't attach external links yet.
Title: Re: Can't Select Board Permissions in Modify Usergroup
Post by: richardwbb on June 07, 2017, 03:55:26 PM
I do not fully understand what you wrote.

But, please let Kindred see my post too, it is in Dutch [the picture, I'm not going revert to English on a live forum], but the smf team always knows, what is shown [it's kinda sys-internals, ever heard of that.]

Please click; picture (http://www.fotobakje.nl/map/div/smf/security-settings-per-memebergroup.png)

Have a look at the 4th and 5th 'red text'.

The T N O are security overrides, it are overrides, this helped my forum big time. I just can't find the topic, and I rely on Kindred, I think he might remember what I have written [I mean what I am actually saying, once more, I do not understand your writing in full]. Or he say's [or anyone else of the smf team] it isn't a solution for your problem(s) with your forum. However, this is kinda dangerous, I mean, the way to go back without a backup, can be hard up to undoable. So you are warned, and the smf people have the final say I find.

And, for me posting a link to that topic, would be a lot easier, however, I just can't find it, it's a bit dated and my keyword didn't work or so. And bear that this override has to be turned on. Oh and you wrote board permissions, I know, I've been in the woods between and believe they are similar [for a picture that is]
Title: Re: Can't Select Board Permissions in Modify Usergroup
Post by: tjbalon on June 08, 2017, 04:16:41 PM
I'm also on the tech team of the forum we're talking about.

What's weird:

On our dev site, we can select all the boards just fine.
On the main site, we cannot.

We've diff'd the two forums, 99% of the code is the same. Which makes us think something is messed up in the database.
Title: Re: Can't Select Board Permissions in Modify Usergroup
Post by: Kindred on June 08, 2017, 04:47:54 PM
no.... it would not be a database issue.

If has to be a code issue - the database is just DATA - it does not control the display or action of the site - that is the code.
.
Title: Re: Can't Select Board Permissions in Modify Usergroup
Post by: tjbalon on June 08, 2017, 06:02:10 PM
Quote from: Kindred on June 08, 2017, 04:47:54 PM
no.... it would not be a database issue.

If has to be a code issue - the database is just DATA - it does not control the display or action of the site - that is the code.
.

But we have two forums with the exact same code base besides a few things appearing in diff? All of which are custom code which has 0 relevance to SMF, just calling SSI.
Title: Re: Can't Select Board Permissions in Modify Usergroup
Post by: richardwbb on June 08, 2017, 06:32:15 PM
balonfx, would you be able to post a hyperlink without the domain, then I'll probably be able to see it on my own environment.
Title: Re: Can't Select Board Permissions in Modify Usergroup
Post by: tjbalon on June 08, 2017, 06:50:21 PM
Update to Kindred:
I'm pretty sure we just confirmed it's a database issue of some sort.

We just took the live forum database and put the credentials inside of our dev forum. You cannot select the boards which are currently broken on the live forum. However... when connecting the dev database back to the dev website, you can select the groups fine.

We're not sure where to go from here.

Edit: We're hitting the varchar(255) limit on member_groups in the smf_boards table.

.... Ugh