Upgrade to PS_9.1.3 from 9.0.1 - PS_VERSION_DB mismatch blocking upgrade

[Becold]

Prerequisites

• I understand and accept the project's code of conduct.
• I have already searched in existing issues and found no previous report of this bug.

Describe the bug and add attachments

When attempting to upgrade PrestaShop to the latest version, the process is blocked by the following error:
(translated from French) "The PrestaShop version does not match the one stored in the database. The structure of your database may not be up to date and/or the value of PS_VERSION_DB may need to be updated in the configuration table."

Given this situation, I would like to better understand how to safely diagnose and resolve it:

• Is there a way to verify the integrity and consistency of my database?
• Is there a way to check whether a previous auto-upgrade failed partially (e.g., some database migrations not applied)?
• Should PS_VERSION_DB be manually updated, or would that risk further inconsistencies?
• Are there any tools or scripts available to validate or reapply missing database schema updates?

This issue likely appeared after a previous upgrade attempt, which may not have completed successfully.

Steps to reproduce

Open AutoUpgrade assistant
Try to update to latest version

Expected behavior

Prestashop can be upgraded to PS_9.1.3 without this error

Actual Result

The upgrade process cannot proceed due to this error.
The shop itself is still functioning normally on the current version.

PrestaShop versions where the bug happens

9.0.1 to 9.1.3

Module version where the bug happens

7.6.5

PHP version(s) where the bug happened

8.4.21

Your company or customer's name goes here (if applicable).

No response

[Quetzacoalt91]

Was the last attempt a long time ago? It may be interesting to restore a backup dated before the update.

If the restoration is not possible (i.e if the backup is too old and you would loose business data), I'm afraid you will have to check and execute the remaining SQL requests by yourself.

You can have a look at the logs of the last update, located in [store_admin_folder]/autoupgrade/logs/. You should find there files with the type of action in their name, followed with the date of the process. Opening the last one about the update should tell you where the process failed.

Once you got the last failed SQL request, open the migration scripts (https://github.com/PrestaShop/autoupgrade/tree/dev/upgrade/sql, or in your Update Assistant module in modules/autoupgrade/upgrade/sql/. Update the module to make sure you have the latest version). Using the migration files between the original and destination version of PrestaShop during the last update, you should run all the remaining migration requests listed.

When you're done, finalize the database update with this request:

UPDATE `[prefix]configuration` SET value="[target_ps_version]" WHERE name = "PS_VERSION_DB";