#Artefactual #AtoM catalog system 📜

"500 server error"

when saving items with #fuzzyDates, like year-only:

FastCGI sent in stderr: "PHP message: Unable to execute INSERT statement. [wrapped: SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect date value: '1990-0-0'

Reason:
mysql default config has this setting:
🔥🔥 🔥 `NO_ZERO_IN_DATE` 🔥🔥🔥

Fix (in `/etc/mysql/mysql.cnf`):
sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION

See:
https://accesstomemory.org/en/docs/2.9/admin-manual/installation/ubuntu/#install-the-dependencies