home.social

#fuzzydates — Public Fediverse posts

Live and recent posts from across the Fediverse tagged #fuzzydates, aggregated by home.social.

  1. Peter B. @[email protected] ·

    #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:
    accesstomemory.org/en/docs/2.9

    #artefactual #atom #fuzzydates