Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
plugins-topic
"Downgrade Warning" - How do I Restore Database?
Avatar
D J
Member
Free Members
sp_UserOfflineSmall Offline
Nov 20, 2014 - 1:38 pm

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.

Avatar
D J
Member
Free Members
sp_UserOfflineSmall Offline
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":""}

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
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.

andy-signature.png
YELLOW
SWORDFISH
Avatar
fiddlerman
Member
Free Members
sp_UserOfflineSmall Offline
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?

 

 

"The richest person is not the one who has the most, but the one who needs the least."


Learn to Play Violin for Free - http://www.fiddlerman.com

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
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?

Avatar
fiddlerman
Member
Free Members
sp_UserOfflineSmall Offline
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.

"The richest person is not the one who has the most, but the one who needs the least."


Learn to Play Violin for Free - http://www.fiddlerman.com

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
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?

Avatar
fiddlerman
Member
Free Members
sp_UserOfflineSmall Offline
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;}

"The richest person is not the one who has the most, but the one who needs the least."


Learn to Play Violin for Free - http://www.fiddlerman.com

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
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...

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: 619
Members: 17363
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10127
Posts: 79625