#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


