Support » Installing WordPress » Database won’t upgrade in 2.9

  • I upgraded to 2.9 on one of my sites but am unable to go past the database upgrade procedure. It chugs away for a while and then displays the WordPress logo. Going back to /wp-admin presents the db upgrade screen again, and the cycle continues.

    This only happens on one site; it’s database is 296MB. The other installations with smaller databases upgrade without much of a problem.

    One thing I discovered with this particular upgrade (from 2.8.6 to 2.9) is that you need to switch of WP-Super-Cache and turn caching off in the wp-config.php file (change “true” to “false”).

    I hope you can give me some pointers as to what is required to complete the upgrade.

    Frustrating!
    http://mahmood.tv

Viewing 5 replies - 1 through 5 (of 5 total)
  • Similar problem here. Deactivated all plugins through phpmyadmin, still didn’t help.
    Any help on this would be so friggin cool!

    Found solution for my issue in this thread!
    http://wordpress.org/support/topic/342965?replies=20
    Except in my case my db_version was ‘9872’. Solution is below(thanks Matoo).

    ——————
    I followed jalmz link : http://www.clickonf5.org/wordpress/solution-database-upgrade-required/2247.

    My problem was indeed that the Option_Value for the Option_Name db_version was ‘11548’ instead of ‘12329’ (http://codex.wordpress.org/Version_2.9).

    I changed it with phpmyadmin, and I recovered my brand new 2.9 wordpress blog.
    ———————–

    Thanks! I had a similar trouble, and this seems to have solved the problem.

    changing the database version in the options does not create the required tables and links provided in the upgrade script! be careful.

    Finally resolved.

    As the database is over 6 years old, it collected a lot of optional plugin installs and un-installs over the years which unfortunately left quite a number of unused tables in the database. The Options table too was seriously bloated – to the tune of 122MB!

    So:
    1. I manually went in and removed the no longer needed tables (after backing up the database of course)
    2. I manually edited the db version number in the options table (as given above, thanks!) to 12329 to force going beyond the forced upgrade page
    3. I went to the admin panel, downloaded, installed and activated the “Clean Options” plugin.
    4. I got the plugin to remove all the hash rss entries (over 8 thousand of them!)
    5. I got the plugin to evaluate all the remaining entries in the table to determine the most likely unneeded entries and double checked them all. Selected the ones I know to be unneeded and deleted them.
    6. The above operation reduced the database size from 310MB down to 58MB!! Serious weight loss 😉
    7. I re-edited the options value to put in the old database version of 11548
    8. Went to the Admin panel again /wp-admin
    9. Clicked the “upgrade database” button, and then within seconds the upgrade was reported successful and I have my blog back!

    Moral of the story? Maybe plug-in developers should clean up their database entries on deactivation of their plugins. And wish the WordPress team would consider adding this clean-up operation in a future version.

    Best regards and thanks for continuing to develop WordPress
    Mahmood Al-Yousif
    http://mahmood.tv

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Database won’t upgrade in 2.9’ is closed to new replies.