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
lost permissions after upgrading from 4.4.5 to 5.0
Avatar
ovizii
Member
Free Members
sp_UserOfflineSmall Offline
Feb 22, 2012 - 3:39 am

here are screens of a sample user: 

http://screencast.com/t/qKbl3vaTcA

http://screencast.com/t/a1bcZ21oVIXj

http://screencast.com/t/uOwz8YR5t

http://screencast.com/t/7cyTG9AkRW

 

The user is in the proper user group. the user group has the proper rights upon several forums and still he doesn't see anything 🙁

 

P.S. Just realized that my permissions are all empty. During the update they must have been lost. is there a way to restore the default permissions? I had not changed them, see here: http://screencast.com/t/jCD8qalTl 

Avatar
ovizii
Member
Free Members
sp_UserOfflineSmall Offline
Feb 22, 2012 - 3:40 am

I have fixed this issue with the help of another forum member: he sent me screen shots of what the permissions were supposed to look like and I manually set them.

 

There really should be a way to reset them back to default!

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Feb 22, 2012 - 5:20 am

Yes - I am sorry about this. We have had, I believe, 3 such occurrences and am still unsure why but are investigating and trawling the update code to see if we can work out what the problem might be. I am sure you realise it can be very difficult to pinpoint a condition that only happens to, say, 1 user in a 1000 or so.

I guess a reset to defaults might not be a bad idea. We have never been asked for it before and I suppose have always taken the view that we rather hope users will adjust their permission settings to suit their requirements. But worth discussing.

andy-signature.png
YELLOW
SWORDFISH
Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Feb 22, 2012 - 8:45 pm

did you happen to make a db backup before you upgraded?  we have several thousands upgrades/installs since 5.0 release and a handfull with this same issue...  would love to resolve... but cannot duplicate currently so a db from which to experience would be good.

Avatar
ovizii
Member
Free Members
sp_UserOfflineSmall Offline
Feb 23, 2012 - 3:16 am

I didn't make a backup before upgrading but my server does a backup every day. I guess I could dig that one out but what would you like me to do with it? I don't have the time to roll it back to 4.4.5, the best I could do is send it to you if you really want...

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Feb 23, 2012 - 5:05 am

If you would be willing to let us have a copy for tests we would very much appreciate it. Sometimes, seeing the data itself is the only way to find that one little condition that we are missing. So if there is a chance of a zip of the db - which will be destroyed immediately after analysis - then please do send a copy. support at simple-press dot com - thanks

andy-signature.png
YELLOW
SWORDFISH
Avatar
ovizii
Member
Free Members
sp_UserOfflineSmall Offline
Feb 23, 2012 - 5:12 am

I am sure I can do that. will see if htere is any private data inside but I think the PWs are in md5 hashes anyway, well, might take those out.

will take a day or two but I'll email it through.

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Feb 23, 2012 - 8:18 am

Thanks - that's helpful. I assure you we will respect the data. We really are only interested in the sfroles table.and relationships to the sfpermissions etc.

andy-signature.png
YELLOW
SWORDFISH
Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Feb 23, 2012 - 5:37 pm

you can email it to support at simple-press dot com...

Avatar
ovizii
Member
Free Members
sp_UserOfflineSmall Offline
Feb 24, 2012 - 6:44 am

sent!

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: 17365
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10128
Posts: 79626