Support Forum

Need step-by-step for upgrading from version 4.3.4

MC Mike Caro
Mike Caro
Member

I have a site that is still in beta. It has Simple:Press posts and settings that I want to keep.

How can I upgrade from SP version 4.3.4 to 5.2? I’m assuming I’ll need to first upgrade to 4.5, as an intermediate step.

My WordPress version is 3.5.1 (the most recent release).

All help greatly appreciated.

— Mike Caro

26 Answers

New Answer

MP Mr Papa
Mr Papa
Member

upgrade instructions are here: 

http://codex.simple-press.com/codex/installation/upgrading/upgrading-version-4-5/

yes, you will need to upgrade to 4.5.1 first… you can older simple press versions to accomplish this at:

http://codex.simple-press.com/codex/installation/upgrading/previous-simplepress-versions/

remember, make a db backup each step of the way in case there are any issues…

 

MC Mike Caro
Mike Caro
Member

Thanks, Mr. Papa. Sounds simple. I’ll give it a try.

MP Mr Papa
Mr Papa
Member

cool. let us know how it goes or if you need more help…

MC Mike Caro
Mike Caro
Member

I have the SP 5.2.6 upgrade up and running and it recognizes the forums I’ve created — at least in the administration settings.

However, I’m seeing no posts or forum listings on the actual page — only this message below Home / Talk (the name of my forum page):

“The requested group does not exist or you do not have permission to view it”

The plug-in is active and displays correctly on the page, just not the posts or forum names.

MP Mr Papa
Mr Papa
Member

this was an upgrade (sorry, replying via email and cannot see whole thread)?? can you try going to forum – toolbox – housekeeping and resetting the auths cache? if that does not work, we have had a dozen upgrades that lost permissions… can you check your db and see how many entries you have in the sfauths table?

MC Mike Caro
Mike Caro
Member

Resetting the auths cache didn’t fix the problem. Still no posts or forum listings below “Talk” in the hierarchy.

I could research this one, but I’ll just ask. Does Simple:Press use its own database or is the table inside WordPress’ database? Can I investigate using special SP admin tools or do I need to use cPanel?

MP Mr Papa
Mr Papa
Member

Afraid I didnt think it would… yes, we have our own tables inside the same database as WordPress… you need to use phpmyadmin or similar database inspection tool… cpanel usually does have phpmyadmin…

think I know what this issue is (adding to the dozen?), but need to know the number of entries in the sfauths table (will be preceeded by wp_ or whatever your db prefix is)…

MC Mike Caro
Mike Caro
Member

Okay. Found it in the standard WordPress database. It shows “3” under “auth_cat”

MP Mr Papa
Mr Papa
Member

sorry, not sure what you mean…   in the wp_sfauths table, how many rows (entries) of data are there?

MC Mike Caro
Mike Caro
Member

It seems to be accessing the right table, because I show 440 posts that can’t be accessed.

Here’s what I’m seeing on the public forum beta page itself:

Most Users Ever Online: 47

Member Stats:

Guest Posters: 103

Members: 23

Moderators: 0

Admins: 2

Forum Stats:

Groups: 1

Forums: 4

Topics: 117

Posts: 440

The above might indicate a settings issue, but I can’t find the fix.

MC Mike Caro
Mike Caro
Member

 Start row: 0; Number of rows: 30; Headers every 100 rows. That’s all I can find.

MP Mr Papa
Mr Papa
Member

below that, what does it say?? seem image for example…

table.png
MC Mike Caro
Mike Caro
Member

Mr Papa said
below that, what does it say?? seem image for example…

table.png

There is no data or table below. It’s just blank between the “rows” information above and the options below.

My host keeps daily backups. But rather than revert to the original SP 4.3 version, then to 4.5.1, and finally to the current version, would it work if I just copied the SP tables (any or all) that seem empty? I’m confused and not familiar with how this process would work with SP and WordPress.

MP Mr Papa
Mr Papa
Member

well, if there is no data, it will say so…  something like msqyl returned an empty result set (ie zero rows)…

no, you cannot copy tables like that…  as I said, I suspect you have zero rows of data in sfauths (deleted somehow) but wanted to be sure before proceeding…