Clean install of Zen Cart 1.5.4 ran successfully for me under Windows 10, Apache 2.4.17, PHP 5.6.14, and MariaDB 10.0.17 (all x64).
Clean install of Zen Cart 1.3.9h ran successfully for me under Windows 10, Apache 2.4.7, PHP 5.3.29, and MariaDB 10.0.17 (all x64).
Upgrade of Zen Cart 1.3.9h to 1.5.4 ran successfully for me under Windows 10, Apache 2.4.17, PHP 5.6.14, and MariaDB 10.0.17 (all x64). Method used:
How to rebuild my site on the new version of Zen Cart.
Upgrade of Zen Cart 1.3.9h to 1.5.4 ran successfully for me under Debian 8, Apache 2.4.10, PHP 5.6.14 (FPM), and MariaDB 10.0.22 (all x64). Method used:
How to rebuild my site on the new version of Zen Cart.
So at least in my test environments Zen Cart and MariaDB are playing well together. If you find some time and want to dig further... Can you enable full debug for PHP, Zen Cart, and LiteSpeed (or OpenLiteSpeed) and see what (if anything) is generated... I'd be interested in hearing the root cause of the issues you were experiencing if they can be tracked down...
NOTE 1: Used mysqlnd for database connections. DEMO data was used during testing. Stock installations of Zen Cart were used with NO modifications except for applying bugfixes from the Zen Cart official "known issues and workarounds" threads.
NOTE 2: It has been almost two years since the last time I looked at LiteSpeed (for a client). I seem to remember in the past LiteSpeed (and OpenLiteSpeed) requiring conversion of some Apache directives to LiteSpeed equivalents... Especially dealing with directives in .htaccess files.
Bookmarks