Textpattern issues with MariaDB 11.8

I recently updated a MariaDB server to 11.8 LTS, their latest long term support release. Immediately I started seeing issues on Textpattern 4.9.1 sites I sysadmin for people. Creating new articles works, but editing existing articles results in the following error shown across the bottom of the screen: The article was not saved due to an error. Please try again. Logs didn’t immediately indicate anything, so I restored my database backups to a MariaDB 10.11 LTS server and pointed Textpattern to it, and the problem ceased. I checked out the Textpattern forums, and a few threads indicate this is related to a breaking change MariaDB introduced with UNIX_TIMESTAMP in 11.8. Past versions returned 0, but now it returns NULL. This causes a type casting issue on Textpattern (and may also be responsible for other bugs in stuff I host). I updated MariaDB from 10.11 LTS and 11.4 LTS to 11.8 LTS more out of curiosity, but I’ve downgraded everything back to 10.11 LTS for now. It’s supported for a…