Zero Dates in ezpages table (and possible some others) Unchecked

[PanZC2020]

I wonder if there is a way to check zero dates if it is added beyond the default Zen Cart base columns?

This time, I tried to update Zen Cart to V. 1.5.6b (I downloaded files from GitHub under V156 branch).
(On last bug about customers_basket table's bug (on this topic, I was manually removed zero dates before updating.)

However, even with GitHub files, update process still gave me this error.

[29-Jan-2019 20:06:19 UTC] MySQL error 1292 encountered during zc_install:
Incorrect datetime value: '0000-00-00 00:00:00' for column 'last_modified' at row 3
ALTER TABLE ezpages DROP languages_id, DROP pages_title, DROP pages_html_text;
---------------


[29-Jan-2019 20:06:19 UTC] MySQL error 1292 encountered during zc_install:
Incorrect datetime value: '0000-00-00 00:00:00' for column 'last_modified' at row 3
ALTER TABLE ezpages ADD status_visible int(1) NOT NULL default '0';
---------------

Therefore, I checked if there are zero dates still left on update table.
Sure enough...
There are still zero dates in "ezpages" table.


I went ahead to check if the latest file in \zc_install\sql\install\zero_dates_cleanup.sql contain any cleanup for ezpages?
Searched with Notepad++ for that file... Nope!

Search "ezpage" (0 hits in 0 files)

Therefore, "ezpages" table was not cleaned up for zero dates!

I double checked and I think "ezpages" table does NOT seems to have "last_modified" when it installed with Zen Cart under default settings.

So, I wonder, for people who may installed some add-ons that ended up have "last_modified" dated with zeros beyond normal Zen Cart installs...
How would they detected zero dates before they update their shops to 1.5.6a/1.5.6b and beyond?
As such errors like above can lose database integrity due to errors will lead to SQL statements being skipped.

-PanZC2020