v2.0.0 syntax error updating zen_project_version_history with MariaDB

[OldNGrey]

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

[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"

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.

[carlwhat]

...
I have to assume that it is some obscure MariaDB bug.

i just think that is a bad assumption...

it works from phpMyAdmin; it works from the install mysql patch; it does not work from the installer...

its rather curious...

it happened to me as well. but i have not been able to figure it out as of yet... i may never... other fish to fry...

but i'm doubtful on your assumption.