Can’t update database after wordpress update from 3.8.1 to 4.4.1

In general, it is a bad idea to upgrade from such an old version to new version in one go. In your case, a huge amount of changes was done between the release of v3.8.1 and v4.4.1 which invloved changes in the db.

I’m not sure which is the best option here to repair the db as it seems that you cannot log into the site. What I would suggest is, revert back to v3.8.1 and get everything running again. At this stage, it would be good idea to download, install and run a plugin like DB Manager (to which I have no affiliation to) to repair and optimize your db.

Once this is sorted, you will need to manually update WordPress in steps. Download all major versions between v3.8.1 and v4.4.1, so would download v3.9, v4.0, v4.1 etc. You should then start by upgrading to v3.9, after that, upgrade to v4.0 until you are fully upgraded.

Once done, you can rerun DB Manager.

TIP:

Since a huge amount of changes between v3.8.1 and v4.4.1, it would be a very good idea to download and install Debug Objects to catch any bugs as there was a lot of depreciation done between those versions. Make sure that you catch and repair all those bugs

Related Posts:

  1. Prevent changing the length of post_name column on WordPress Update
  2. Add search Value to wp_list_table pagination
  3. What ALL can cause “Another update is currently in progress.”? [closed]
  4. Trigger Plugin database update after git pull
  5. Why are no posts showing despite my apparently correct DB restoration?
  6. Are custom tables in the database overwritten when WordPress is updated to new versions?
  7. How to get the SQL of the changes made to the database from an update or upgrade?
  8. Retrieve data from the database to table such as comments in the admin control panel
  9. Update from 4.5 to 4.6 failing
  10. Migrate database between 2 different wordpress version
  11. Is database deleted on clicking “reinstall” button in WordPress updates?
  12. Adding prefix to WordPress database tables breaks admin capabilities?
  13. What is the best way to resurrect and update my old WordPress site?
  14. Is my way to change WordPress server is correct?
  15. Disable Database Update Required ? break my website
  16. Brandoo WordPress Unable to Update to WordPress 4.2.2
  17. Custom Post Type not showing anything added by code anymore?
  18. Will adding & modifying default WordPress table index break future WordPress update
  19. Updating seperate database when post attachment is changed
  20. WordPress site migration – locked out of admin area
  21. Adding last value from Database as text in WordPress Page
  22. WordPress Migration – Issue with admin panel changes
  23. WordPress URL error for links
  24. get_the_terms is not working
  25. Recover Same WordPress Admin Password
  26. cannot access wp-admin after options table crash and repair
  27. wp-config was suddenly updated
  28. Database Queries are crashing the server
  29. How to protect my credentials on my clients website
  30. What is this JavaScript “require”?
  31. How can I make updates to a site, on a development copy, but then move updates back without overriding live site’s evolving database?
  32. get_results using wpdb
  33. How can I make a WordPress database portable and url independent?
  34. wpdb->insert multiple record at once
  35. How to migrate a HTTPS WordPress installation to localhost?
  36. How to stop WordPress using utf8mb4_unicode_520_ci collation?
  37. How to monitor server for error establishing a database connection
  38. Default WordPress settings API data sanitization
  39. Fatal error: Call to undefined function dbDelta()
  40. Connect to remote database using Localhost install
  41. remove missing image attachments
  42. Updating WordPress – the best approach (updating wp core, plugins and db)
  43. Transient RSS feeds in wp_options not removed automatically?
  44. How to ensure data consistency in WordPress
  45. Database location in WordPress
  46. How to intercept update_option() before it saves data?
  47. Error establishing a database connection – with Debug Data
  48. Finding the login page from database?
  49. When and why should I use $wpdb different return types?
  50. Database with mixed collation (utf8mb4 & utf8_general_ci)
  51. How do I allow users to follow a post and then allow admins to email all users who have followed that post?
  52. Delete all post meta except featured image Using SQL
  53. WordPress doesn’t show all posts in database
  54. Adding new row to wp_post table
  55. Extracting the post_id via the wp_insert_post action (external db query)
  56. How to interact with another wordpress install on same database?
  57. batch UPDATE autoload value in wp_options table
  58. Saving into post_excerpt or post_content
  59. Maintain user profile data in a non-WordPress database
  60. How to fix the disappearance of the “\” character when updating a post in the database
  61. Data storage for JS app using WP REST API
  62. How can I push local database changes to production, without impacting recent posts/pages that were published on production server?
  63. Setup private content for specific users with daily updates [closed]
  64. Connection refused on locahost after importing database?
  65. Removing Dashboard Menu Items Through The Database
  66. creating new field on mysql
  67. Does WordPress store the username as a primary key in the database?
  68. WSOD 3.9.1 – Tried Everything so far
  69. Can you refresh ONLY the wordpress adminbar and not the whole page?
  70. Sending posts from Python to WordPress
  71. How to allow WordPress updates to only one specific administrator?
  72. Problem migrating to localhost
  73. SQL query to set posts in bulk based on the post content
  74. Automate WordPress website setup with prefilled data
  75. How do you render posts from outside wordpress?
  76. Second ezSQL initialization for MSSQL
  77. Fetch a single row from a custom table for to a given ID
  78. Database create or redirect
  79. Database structure cheatsheet
  80. White Screen in Home Page
  81. How to escape percentage sign(%) in sql query with $wpdb->prepare?
  82. WordPress has been updated! Before we send you on your way, we have to update your database to the newest version
  83. Malware in old website – how to migrate?
  84. A WP dev site that displays content from a live site’s database but cannot write to wp_posts?
  85. error establishing database connection (WAMP + filezilla)
  86. Is there a way for two deferent themes to consume two different DB on a same WP instance?
  87. How do I update a WordPress wp_postmeta meta_value that contains many options
  88. How to display $wpdb->insert_id; value on redirected page
  89. Should I Use only wpdb Class to Write Custom Queries?
  90. Auto populate form fields based on serial input or pull listings from other websites?
  91. How to extract some part of WordPress full source code
  92. Error establishing a database connection for some files
  93. Hash user emails in database?
  94. Weird characters in title if it contain “ ”
  95. DB access blocked when initializing WP externally
  96. Saving data to database and exporting to excel
  97. Site does not work right, pages not showing up, even for root admin
  98. One information repeated on multiple locations on one site [closed]
  99. Showing Error(TAble already exist)
  100. Query a meta key using an array of values where the database value is a string

Leave a Comment