Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
general-topic
Problem using "Can edit own posts forever" permission
Avatar
sptab
Member
sp_UserOfflineSmall Offline
Sep 18, 2013 - 3:43 pm

Hello,

Default users from group with "Standard Access" permission on my forum have this permission "Can edit own posts until there has been a reply" in the Editing panel. The "Can edit own posts forever" is not set for them.

I have another usergroup that is allowed "Can edit own posts forever" permission.

A strange thing I just noticed, based on a report from a forum member I added to this group is that he can't edit his posts forever, it's like he has only the access from "Standard Access" group for that feature. I have verified the forum permissions, they are correct for the subforum we made this test in. I also created a new forum user and was able to replicate the problem.

I don't remember having this problem in the past, would it be some problem in the settings (for permissions or somewhere else) could it be a bug in SP code ?

 

(note that I am currently manually adding members to a user group thu SQL INSERT in the database, as I can't get that feature to work in SP admin, but that's a different issue and I don't think it's related as the user is in the right group as show in their profile page).

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Sep 18, 2013 - 4:41 pm

does the user have more than one membership on the forum in question?  Or are they in a single usergroup with access to the forum?

Since the 'best' membership wins with multiple memberships, its possible there is an unintended consequence in this case, ie edit forever not checked first...

we havent adjust anything in this area in quite some time...

Since you are not using the api for adding membership and doing it directly in mysql, you might have a caching issue.  We cache all of a users memberships and use them rather than loading them all the time...  with your method of adding, we wouldnt know to reset the user's cache... 

please try going to forum - toolbox - housekeeping and resetting the auths cache and see if that clears it up....  If it does, you will have to do that housekeeping each time you change a membership directly in mysql.

Avatar
sptab
Member
sp_UserOfflineSmall Offline
Sep 18, 2013 - 5:45 pm

Thanks Steve.

It's working now, I think the auth cache reset did the job, glad to read auth data are cached btw wink

Your explanations make me think about some questions about the multiple membership and possible issues, but I need to get a better understanding on how it works and maybe experiment with it before coming with questions...

 

I hope my problem that force me to manually add the members to a user group will get a fix soon, I'm convinced the issue is not related to my system or database setup.

 

Cheers. 

 

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Sep 18, 2013 - 9:01 pm

thanks for the update...

as to the membership stuff, the only issue we can replicate is potentially running out of memory or cpu time... so we are changing the queries involved and trying to see if we can do it in chunks... our testing is normally with 250k users, but our test servers may not be representative of everyone's servers..

Avatar
sptab
Member
sp_UserOfflineSmall Offline
Sep 19, 2013 - 4:40 am

Resources wise, my server is quite powerfull, it's a Xeon E5-1650 processor with 6 cores/12 threads and 64 GB of RAM and it's dedicated to Wordpress blog and SP forum.

Still, I agree with Andy's comments about the membership query creating a temporary table, that shouldn't be. I'll try to have a look in that direction.

Thanks for your support.

 

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Sep 19, 2013 - 9:52 am

understand... work in progress... its still going to require a temp table, just not in RAM, I believe...

Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 650
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 619
Members: 17361
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10127
Posts: 79625