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 🙂
