rosarnach

I managed to fix it!

As you can see, the value in the options table for db_version was null.

I set it to 30133 and the “upgrade the database” error message in wp-admin finally went away.

Thanks for steering me in the right direction David!

Thanks David.

Below is the only mention of db_version on its own in the .sql file

(49, 'db_version', '', 'yes'),

Hi David!

Thanks for the clarification.

When I search the .sql file in Notepad++, below is the most relevant result:

(88, ‘initial_db_version’, ‘29630’, ‘yes’),

Should I install a WordPress version associated with a database version of 29630? If so, what version would that be?

David

Hi David:

The value of ‘db_version’ in the WP options table for the new install of WordPress is also 30133.

David

Thanks for the follow-up David.

The value in version.php on the site I wish to restore is $wp_db_version = 30133; (Note: This value is the same as the restored version.)

The value of the ‘db_version’ option in the WP options table for the new install of WordPress is also 30133. This is when I still get the nag screen in wp-admin to update the database.

I’ve double-checked the above to ensure that I am using the correct database as there are multiple databases now due to multiple WordPress installs and the way that 1 & 1 Hosting treats WordPress installs in its so called “safe” mode and “normal” mode.

David

Thanks for reply David.

The only plugin running that might change the WordPress version is WordFence, but I don’t see in its documentation where it says it changes the version.

The site is shared hosted at 1&1.com and WordPress was first installed in November 2014. I don’t recall any major database changes to WordPress in that time and as we are at 4.1.1.

What version of WordPress is the database using? Should I consider a reinstall of the old WordPress version first?

David

Thanks for the follow-up David.

Here are the first 10 lines.

# WordPress MySQL database backup
# Created by UpdraftPlus version 1.9.60 (https://updraftplus.com)
# WordPress Version: 4.1.1, running on PHP 5.5.22 (Apache), MySQL 5.1.73
# Backup of: https://theceliacscene.ca
# Home URL: https://theceliacscene.ca
# Content URL: https://theceliacscene.ca/wp-content
# Table prefix: v8j1j6ks7z
# Filtered table prefix: v8j1j6ks7z
# Site info: multisite=0
# Site info: end

Thanks for the suggestions guys, it’s appreciated.

The same version of WP was used for both the backup and restore (the latest version 4.1.1.)

I’ve had great success with Updraft in the past on other sites and love the automatic backup to Dropbox feature.

I’m not sure what else to try.

David