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
chucktho
Member
Free Members
sp_UserOfflineSmall Offline
Aug 23, 2012 - 10:12 am

I haven't installed any SP plugins.

I don't know how to run an SQL script, so to save time and trouble just went in and removed all the duplicates.  In 41 cases there were about 25 of each.  In one case there was only one - "view_own_admin_posts" and its ID number suggests it was added almost at the end.

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.

I don't know what the above means or how to do it.  Please give me specific instructions.

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

First up there is on important thing to check in that table. There is a column called 'admin_negate'. There are only 2 rows that should have this set to a 1 and they are 'view_own_admin_posts' and 'reply_own_topics'. Please ensure that is set correctly.

Then go to the admin > Forums > reset permissions and perform the reset.
Then go to the admin > Toolbox > housekeeping and click on 'reset the auths cache'.

Then back to forums to set up the user group/permission set assignments.

My fingers are well and truly crossed!

andy-signature.png
YELLOW
SWORDFISH
Avatar
chucktho
Member
Free Members
sp_UserOfflineSmall Offline
Aug 23, 2012 - 1:30 pm

There are only 2 rows that should have this set to a 1 and they are 'view_own_admin_posts' and 'reply_own_topics'. 

view_own_admin_posts is there and set correctly.

"reply_own_topics" is not there. "reply_topics" is there and it is not set.

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Aug 23, 2012 - 2:10 pm

'reply_own_topics' was a new one in the last update to 5.1.3. If you are on 5,.2.3 are you sure you didn't delete it in error?

andy-signature.png
YELLOW
SWORDFISH
Avatar
chucktho
Member
Free Members
sp_UserOfflineSmall Offline
Aug 23, 2012 - 2:17 pm

I'm stuck at 5.1.2.  Trying to upgrade is what got this whole thing started.  I'm positive I didn't delete it.

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Aug 23, 2012 - 2:28 pm

Thats Ok then. It didn't exist in 5.1.2

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

Getting closer.  The one that I've tested seems to be working ok.  Normal members can see it.  However, in taking the final step below

Then back to forums to set up the user group/permission set assignments.

some of the forums have just disappeared after setting up the permissions.  Also, I have warnings showing on the admin page like this:  Warning - There are no usergroups with members that have permissions on forum: FARA Editors Forum This forum may only be visible to SP admins but there are usergroups with members that have permissions for all but one of the "Warnings"

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Aug 24, 2012 - 4:42 am

My only suggestion is that you set it up and then let one of us look at your settings.

andy-signature.png
YELLOW
SWORDFISH
Avatar
chucktho
Member
Free Members
sp_UserOfflineSmall Offline
Aug 24, 2012 - 10:29 am

As far as I am concerned, it is all set up.  I sent you admin creds about a week ago via PM.  If you need them again, let me know please.  I appreciate your help. 

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Aug 24, 2012 - 4:04 pm

Sorry - have been away for most of the day.
Afraid I do not now have them. PMs with credentials in are always deleted after the particular problem they were provided for has been dealt with.

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