Support Forum
Support Forum
Offline
getting there but still an error when viewing forum home page:
I wonder if the permissions have got all screwed - this is an example for standard access:
what should this look like?
Offline
It was a while ago (post 10 in this thread to be exact) that I said we can get past the upgrade problem but you would have to go back in and repair it afterwards. This was the bit I was talking about - the permission settings. We lost those when we skipped that section to finish the upgrade.
You can, of course, set them all up manually to get them how you want them - which is not really as big a task as it sounds. But if it is any help I can send you a SQL script that you can import using phpMyAdmin that will reset the permissions to their default values so you would then only need to tweak them.
Let me know if you would like me to send that to you and I can drop it into an email.
 |
YELLOW
SWORDFISH
|
Offline
that sounds good. can you send me the SQL script? I hadn't changed any of the default permissions settings before
Offline
The script has been sent. I hope this works for you.
|
YELLOW
SWORDFISH
|
Offline
think I'm sorted now. The script didn't like the fact that role_actions was not a valid field in that table. also the permissions were still not appearing in the Forum admin interface so I dug out the sf-install.php script, found the bit where it set permissions for each type of user, and manually changed them in the interface. Hope that was the right thing to do?
Offline
Interesting, SO originally the column name HAD been altered by the upgrade script so the ALTER statement in my script was redundant. Removing that statement at the top of the script would then have worked.
But manual is good - just a little more tedious.
It's been a long haul and I am sorry you had all those problems and it took so long to get it all resolved. Hopefully you are back up and good to go now.
|
YELLOW
SWORDFISH
|
All RSS1 Guest(s)