In Zen Cart 2.0.0 and 2.0.1, the update to the project_version_history table may not work. If it fails, you'll see an upgrade log that looks like this:
[08-Apr-2024 06:15:40 UTC] MySQL error 1064 encountered during zc_install:
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1
INSERT INTO zen_project_version_history (project_version_key, project_version_major, project_version_minor, project_version_patch, project_version_date_applied, project_version_comment)
If this happens, update the table in Admin > Tools > Install SQL Patches or phpMyAdmin. If you are using phpMyAdmin and your tables have a prefix, you will have to add the prefix to the SQL statements manually.
INSERT INTO project_version_history (project_version_key, project_version_major, project_version_minor, project_version_patch, project_version_date_applied, project_version_comment)
SELECT project_version_key, project_version_major, project_version_minor, project_version_patch1 as project_version_patch, project_version_date_applied, project_version_comment
FROM project_version;
That Software Guy. My Store: Zen Cart Support
Available for hire - See my ad in Services
Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.
Do you benefit from Zen Cart? Then please support the project.