Support Forum

"Downgrade Warning" – How do I Restore Database?

DJ D J
D J
Member
Member since Jun 2014
8 posts
Nov 20, 2014 · 1:38 pm · Edited

I received the following warning. How do I restore my database to an earlier version? 

I am not technical so appreciate the instruction!

Thanks,

Darren

 

Downgrade Warning
It appears you are attempting to downgrade your Simple:Press Version. The Build or Version number in the sp-control.php file is lower than the currently installed version in the database.

You must restore your database to this earlier version before you can continue. You cannot simply downgrade Simple:Press files as the database has been upgraded beyond the version you are attempting to downgrade to and may cause irreparable damage to the database.

8 Answers

New Answer
DJ D J
D J
Member
Member since Jun 2014
8 posts
Nov 20, 2014 · 2:51 pm

I restored my earlier version with mysql backup.

I installed the most recent version of simple press (for the error above, I tried installing an older version)

Now I get this error… any idea on what to do?

 

Upgrade is in progress – please wait

 

 

 

Upgrade Aborted

current build: 11487

Notice: Undefined index: display in /problem-with-post-edit-buttonome/steal7/public_html/touchmba/members/wp-content/sp-resources/forum-plugins/plupload/sp-plupload-plugin.php on line 59

Warning: Cannot modify header information – headers already sent by (output started at /problem-with-post-edit-buttonome/steal7/public_html/touchmba/members/wp-content/sp-resources/forum-plugins/plupload/sp-plupload-plugin.php:59) in /problem-with-post-edit-buttonome/steal7/public_html/touchmba/members/wp-content/plugins/simple-press/sp-startup/site/sp-ahah-handler.php on line 21

{“status”:”success”,”type”:”upgrade”,”section”:11493,”response”:”Build upgrade section 11493 executing. Status: success

“,”error”:””}

YS Yellow Swordfish
Yellow Swordfish
Member
Member since Nov 2008
16,437 posts
Nov 20, 2014 · 3:15 pm

It might simply be because you are allowing notices and warnings (and probably errors) to be displayed on the screen. This really is a very bad thing to do and not recommended by anyone. I would personally ask your host to put in place the recommended error log file, remove from the display and then see if the upgrade goes through.

FI fiddlerman
fiddlerman
Member
Member since Jan 2011
359 posts
Jan 3, 2015 · 10:02 am

I just made all the updates available for violaman.com/forum and received the same warning.

It appears you are attempting to downgrade your Simple:Press Version. The Build or Version number in the sp-control.php file is lower than the currently installed version in the database.

You must restore your database to this earlier version before you can continue. You cannot simply downgrade Simple:Press files as the database has been upgraded beyond the version you are attempting to downgrade to and may cause irreparable damage to the database.

I don’t want to downgrade, simply upgrade the database as I’m being directed to.

FORUM

Sorry, the forum is temporarily unavailable while it is being upgraded to a new version.

Click here to perform the upgrade

Edit

 
 
 
What should I do now?

 

 
MP Mr Papa
Mr Papa
Member
Member since Dec 2006
19,448 posts
Jan 3, 2015 · 11:48 am

not sure what you are saying… are you trying to go down a version or upgrade?

if upgrade, go to the wp updater and update simple press if one available… if not, does the forum admin menu now consist of an upgrade link?

FI fiddlerman
fiddlerman
Member
Member since Jan 2011
359 posts
Jan 4, 2015 · 3:20 pm

I always update never downgrade. I did all the updates and I received the warning that I pasted in the above post:


Sorry, the forum is temporarily unavailable while it is being upgraded to a new version.

Click here to perform the upgrade

After clicking on the link to perform the upgrade I get the following message:

It appears you are attempting to downgrade your Simple:Press Version. The Build or Version number in the sp-control.php file is lower than the currently installed version in the database.

You must restore your database to this earlier version before you can continue. You cannot simply downgrade Simple:Press files as the database has been upgraded beyond the version you are attempting to downgrade to and may cause irreparable damage to the database.

MP Mr Papa
Mr Papa
Member
Member since Dec 2006
19,448 posts
Jan 4, 2015 · 3:30 pm

so in wp-content/plugins/simple-press/sp-control.php, what is the version listed?

also, please check your db, the sfoptions table for option name of sfversion, what does it have?

FI fiddlerman
fiddlerman
Member
Member since Jan 2011
359 posts
Jan 4, 2015 · 8:00 pm

Version: 5.5.2

 

Looks like 5.5.3

 

Rows option_value
16  
10 1
1 10
1 12
1 12017
1 12176
1 200
1 2014-12-26 03:36:27
1 3600
1 5.5.3
1 50
2 a:0:{}
1 a:11:{s:13:”sfshowavatars”;b:1;s:15:”sfavataruploa…
1 a:11:{s:5:”email”;b:1;s:3:”max”;s:1:”0″;s:13:”maxr…
1 a:12:{s:7:”dayflag”;s:1:”1″;s:8:”hourflag”;i:0;s:9…
1 a:14:{s:10:”nameformat”;i:1;s:11:”displaymode”;i:1…
1 a:16:{s:16:”css-sp-admin-bar”;a:2:{s:8:”modified”;…
1 a:16:{s:16:”css-sp-admin-bar”;a:2:{s:8:”modified”;…
1 a:16:{s:3:”ver”;a:1:{s:3:”all”;i:46;}s:16:”css-sp-…
1 a:16:{s:7:”avatars”;s:26:”sp-resources/forum-avata…
1 a:17:{s:11:”sflinkabove”;b:0;s:12:”sflinksingle”;b…
1 a:18:{s:6:”global”;a:54:{i:1;i:1;i:2;i:0;i:3;i:0;i…
1 a:1:{i:0;a:4:{s:7:”user_id”;s:1:”1″;s:12:”display_…
1 a:1:{i:0;a:6:{s:12:”usergroup_id”;s:1:”1″;s:14:”us…
1 a:1:{s:9:”dbversion”;i:0;}
MP Mr Papa
Mr Papa
Member
Member since Dec 2006
19,448 posts
Jan 4, 2015 · 8:01 pm

so your database is at 5.5.3, but the software version on the server is 5.5.2…  hence the downgrade statement…

please download 5.5.3 version and upload to your server…