TXP 4.9: Fatal error under diagnostic tab

Gallex · Yesterday 08:41:26

Fatal error: Uncaught TypeError: Unsupported operand types: string - int in 
/www/apache/domains/www.varaleidja.ee/htdocs/textpattern/include/txp_diag.php:505 Stack trace: #0 
/www/apache/domains/www.varaleidja.ee/htdocs/textpattern/include/txp_diag.php(85): doDiagnostics() #1 
/www/apache/domains/www.varaleidja.ee/htdocs/textpattern/index.php(220): include('/www/apache/dom...') #2 {main} thrown in 
/www/apache/domains/www.varaleidja.ee/htdocs/textpattern/include/txp_diag.php on line 505

Everything else on admin side is working correctly. Switched to the debug mode – no errors on the site, but almost all images are gone (they were gone on live status also)! on the admin side all images have the same date – 16 Jan 2026.

It’s a real estate website, over 10K images has already uploaded – could be this a reason?

Last edited by Gallex (Yesterday 08:54:38)

etc · Yesterday 09:19:42

If your db server is MariaDB 11.8+, it’s buggy and not officially supported by txp, though we are looking for a patch in 4.9.1.

jakob · Yesterday 09:27:32

Aside: you may be able to silence the deprecation notices about smd_lately by replacing all instances of the strftime function in the plugin code for smd_lately with safe_strftime.

Gallex · Yesterday 10:54:04

etc wrote #342247:

If your db server is MariaDB 11.8+, it’s buggy and not officially supported by txp, though we are looking for a patch in 4.9.1.

Yeah, it does 11.8.5… :( I have plenty of sites with this database.

But 4.8.8 is working with this database

etc · Yesterday 11:26:08

Gallex wrote #342250:

Yeah, it does 11.8.5… :( I have plenty of sites with this database.

But 4.8.8 is working with this database

The bug was not manifesting itself in 4.8.8, we have only discovered it after 4.9.0 release. Unfortunately, the only options I can see atm are

downgrade to txp 4.8.8
or to mariadb 11.4
or replace all 100 occurrences of FROM_UNIXTIME(0) in txp code (21 files) by FROM_UNIXTIME(1). This would shift dates by 1 second, but, hopefully, have no other weird effects.

Gallex · Yesterday 11:50:03

etc wrote #342251:

The bug was not manifesting itself in 4.8.8, we have only discovered it after 4.9.0 release. Unfortunately, the only options I can see atm are

downgrade to txp 4.8.8

or to mariadb 11.4

or replace all 100 occurrences of FROM_UNIXTIME(0) in txp code (21 files) by FROM_UNIXTIME(1). This would shift dates by 1 second, but, hopefully, have no other weird effects.

I will downgrade. Any idea, how fast you could fix it?

etc · Yesterday 18:02:56

Gallex wrote #342252:

I will downgrade. Any idea, how fast you could fix it?

Theoretically, it is already fixed in 4.9.1, but I have no appropriate server to test. As soon as someone confirms it works on mariadb 11.8, we can plan a release.

Adams · Yesterday 22:00:29

Hello,
As you suggested I replaced all FROM_UNIXTIME(0) with FROM_UNIXTIME(1) and looks working now with
Mariadb 11
BTW: all my work with Mysql Mariadb.
I can test 4.9.1
how I do get it ? from https://github.com/textpattern/textpattern ?

Hope this helps
Thank you

jakob · Yesterday 23:43:28

Adams wrote #342256:

I replaced all FROM_UNIXTIME(0) with FROM_UNIXTIME(1) and looks working now with
Mariadb 11

Great! I have a server with MariaDB 11.4 and haven’t observed problems. The anomaly does seem to be since v11.8.

how I do get it? from https://github.com/textpattern/textpattern ?

Yes. Visit github.com/textpattern/textpattern/tree/4.9.x (switch to the 4.9.x branch if not already set), then click the “Code” button and download the zip, or pull the repository using git.

Textpattern CMS

Textpattern CMS support forum

#1 Yesterday 08:41:26