no privilage to post anywhere

Emperor Tippy

Merchant of Death
Super Moderator
Staff Member
Founder
Does this problem still persist? Looking at what permissions you have, you should be able to post.

If you can't post here in reply, PM me.
 

Agent23

Ни шагу назад!
Did you guys make the st. Fauci theread a "post here before being allowed to post anywhere else" type thread or something?
 

Emperor Tippy

Merchant of Death
Super Moderator
Staff Member
Founder
Yes, but that is not the issue.

To mass remove posting permissions we created a new User Group, made everyone a member, and then had them cease to be a member when they posted in that thread. Then, once things were over we deleted that User Group.

Unfortunately, XF appears to be just as stupid as ever and deleting a User Group doesn't appear to actually do anything but remove the ability to interact with said User Group.

So everyone who was still in that User Group at the time the User Group was removed still lacks posting permissions and nothing can be done about it via the Admin panel. The permissions are still there, and membership in the User Group is still there in the individual user account record. But the User Group having been deleted means that this can't be fixed except with actual database/code shenanigans (as opposed to via the Admin panel).
 

Agent23

Ни шагу назад!
Yes, but that is not the issue.

To mass remove posting permissions we created a new User Group, made everyone a member, and then had them cease to be a member when they posted in that thread. Then, once things were over we deleted that User Group.

Unfortunately, XF appears to be just as stupid as ever and deleting a User Group doesn't appear to actually do anything but remove the ability to interact with said User Group.

So everyone who was still in that User Group at the time the User Group was removed still lacks posting permissions and nothing can be done about it via the Admin panel. The permissions are still there, and membership in the User Group is still there in the individual user account record. But the User Group having been deleted means that this can't be fixed except with actual database/code shenanigans (as opposed to via the Admin panel).
TL;DR Kier's product still sucks ass, after nearly 11 years.
Just go into the DB and remove the group membership, I am guessing it is just some entry in a table like uid, gid in a table that is nothing more than that, UIDs and GIDs.(Not a DBA.)

SQL:
DELETE FROM groupmemberships WHERE GID=bullshitgroupnum;
 
Last edited:

Agent23

Ни шагу назад!
Basically, yes. And I've already done everything that can be done via the Admin panel. So fixing this is going to have to wait until someone with actual server access comes along and fixes things.
No phpmyadmin for you guys?
 

Emperor Tippy

Merchant of Death
Super Moderator
Staff Member
Founder
I don't suppose you could just make the usergroup again with the same name and everything?
Nope, tried that.

The problem is that apparently deleting a user group doesn't actually delete it (as in erase the information from the database). It instead removes the name and thus the ability to access it via the Admin control panel but the DB entry is still apparently there.

And since XF uses User Groups for everything permission related, this is a problem lacking any easy fix.

One would assume that deleting a User Group would also remove everyone from that User Group. But apparently not.
 

Agent23

Ни шагу назад!
So, I am guessing that you are getting some package deal where you get xenforo hosting from the provider, and no other access to the underlying infrastructure?
 

LordSunhawk

Das BOOT (literally)
Owner
Administrator
Staff Member
Founder
We have a ticket in to xenforo while our tech ops person is asleep, I'm not tech savvy enough to want to risk logging in to root in order to figure this out from there at risk of blowing things up worse. We will keep you all updated.
 

Agent23

Ни шагу назад!
We have a ticket in to xenforo while our tech ops person is asleep, I'm not tech savvy enough to want to risk logging in to root in order to figure this out from there at risk of blowing things up worse. We will keep you all updated.
So, yeah, I googled a bit and it looks like your problem table should be called xf_user_group_relation, you could select the id of the broken group, then execute the delete statement.
mysqldump can be used to back up any tables you want to fuck around with beforehand.
#willworkfor2drightwingwaifus
 

Emperor Tippy

Merchant of Death
Super Moderator
Staff Member
Founder
Well it's idiotic and hacky as all hell, but some of this should be solved. And the rest should be solved over the next few hours.
 

Users who are viewing this thread

Top