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
Upgrade to 5.1.2 failed
Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Aug 20, 2012 - 3:38 pm

have you checked the forums individually to ensure that the user group / permission set assignments are in place and all correct?

andy-signature.png
YELLOW
SWORDFISH
Avatar
chucktho
Member
Free Members
sp_UserOfflineSmall Offline
Aug 20, 2012 - 3:42 pm

I only set it up on one of the Forums so I could see if it worked.  Sometimes SP is counter-intuitive to me so I may have done something wrong, but the user group/permission set assignments for that one forum look correct to me.

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Aug 20, 2012 - 8:05 pm

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..

Avatar
chucktho
Member
Free Members
sp_UserOfflineSmall Offline
Aug 21, 2012 - 9:40 am

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.

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Aug 21, 2012 - 12:37 pm

over 900! ??? Well that is almost certainly the problem there.
I have the PM but need to do some thinking and testing first to work out how we can get that table back to the proper condition...

andy-signature.png
YELLOW
SWORDFISH
Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Aug 21, 2012 - 9:46 pm

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...

Avatar
chucktho
Member
Free Members
sp_UserOfflineSmall Offline
Aug 22, 2012 - 10:27 am

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.

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Aug 22, 2012 - 11:54 am

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?

andy-signature.png
YELLOW
SWORDFISH
Avatar
chucktho
Member
Free Members
sp_UserOfflineSmall Offline
Aug 22, 2012 - 3:16 pm

What would a single set of entries look like?  I can go in there and clean it out if I know what to remove.

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Aug 23, 2012 - 6:29 am

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.

andy-signature.png
YELLOW
SWORDFISH
Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
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: 620
Members: 17368
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10128
Posts: 79626