Fatal Database write error when paying invoice [SOLVED]

[TimSchofield]

This is an issue that has been discussed off and on for over a decade. MySQL can run in different server SQL modes (https://dev.mysql.com/doc/refman/8.0/en/sql-mode.html) one of which is NO_ZERO_IN_DATE. Different installs of MySQL come with different modes set, and some include this NO_ZERO_IN_DATE mode, others don't.

To fix the definition for this particular table simply run the SQL:

ALTER TABLE supptrans MODIFY COLUMN duedate date NOT NULL DEFAULT '2000-01-01';

and it should change the default date. However you will run into this issue elsewhere.

A longer term solution is to read the link on SQL server modes above, and change the default server mode for your installation.

Thanks
Tim