Upgrade from 4.5 to 4.6 not working

Hi there, I am having a few issues upgrading a wordpress installation. I am moving from 4.5.3 to the latest, 4.6.1 - but every time I try I get an error. I have tried both the auto-update and doing it manually but each time the database appears to become corrupted.

When I did a manual update (copying over the files), I went to login and had a message to update my database. I clicked the ok button and then got the following error.

Can anyone suggest a fix for this?

  • Nithin

    Hi Sanders Web Works,

    Hope you are doing good today. :slight_smile:

    These mentioned tables were deprecated, and was from the oldest versions of WordPress. Does the same issue popup when you perform the one click upgrade? Were the plugins, and themes disabled during upgrade, if not please disable all the plugins, and switch to default theme to check whether you are still getting the same result, when you perform manual upgrade?

    Could you please follow the tutorial, and check how your upgrade goes:

    Please let us know how that goes, so that we could give a closer look. Have a nice day. :slight_smile:

    Kind Regards,

  • Ash

    Hello @Sanders Web Works

    Do you have any caching plugin? And do you have google xml sitemap plugin? All of your plugins are updated to latest?

    Please note that, if you have caching plugin then just deactivating the plugin doesn't help sometimes. You have to remove related code from wp-config.php

    Then, would you please follow the procedure below:

    .1 Make a backup of the installed WP.

    .2 Check the WP database for errors and make a single backup of it in case you have to restore it in the future.

    .3 Download the 3.4.2 version for updates, from here, assuming that was the version. If not, replace 3.4.2 in the link to the correct version.

    .4 Unpack over your actual WP installation.

    .5 Accept when asked to update the database.

    .6 Log in and check the plugins to see if one of them is the problem, specially those that modify in any way the categories because from the error messages there is a problem with them.

    .6 Don't update again without previously disabling the plugins and only when you are ready to take the risk.

    If it still doesn't work, I can take a look. Then, would you please send me cpanel login details and admin login details?

    To send me details, please use our contact form: https://premium.wpmudev.org/contact/

    Select: I have a different question
    Subject: Attn-Ash (this ensures that it will be assigned to me)
    1. Send all requested details
    2. Send a link of this thread so that I can track
    3. Send any other relevant link

    I will be happy to take a look :slight_smile:


  • Rupok

    Hi Kev,

    I hope you don't mind me chimming in here. I logged in your cPanel and took a backup of your files in your server. Then I tried to export your database dump, but your PHPMyAdmin was working increadibly slow and I could export the database. Can you please do that? This article describes how you can do that: https://wpengine.com/support/exporting-database/

    After this, you will have both your files and databased backup so you can always revert back to current state if anything goes wrong.

    Now, can you please try to repair your database natively? To do this, please go to your cPanel file manager and go to "public_html" directory. There you will get "wp-config.php" file. Edit that file and add the following line:
    define('WP_ALLOW_REPAIR', true);
    and save. Now go to "http://yoursite.com/wp-admin/maint/repair.php" this URL in your browser. Please replace "yoursite.com" with your original URL. There you will get option to repair and optimize your database. Please do those and check if your issue is resolved.

    Please let us know if this doesn't resolve your issue. We will be glad to assist further.

    Have a nice day. Cheers!

  • Kasia Swiderska

    Hello Kev,

    I can see your email in our system and I checked that Ash asked in previous email for site login and password. Can you send it via email as requested? Also please confirm that you repaired database as shown here https://premium.wpmudev.org/forums/topic/upgrade-from-45-to-46-not-working#post-1175738 and PhpMyAdmin is working correctly now.

    When you send credentials to your site please remember to also confirm here in thread.

    kind regards,