Database errors after moving remote db to localhost

Question

I've recently run into a strange issue after upgrading to 3.6.5. I've been trying to resolve issues with a failed one-click-update to my live site.

Thankfully, I had a pre-updated backup living on a test server. I synchronized the content and then ran the updates on the test server. When I copy the code base and db to my local machine, the site and content are correct, but when I go to Extensions => database I get notified that the database is not up to date and there are errors.

I'm really perplexed as to what is happening here, because the site is fine on the test server, but has database problems on my localhost setup. Theoretically, there's no reason for this. I don't want to move to the db to live site until I know what's going with this.

Answer 1

One of the last steps in the update process is to apply any schema changes, after files are copied in. If the one-click update fails, then the schema changes might not have been applied.

This will result in warnings that your database is not up to date with the code.

Navigate to Extensions > Manage > Database. If this is the problem, then you should see a warning message. The "Fix" button in the upper left corner ensures that all database changes have been applied and should resolve the problem.

Failing that: backups, backups, backups. is exactly correct.

Answer 2

Try the Fix button in the upper left corner. Often worked for me.