Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
MariaDB 11.8: can create article; cannot revise same article
I can create a new article with content (at least in Draft state, that’s my testing so for), but subsequent revisions are not possible – I see a “The article was not saved due to an error. Please try again.” error.
Notable difference to my usual setup is I’m using MariaDB 11.8, having migrated from MySQL 8.0. The database user has all available privileges granted to the database. Nothing strange in the PHP error log.
Any pointers very graciously received. Thank you.
Textpattern version: 4.9.1 (42c24f9149210e093e6a455b497438f62df6a7acb42d38a3)
Last update: 2026-02-15 18:57:20/2026-02-15 18:56:44
Textpattern path: __TXP-ROOT/textpattern
Article URL pattern: section_title
Production status: live
PHP version: 8.5.3
GD Graphics Library: 2.3.3; Supported formats: GIF, JPEG, PNG, WebP.
Server time zone: Europe/London
Server local time: 2026-02-27 14:39:23
Daylight Saving Time enabled?: 0
Automatically adjust Daylight Saving Time setting?: 1
Time zone (GMT offset in seconds): Europe/London (0)
MySQL: 11.8.6-MariaDB-ubu2404 (mariadb.org binary distribution)
Database server time: 2026-02-27 14:39:23
Database server time offset: 0 s
Database server time zone: SYSTEM
Database session time zone: SYSTEM
Locale: C
Site / Admin language: en-gb / en-gb
Web server: nginx/1.29.5
PHP server API: fpm-fcgi
PHP SSL version: OpenSSL 3.0.13 30 Jan 2024
RFC 2616 headers: 0
Server OS: Linux 6.8.0-55-generic
Admin-side theme: hive 4.9.1
Active plugins:
etc_cache-0.2.8
smd_thumbnail-0.5.3
Pre-flight check:
------------------------
You have PHP enabled in your articles/pages. To improve security from potentially malicious and damaging code, consider switching these off via the Preferences panel, unless you absolutely need to embed PHP functionality in your site.
------------------------Last edited by gaekwad (2026-02-27 14:43:46)
Offline
Re: MariaDB 11.8: can create article; cannot revise same article
Hmm. Weird. Anything reported in the Inspector Console or Network panes when you hit Save that might give us further clues?
The smd plugin menagerie — for when you need one more gribble of power from Textpattern. Bleeding-edge code available on GitHub.
Hire Txp Builders – finely-crafted code, design and Txp
Offline
Re: MariaDB 11.8: can create article; cannot revise same article
Tough case, no debug information is output. It looks like the article data passes the validation, but something breaks on safe_update(). Pete, is it a live site?
Offline
Re: MariaDB 11.8: can create article; cannot revise same article
Thank you. I’ll email you both with context.
Offline
Re: MariaDB 11.8: can create article; cannot revise same article
It would be great to hear whether other mariadb 11.8 users experience the same issue.
Offline
Re: MariaDB 11.8: can create article; cannot revise same article
Posting some (anonymised) High diagnostics – signs point to it being a collation / encoding snag with the database transfer, but I’d really appreciate additional eyes. Thank you.
Textpattern version: 4.9.1 (42c24f9149210e093e6a455b497438f62df6a7acb42d38a3)
Last update: 2026-02-15 18:57:20/2026-02-15 18:56:44
Textpattern path: __TXP-ROOT/textpattern
Article URL pattern: section_title
Production status: live
PHP version: 8.5.3
GD Graphics Library: 2.3.3; Supported formats: GIF, JPEG, PNG, WebP.
Server time zone: Europe/London
Server local time: 2026-03-01 11:17:03
Daylight Saving Time enabled?: 0
Automatically adjust Daylight Saving Time setting?: 1
Time zone (GMT offset in seconds): Europe/London (0)
MySQL: 11.8.6-MariaDB-ubu2404 (mariadb.org binary distribution)
Database server time: 2026-03-01 11:17:03
Database server time offset: -1 s
Database server time zone: SYSTEM
Database session time zone: SYSTEM
Locale: C
Site / Admin language: en-gb / en-gb
Web server: nginx/1.29.5
PHP server API: fpm-fcgi
PHP SSL version: OpenSSL 3.0.13 30 Jan 2024
RFC 2616 headers: 0
Server OS: Linux 6.8.0-55-generic #57-Ubuntu SMP PREEMPT_DYNAMIC Wed Feb 12 23:42:21 UTC 2025 x86_64
Admin-side theme: hive 4.9.1
Active plugins:
etc_cache-0.2.8
smd_thumbnail-0.5.3
Pre-flight check:
------------------------
You have PHP enabled in your articles/pages. To improve security from potentially malicious and damaging code, consider switching these off via the Preferences panel, unless you absolutely need to embed PHP functionality in your site.
------------------------
Charset (default/config): utf8mb4/utf8mb4
character_set_client: utf8mb4
character_set_collations: utf8mb3=utf8mb3_uca1400_ai_ci,ucs2=ucs2_uca1400_ai_ci,utf8mb4=utf8mb4_uca1400_ai_ci,utf16=utf16_uca1400_ai_ci,utf32=utf32_uca1400_ai_ci
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/mariadb/charsets/
collation_connection: utf8mb4_uca1400_ai_ci
collation_database: utf8mb4_general_ci
collation_server: utf8mb4_uca1400_ai_ci
18 database tables: OKOffline
Re: MariaDB 11.8: can create article; cannot revise same article
Okay yeah the mix of utf8mb3 and 4 might have a bearing on this behaviour. I’m not well-versed enough in such matters to say for sure but I’ve seen things go wonky before due to the mismatch.
The smd plugin menagerie — for when you need one more gribble of power from Textpattern. Bleeding-edge code available on GitHub.
Hire Txp Builders – finely-crafted code, design and Txp
Offline
Re: MariaDB 11.8: can create article; cannot revise same article
Thanks, Bloke. I had a feeling it might be that – I’ll investigate and report back.
Offline
Re: MariaDB 11.8: can create article; cannot revise same article
And I’ve never heard of uca1400_ai_ci collation, nor how it differs from general_ci
The smd plugin menagerie — for when you need one more gribble of power from Textpattern. Bleeding-edge code available on GitHub.
Hire Txp Builders – finely-crafted code, design and Txp
Offline
Re: MariaDB 11.8: can create article; cannot revise same article
found this site with detailed description . Hopefully it contains a solution?
Last edited by bici (Yesterday 17:00:19)
…. texted postive
Offline
Re: MariaDB 11.8: can create article; cannot revise same article
Ahh, ai = accent insensitive. Thanks.
The smd plugin menagerie — for when you need one more gribble of power from Textpattern. Bleeding-edge code available on GitHub.
Hire Txp Builders – finely-crafted code, design and Txp
Offline
#12 Today 08:04:35
Re: MariaDB 11.8: can create article; cannot revise same article
Database encoding seems mostly OK, except for this one line:
character_set_collations: utf8mb3=utf8mb3_uca1400_ai_ci,ucs2=ucs2_uca1400_ai_ci,utf8mb4=utf8mb4_uca1400_ai_ci,utf16=utf16_uca1400_ai_ci,utf32=utf32_uca1400_ai_ciI would expect one type, e.g utf8mb4, not a whole confusing list
Where is that emoji for a solar powered submarine when you need it ?
Sand space – admin theme for Textpattern
phiw13 on Codeberg
Offline