Support Forum

Upgrade datebase failure

JM Janni Mikkelsen
Janni Mikkelsen
Member

Hi

I’m upgrading from Version 4.5.0 to latest – Lots of changes, so i decidedet to go back to 4.5.0 and do the upgrade on a more user-friendly time a day – That din’nt work out :)

Now I can’t get any of the versions working, both won’t complete the automatic database upgrade.

What do i do, any version working is fine with me :)

16 Answers

New Answer

JM Janni Mikkelsen
Janni Mikkelsen
Member

The lastest message when upgrading from 4.5.0

 

Please copy the details below and include them on any support forum question you may have:

 

6624 – success

6637 – success

6650 – success

6663 – success

6689 – success

6702 – success

6715 – success

6728 – success

6741 – success

6754 – success

6767 – success

6780 – success

6793 – success

6806 – success

6819 – success

6832 – success

6845 – success

6858 – success

6871 – success

6884 – success

6897 – success

6910 – success

6923 – success

6936 – success

6949 – success

6962 – success

7022 – success

7055 – success

7181 – success

7255 – success

7420 – success

7430 – success

7500 – success

7572 – success

7579 – success

7750 – success

7826 – success

8033 – success

8148 – success

8214 – success

8219 – success

8222 – success

8239 – success

8240 – success

8284 – success

8315 – success

8375 – success

8402 – success

8440 – success

8493 – success

8530 – success

8552 – success

8556 – success

8618 – success

8629 – success

8655 – success

8656 – success

8691 – success

8700 – success

8712 – success

8860 – success

8870 – success

8927 – success

8972 – success

Access denied – Only Users who can Activate Plugins may perform this upgrade – success

YS Yellow Swordfish
Yellow Swordfish
Member

Well – 8972 is the right build number for version 5.1.3. So your update went through. If you canlt actually get into the forum admin then that suggests ot just didnlt make the final version/build update in the database. And the only reason I can think of for that off-hand, would be that WP logged you out half way through the process. WP does have a habit of logging people out at inappropriate times. At least that is the only scenario I can think of.

I would suggest you logo ut manually. Log back in to your admin. Go to the forum menu. Click on the SP upgrade of it is saying it is required and then let me know what it says on the upgrade page (i.e., version to version and build to build.). It is almost certainly safe to just let it finish but worth checking…

JM Janni Mikkelsen
Janni Mikkelsen
Member

I have no problems logging in – but the forum keeps telling me to Upgrade database… and I do, and nothing changes, I get the same error.

JM Janni Mikkelsen
Janni Mikkelsen
Member

Oh, now I get a new error :)

Upgrade Aborted
6689

YS Yellow Swordfish
Yellow Swordfish
Member

Can you give me the information I asked for in the above post? As I suggested above – let me check that before you try it again.

JM Janni Mikkelsen
Janni Mikkelsen
Member

Oh sorry, english is not my primary language, i misread that :)

I can’t get into the forum admin, it just asks me to perform the upgrade, no other options?

JM Janni Mikkelsen
Janni Mikkelsen
Member

I get this now

 

Please copy the details below and include them on any support forum question you may have:

 

6624 – success

6637 – success

6650 – success

6663 – success

6689 – success

Warning: Invalid argument supplied for foreach() in /problem-with-post-edit-buttonome/virtual/mydomain.dk/public_html/wp-content/plugins/simple-press/admin/library/spa-support.php on line 466 Warning: Invalid argument supplied for foreach() in /problem-with-post-edit-buttonome/virtual/mydomain.dk/public_html/wp-content/plugins/simple-press/admin/library/spa-support.php on line 466 Warning: Invalid argument supplied for foreach() in /problem-with-post-edit-buttonome/virtual/mydomain.dk/public_html/wp-content/plugins/simple-press/admin/library/spa-support.php on line 466 Warning: Invalid argument supplied for foreach() in /problem-with-post-edit-buttonome/virtual/mydomain.dk/public_html/wp-content/plugins/simple-press/admin/library/spa-support.php on line 466 Warning: Invalid argument supplied for foreach() in /problem-with-post-edit-buttonome/virtual/mydomain.dk/public_html/wp-content/plugins/simple-press/admin/library/spa-support.php on line 466 Warning: Invalid argument supplied for foreach() in /problem-with-post-edit-buttonome/virtual/mydomain.dk/public_html/wp-content/plugins/simple-press/admin/library/spa-support.php on line 466 6702 – success

YS Yellow Swordfish
Yellow Swordfish
Member

No… please do NOT keep running it. You may do more damage.

Sorry if I did not make myself clear.

Click on the upgrade button in the admin.

At the top of the upgrade page it will tell you what version and build number you upgrading from and to. Please let me have those numbers.

As you have now actually re-run the upgrade at least twice then we migt have extra problems.

Are you able and willing to change data in your database?

JM Janni Mikkelsen
Janni Mikkelsen
Member

Upgrade Simple:Press From Version 4.5.0 to 5.1.3 – (Build 6400 to Build 8972) :)

I have the database GUI open, and i have backups, so im not afraid… much ;)

JM Janni Mikkelsen
Janni Mikkelsen
Member

If nothing else… I could just wipe it all, and start all over. And then import my few users and permissions directly into the database?

YS Yellow Swordfish
Yellow Swordfish
Member

We may as well try and salvage things…
Find the table ‘sfoptions’.
Find the row with an option_name of ‘sfversion’ and change the option_value to 5.1.3
Find the row with an option_name of ‘sfbuild’ and change the option_value to 8972
Keep your fingers crossed – reload an admin page and see what happens next..

JM Janni Mikkelsen
Janni Mikkelsen
Member

Perfect kiss

It did something to my forums permission, but that was easily fixed :)

Thanks!

JM Janni Mikkelsen
Janni Mikkelsen
Member

Oh.. it did’nt :/

It looks allright, but if i click on a forum or topic the site is not found :/

YS Yellow Swordfish
Yellow Swordfish
Member

Take a little time to work though all the forum admin option panels to make sure all is correct.
Go to the WP integration panel and make sure the permalink is correct and update it manually from the button on the page.