wordpress 4.1 database upgrade crashes

  • Resolved c

    (@igneous)


    9 years, 10 months ago

    My site keeps trying to install 4.1 automatically, so when I go to the admin panel I get the database upgrade page. When I try to do that, it tries to upgrade, but ultimately times out, and I have to restart my database server. So I just reintall 4.01 and everything works fine again until it tries to upgrade again. I havent been able to find any answers on how to fix it. I cleaned and repaired the database in phpmyadmin, but other then that I dont know what else to do. Any thoughts?
    Thanks

Viewing 5 replies - 1 through 5 (of 5 total)

  • Try to log in your wordpres and go to Tools -> Exort and export All content to a XML file.
    Then, install a fresh wordpress 4.1 and retore files and import the content.

    Thread Starter c

    (@igneous)

    I may have to do that, but its the last thing I really want to do since I have tens of thousands of posts, even more comments, and all that so I can just see so much going wrong with that approach. Still cant find out why its doing this though

    I think zhuji91 is right that you should do a fresh install with your exported data. If you’re worried that you may have trouble doing it, then perhaps you could practice it locally on your machine using WAMP/MAMP instead of on your live site.

    Thread Starter c

    (@igneous)

    I’m getting these errors in my logs, does anyone have a clue what this may be pointing to or what I could do to fix it?

    WordPress database error Duplicate entry ‘as_prepared’ for key ‘option_name’ for query ALTER TABLE wp_options ADD UNIQUE KEY option_name (option_name) made by wp_upgrade, make_db_current_silent, dbDelta
    `

    WordPress database error Lock wait timeout exceeded; try restarting transaction for query INSERT INTO wp_options (option_name, option_value, autoload) VALUES (‘_site_transient_update_core’, ‘O:8:\”stdClass\”:3:{s:7:\”updates\”;a:0:{}s:15:\”version_checked\”;s:3:\”4.1\”;s:12:\”last_checked\”;i:1423251035;}’, ‘yes’) ON DUPLICATE KEY UPDATE option_name = VALUES(option_name), option_value = VALUES(option_value), autoload = VALUES(autoload) made by do_core_upgrade, Core_Upgrader->upgrade, do_action(‘upgrader_process_complete’), call_user_func_array, wp_version_check, set_site_transient, add_site_option, add_option

    Thread Starter c

    (@igneous)

    Finally got it to work. I used a couple database optimization plugins(removed over 600 megs of useless data) and it finally went through ??

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘wordpress 4.1 database upgrade crashes’ is closed to new replies.