Test installation, ZC 2.0.0, no plugins PHP 8.2 and 8.3, importing database from ZC158a.
When performing a test update to v2.0.0 by importing my v1.5.8a database from production
I receive the error
Code:
[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)
The command in question is from lines 282 - 284 in "zc_install\sql\updates\mysql_upgrade_zencart_200.sql"
Code:
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;
If I run the SQL command from admin | Install SQL patches against the zc158a database before I upgrade with zc_install it works.
If I run the command in PhpMyAdmin it works.
It doesn't matter whether I use a database prefix or not.
I have checked the script for non-ansi chars and reentered the statement.
I have to assume that it is some obscure MariaDB bug.
Bookmarks