Troubleshooting PrestaShop 1.7.4.2 Update: Missing ps_version.db

PrestaShop 1.7.4.2 Update Issue: Missing ps_version.db

A user encountered an error during a PrestaShop update from version 1.7.4.2, reporting a missing ps_version.db file and related issues with database versioning. This file is crucial for PrestaShop to track the current database schema version and apply necessary updates during the upgrade process.

The original poster (luis mi) indicated that the ps_version and ps_install files were absent from the configuration folder, which is unusual and points to a potentially incomplete or corrupted PrestaShop installation.

Possible Causes:

• Incomplete file transfer during a previous update or migration.
• Accidental deletion of the ps_version.db file.
• Database corruption.
• Permissions issues preventing PrestaShop from accessing or creating the file.

Troubleshooting Steps and Considerations:

The single reply received suggested checking the database version. While brief, this highlights the importance of verifying the current database state. Here's a more detailed approach to troubleshooting this issue:

1. Verify Database Connection: Ensure that PrestaShop can connect to the database. Check the parameters.php file (located in /config/) for correct database credentials (host, username, password, database name).
2. Check Database Version: As suggested in the reply, determine the current version stored in the database. This can be done by querying the ps_configuration table:

   SELECT * FROM ps_configuration WHERE name = 'PS_VERSION';

   If the table or the PS_VERSION entry is missing, it confirms the database version information is corrupted.
3. Restore from Backup: If a recent database backup is available, restore it. This is the safest way to revert to a known working state.
4. Manually Create ps_version.db (Advanced): If a backup isn't available, and you know the exact PrestaShop version you're running, you might be able to create a ps_version.db file manually. However, this is risky and should only be attempted by experienced users. The file should contain the version number.
5. Check File Permissions: Ensure that the PrestaShop user has read and write permissions to the /config/ directory and its contents.
6. Re-upload Core Files: Re-upload the core PrestaShop files (excluding the /modules/, /themes/, and /img/ directories, and the /config/parameters.php file) from a clean PrestaShop 1.7.4.2 archive. This can replace any missing or corrupted files.
7. Consult PrestaShop Forums: Search the PrestaShop forums for similar issues and solutions.

Important Considerations:

• Always back up your database and files before attempting any updates or modifications.
• If you're not comfortable with database administration, consider hiring a PrestaShop expert.

The lack of detailed solutions in the original thread highlights the need for more comprehensive documentation and troubleshooting guides for PrestaShop update issues.