Reply To: three sql errors when upgrading from 2013.1.beta.8


I just performed a fresh install of the simpleinvoices 2013 beta 8 version and then performed an update to the current version of fearless359 master_2019.2 version.

The only issue I ran into is that an error was thrown for an invalid default value for the ‘date’ field. The ‘date’ field is an existing field and defaults to, 0000-00-00 00:00:00. The fix was to change the sql_mode setting in the my.ini file and restarting the mysql service to implement the change. After this, the update process ran without incident.

I updated the Requirements documentation on the left menu to explain how to make this change.

While zero dates are generally frowned upon (hence the default to disallow them), they are ingrained in SI and so for now it makes sense to allow them.