Forums

[resolved] Upgrade to 3.4.1 Stuck at Database Update Required (3 posts)

  1. alphatucana
    Member
    Posted 9 months ago #

    The blog pages still show up on the site OK, but I can't get to the Dashboard any more. WordPress seems stuck in the upgrade. I get a WordPress page with a button saying 'Database Update Required' and when I press it I get one of two results. Either 'connection to the server has been reset, try again' or just a blank page with the WordPress logo in a box (same page as the Database Update Required button page, but with no text or button). I'm using Firefox browser, although the results are the same with the MSIE-within-Firefox browser too.

    I have tried:
    - replacing wp-admin and wp-includes folders with the latest version;
    - deactivating all plugins by renaming the plugins folder (there is no mu-plugins folder AFAICT);
    - checking the database tables with PHPMyAdmin - I haven't tried repairing them as the check tables function suggests they are OK. I did download an SQL export of them for now;
    - renaming all themes except twentyeleven.

    All the above give exactly the same result as above.

    Just at the moment I am not 100% sure I've accessed the correct SQL database as my notes show a MySQL5 database that I haven't got into yet... I don't have time to check right now as I have to go to work. Thought I'd post in case anyone has seen this problem anyway and has the answer.

  2. alphatucana
    Member
    Posted 8 months ago #

    OK, got into the correct database. All the tables check out as "OK". Some don't support repair, apparently.

  3. alphatucana
    Member
    Posted 8 months ago #

    Right; found the solution in this thread:

    http://wordpress.org/support/topic/cant-login-after-upgrade-wp-34

    We had this problem and just solved it! Open the PHP file version.php which is located in wp-include folder of your wordpress blog, and check the field $wp_db_version. It should be equal to the db_version of WP_Options table. For more detail, read http://www.clickonf5.org/2247/solution-database-upgrade-required/

    and

    With regards to the solution. What you do is (I'm assuming you found WP-options) search for "db_version" under the option_name column (use <ctrl><F>) and look at the option_value value. I am assuming it will be 19470 (this is the 3.3.2 version number). The co to wp-content, version.php and change the db_version value to 19470 from 20596 (3.4).

    That is, note the value from the database table and edit the one in version.php to match. You'll probably have to look at the database with something like PHPMyAdmin on your website host's server. General instructions for doing this can be found on one of my websites (as it happens):

    http://www.websitetavern.com/saloon/wordpress-2/wordpress-password-phpmyadmin/

Reply

You must log in to post.

About this Topic