So zero dates are deprecated in MySQL. J4 has replaced them with nulls.I am trying to update a J3 component to stop J setting zeros in the modified and checked_out_time fields.
For modified I am using table prepareTable() to set an empty modified date from the form to NULL for saving and table getItem() to replace nulls in modified with a zero date to keep the calendar control happy.
The problem is with checked_out_time which is set back to zero by joomla in a separate query when the item is closed (ie after save).
How can I override this to force Joomla to save a valid for MySQL date?
checked_out_timeDATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' so I've not had this issue.