I wonder if the above is to do with MySql Strict Mode, although I had no problem with the same database version on ZC v1.5.8

(I am running MySQL 5.5.68-MariaDB, I know, but an upgrade is in my sights - I have to update my VPS from CentOS 7 to Alma 8 which is a bit of a headache)