Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#16 Today 12:48:58

gaekwad
Server grease monkey
From: People's Republic of Cornwall
Registered: 2005-11-19
Posts: 4,795
GitHub

Re: MariaDB 11.8: can create article; cannot revise same article

Following up. My OP issue has been resolved, I ended up reverting and repaving with Percona and some judicious & sweary housekeeping as I’d spent 4 hours troubleshooting the MariaDB bum ache and this is a somewhat time-sensitive issue.

For info, I used the default charset and collation with a known-good backup from the same vendor. Smooth sailing. Note: the utf8mb4_0900_ai_ci collation is default on Percona Server 8.0, at least in this server instance. There’s a mix of utf8* charsets, but I can’t see any immediate issues:

Charset (default/config): utf8mb4/utf8mb4
character_set_client: utf8mb4
character_set_connection: utf8mb4
character_set_database: utf8mb4
character_set_filesystem: binary
character_set_results: utf8mb4
character_set_server: utf8mb4
character_set_system: utf8mb3
character_sets_dir: /usr/share/mysql/charsets/
collation_connection: utf8mb4_0900_ai_ci
collation_database: utf8mb4_0900_ai_ci
collation_server: utf8mb4_0900_ai_ci
18 database tables: OK

Thank you Bloke, etc, bici, phiw13, and jakob – your advice and wisdom is always appreciated.

Last edited by gaekwad (Today 12:58:13)

Offline

Board footer

Powered by FluxBB