Support Forum
Support Forum
Offline
sorry, not sure what I am supposed to weigh in on... 
guess I did miss this topic...
Visit Cruise Talk Central and Mr Papa's World
Offline
We were hoping for your advice on Yellow Swordfish's suggestion from 8/4 in this thread. Thanks for your help.
Offline
Well so was I. Sorry about that - I know he didn't have much time last night.
I think you should go ahead and give this a try anyway. I feel comfortable with it.
 |
YELLOW
SWORDFISH
|
Offline
No joy. I attempted the code changes you suggested and get the following:
Please copy the details below and include them on any support forum question you may have:
Parse error: syntax error, unexpected $end in D:\dev.alarmsearch.com\wordpress\wp-content\plugins\simple-press\sp-startup\install\sp-upgrade-support.php on line 411
- success
While we're on this subject, I don't know if I'm supposed to do a Network Upgrade or Upgrade the site Simple Press is on. When I select Upgrade I'm given the choice. I've tried it both ways without success.
Offline
The code is good. Are you sure you got ALL of the lines including those last two closing braces? Best way is to click on the 'raw code' button and then copy from the popup window into your clipboard but you do need it all.
|
YELLOW
SWORDFISH
|
Offline
Tried it again. Copied and pasted the "raw code". Same result.
Please copy the details below and include them on any support forum question you may have:
Parse error: syntax error, unexpected $end in D:\dev.alarmsearch.com\wordpress\wp-content\plugins\simple-press\sp-startup\install\sp-upgrade-support.php on line 411
- success
Offline
Afraid I don't know what to say. I have used this code myself and just retested. How about the removal of the old block. Are you sure you did not remove more than you should have. Believe me - there is no problem with this. Somewhere you are missing an opening brace...
Including the line above the changed block and the line below and to the end of the function it should now look like this:
# add new column for user auths in sfmember
spdb_query("ALTER TABLE ".SFMEMBERS." ADD (auths longtext)");
# now we need to convert existing roles
$roles = spdb_table(SFROLES);
foreach ($roles as $role) {
$actions = unserialize($role->role_actions);
if( ! empty($actions)) {
$new_actions = spa_convert_action_to_auth($actions);
spdb_query("UPDATE ".SFROLES." SET role_actions='".serialize($new_actions)."' WHERE role_id=".$role->role_id);
}
}
spdb_query("ALTER TABLE ".SFROLES." CHANGE role_actions role_auths longtext");
} |
YELLOW
SWORDFISH
|
Offline
Thanks for your patience.
I found the problem thanks to the example you sent.
Somehow I must have clipped this - " spdb_query("ALTER TABLE ".SFROLES." CHANGE role_actions role_auths longtext");
}"
After putting it back I was able to perform the upgrade. And it looks like everything is intact. I'll check it out thoroughly in the morning, but I think this problem is solved. Thanks again for all your help and patience.
Offline
wow, great news! and all while I have been otherwise engaged! 
thanks for sticking with us!
Visit Cruise Talk Central and Mr Papa's World
Offline
Ok, there are problems still. No one except admins can see the forums. Everyone else gets:
- The requested group does not exist or you do not have permission to view it.
- Unread and recently updated topics.
- There were no topics found.
I've tried re-setting the permissions. Then went to one of the user groups to be sure it had members and it does. Then went to one of the forums and added that User Group. No change.
Tried re-setting the Auths cache. No change.
I'm afraid to keep trying stuff for fear that I will just make matters worse and never be able to find my way back...
All RSS1 Guest(s)