Support Forum
check your sfauths table in the db... any chance some of the auths are duplicated?
you could pm some temp sp admin credentials to both yellow swordfish and myself and we could take a look if you like too..
Visit Cruise Talk Central and Mr Papa's World
check your sfauths table in the db… any chance some of the auths are duplicated?
I don't know how to tell. I've looked at the DB and there are over 900 entries in that table. There are no duplicate auth_id's as far as I can tell. However for auth_name and auth_description there look to be about 25 for each. Does that help?
I'll PM Super Admin creds to both you and Yellow Swordfish along with a link to this thread and the forum.
at this point, I would probably go to forum - permissions - reset permissions and choose to reset all your permissions.. this will reset them back to the default install state...
should get them fixed, but you will need to go back to forum - permissions - manage permissions and set them back up the way you wanted...
Visit Cruise Talk Central and Mr Papa's World
Doesn't look like that worked. I reset the permisssions. Then I went to a Forum that is open to all Members (General FARA Membership Forum) Add Group Permission, chose FARA Members for "Select usergroup" and Standard Access for "Select permission set. Then signed in with a different browser as a FARA Member and I get the same messages: "The requested group does not exist or you do not have permission to view it", etc.
No I don't think this is the solution by itself. I believe that before this is done the sfauths table needs to be reduced to a single set of entries. When that is done then a reset makes sense. At least that s what I believe. But I donlt believe we have a single tool that can reduce all of your duplicate entries.
[Steve] Any ideas on the best way to clean up the sfauths table here?
YELLOW
SWORDFISH
|
I was hoping Steve would chime in here but he was sadly not available.
The bottom line is that you need one entry of each auth type. There IS a definitive list of the core auths but SP plugins can add extra ones so the final list will depend upon which plugins you have active.
What might be sensible here is if you tell me what plugins you have active and I can then create a SQL script to re-create your auths table as it should be. I assume you are comfortable with running a SQL script against your database.
Following that you would then need to perform the 'rest' of all auths, rebuild those relationships in your forums and clear out the auth caches but that comes afterwards.
YELLOW
SWORDFISH
|
1 Guest(s)