AVeryNiceWeb

How To Prevent 'Database Update Required'

How To Prevent 'Database Update Required'

Postby admin » Tue Nov 28, 2017 3:31 pm

Database-Update-Required.png
Database-Update-Required.png (20.62 KiB) Viewed 16 times

You just imported your WordPress SQL file using phpMyAdmin, you tried to refresh your site and instead you see this error message:
Database Update Required

WordPress has been updated! Before we send you on your way, we have to update your database to the newest version.

The update process may take a little while, so please be patient.

Update Wordpress Database


Well, if you click on that you will run into problems with many of your plugins and extensions. What to do?

You need to trick the WP Update sequence by telling it that you are already caught up.

  1. Go to /~root/wp-include/ and open the version.php.
  2. Find the value for $wp_db_version, and write it down.
  3. Now, open your database, check in the table called wp_options
  4. Find the db_version value by doing a search for the keyword "version" or maybe "db_version":
  5. Look in the results for the table WP_Options
  6. SELECT option_value FROM the database table/wp_options WHERE option_name = 'db_version';
  7. Those two values must match with your system file (version.php). Change it the one in version.php file, not the in database!
  8. Clearing browser cache (Shift+F5).

That should work and give you this:
No-Update-Required.png
No-Update-Required.png (14.94 KiB) Viewed 16 times


For example: Your WordPress version was 4.6 and now wants to be updated to 4.9 (see screenshots):
You already know that your version was 4.6 so change that first.
So, go ahead drop all your table again and import your old MySQL database via phpMyAdmin.
Do the keyword search as instructed above an find that table.
Take a look at the table now...see the number?

This code is hidden: 

To view this code please make a small donation or login to see it!


If the option db_upgraded isn’t getting set by the upgrade process. Try this: go to ~root/wp-admin/options.php. Fill the field db_upgraded with a 0 (zero). Then save.
Attachments
database-update-issue-phpmy.png
database-update-issue-phpmy.png (49.96 KiB) Viewed 15 times
database-update-issue-versi.png
database-update-issue-versi.png (21 KiB) Viewed 15 times
database-update-issue-ftp.png
database-update-issue-ftp.png (20.29 KiB) Viewed 15 times
The AVNW Support Team
http://www.AVeryNiceWeb.com

We also have great domain names for your next website. Go through the list and make an offer now!

Shopping for a new website? See our design deals.

How much is your website worth? Get a free estimate.

And, if our post has provided you with great information, there are a few ways you can show your appreciation:
  1. Like us on Facebook
  2. Post a review.- Posting a good review about this site could help us provide improved support.

Thank You!
User avatar
admin
Site Admin
 
Posts: 483
Joined: Sun Jan 12, 2014 11:18 pm
Location: New York City

Return to WordPress

Who is online

Users browsing this forum: No registered users and 0 guests

cron