I upgraded from 155f to 157b but had a db failure
[04-Dec-2020 14:32:27 Europe/Berlin] MySQL error 1292 encountered during zc_install:
Incorrect datetime value: '0000-00-00 00:00:00' for column `zencart157btest`.`customers`.`gdpr_accept_date` at row 1
Dr Byte answered this is based on old ways of handling dates, and only built for old MySQL versions not using strict-mode.
So following his advice I set the default for the gdpr date/time columns to "0001-01-01 00:00:00" and ran this piece of code to fix existing entries
UPDATE customers SET gdpr_accept_date = '0001-01-01 00:00:00' WHERE gdpr_accept_date < '0001-01-01' and gdpr_accept_date is not null;
UPDATE customers SET prev_gdpr_accept_date1 = '0001-01-01 00:00:00' WHERE prev_gdpr_accept_date1 < '0001-01-01' and prev_gdpr_accept_date1 is not null;
UPDATE customers SET prev_gdpr_accept_date2 = '0001-01-01 00:00:00' WHERE prev_gdpr_accept_date2 < '0001-01-01' and prev_gdpr_accept_date2 is not null;
UPDATE customers SET prev_gdpr_accept_date3 = '0001-01-01 00:00:00' WHERE prev_gdpr_accept_date3 < '0001-01-01' and prev_gdpr_accept_date3 is not null;
UPDATE customers SET gdpr_decline_date = '0001-01-01 00:00:00' WHERE gdpr_decline_date < '0001-01-01' and gdpr_decline_date is not null;