Latset version 4.9

Adams · 2025-12-28 15:49:58

Hi,
I downloaded the new version 4.9 2 days ago. but none of articles visible any more, looks the issue on <txp:article_custom id=“1” > <txp:body/> </txp:article_custom>

Any idea?
Thank you

Bloke · 2025-12-28 16:14:13

That’s very strange. It should still work fine.

Is it only the <txp:article_custom> tags with an id attribute that are affected? Or are your regular <txp:article> tags not displaying anything either?

What happens if you put your site into debugging mode and refresh the page? Do you get any warnings or errors that might give a clue?

Has your database collation changed? That can also sometimes prevent content showing up if there’s a mix of collations between server and database. Does your (high) Admin->Diagnostics panel reveal any further clues on collation or show any errors/warnings?

Adams · 2025-12-28 16:38:42

Thank you for the fast reply,
the code
<txp:article_custom id=“1” >
<txp:body/>
</txp:article_custom>

No longer works in computer, the full demo (full install works just fine) but connection to existing
database with the new version of textpattern not working on article_custom.
Yes very strange, not sure what is changed. I was working with dev version last 10 months, and worked just fine.

Thank you

Bloke · 2025-12-28 16:44:21

Hmmm. So does debugging mode show anything? Or Diagnostics?

Adams · 2025-12-28 16:53:15

Nope, no error, any text before and after <txp:article_custom id=“1” > shows correctly.
also I have updated the table with
update `textpattern` set `Expires`=null, `LastMod`=now(), `Posted`=now()
no lock.
I checked the table, I see nothing changed, compared to new installed version.

I will dig in deep till I find the issue, I’m working on this project for almost a year now (still I have tons of api to convert), I can’t stay with old dev version.

Thank you for trying to help

Adams · 2025-12-28 17:04:51

May be just php version 8.3.28 can cause issue for this function

Thanks

Adams · 2025-12-28 19:37:12

The new production 4.9
Looks the issue with MySql version,
MySQL server version: 10.4.32-MariaDB works just fine
MySQL server version: 11.8.3 (and up) -MariaDB doesn’t work

The old dev 4.9 9-10 months old works in MySQL server version: 11.8.3

At least that is my finding for now. I may be wrong.

Thanks

Last edited by Adams (2025-12-28 19:37:30)

Bloke · 2025-12-28 21:46:53

Thanks for diagnosing this. It’d be really useful to see any errors or warnings from this environment. There may be some optimisations we introduced, or things added that later MySQL versions don’t support for some reason.

When you have your site in debugging mode, please View Source and scroll down to the tag trace. Find the database calls that fail (i.e. the ones that return false or nothing when they should return something) and paste theme here please. That may help us narrow down why your MySQL version is choking. Thank you.

Edit: if you are able to find a dev version (e.g one of the betas) that works and are able to send the same query and its result over, that would be even more useful.

Last edited by Bloke (2025-12-28 21:48:54)

Adams · Yesterday 12:55:39

Thank you for your suggestion.
I do have the site in debugging mode, with all errors enabled, but the problem is I don’t see any error or any log at all.
I’m going to set up a new sandbox with a fresh installation of MySQL, Apache, and PHP and latest textpattern 4.9 to see if the same issue still exists.

Bloke · Yesterday 14:32:48

You don’t see a trace log in the html source? There should always be one of those lurking at the very bottom of the page when in debugging mode.

Adams · Yesterday 14:45:19

Hi, Here is what I did so far and what I found:
Start fresh sandbox , installed xampp 3.3 with PHP version: 8.2.12 and MySQL: 10.4.32-MariaDB.
Downloaded latest production textpattern 4.9 , configured and start the server and worked as expected, no issue. here is the Diagnostic info
===================================================
Textpattern version: 4.9.0 (40b707aa5803338eca7b82c68bf57511957e6a9823093576)
Last update: 2025-12-29 13:17:16
Site URL: localhost
Admin URL: localhost/textpattern
Document root: C:/000www (C:\000www)
$path_to_site: C:\000www
Textpattern path: C:\000www\textpattern
Article URL pattern: section_title
Production status: debug
PHP.ini: upload_tmp_dir: C:\xampp\tmp
Temporary directory path: C:\000www\textpattern\tmp
PHP version: 8.2.12
GD Graphics Library: Unavailable
Server time zone: UTC
Server local time: 2025-12-29 13:23:52
Daylight Saving Time enabled?: 0
Automatically adjust Daylight Saving Time setting?: 0
Time zone (GMT offset in seconds): UTC (+3600)
MySQL: 10.4.32-MariaDB (mariadb.org binary distribution)
Database server time: 2025-12-29 07:23:52
Database server time offset: 1 s
Database server time zone: SYSTEM
Database session time zone: SYSTEM
Locale: English_United States.1252
Site / Admin language: en / en
Web server: Apache/2.4.58 (Win64) OpenSSL/3.1.3 PHP/8.2.12
Apache version: Apache/2.4.58 (Win64) OpenSSL/3.1.3 PHP/8.2.12
PHP server API: apache2handler
PHP SSL version: OpenSSL 3.0.11 19 Sep 2023
RFC 2616 headers:
Server OS: Windows NT 10.0
Admin-side theme: hive 4.9.0

.htaccess file contents: ————————————

BEGIN Textpattern

#DirectoryIndex index.php index.html

<IfModule mod_rewrite.c> RewriteEngine On

#Options +FollowSymlinks #RewriteBase /relative/web/path/ RewriteCond %{REQUEST_FILENAME} -f [OR] RewriteCond %{REQUEST_FILENAME} -d RewriteRule ^(.+) – [PT,L] RewriteCond %{REQUEST_URI} !=/favicon.ico RewriteRule ^(.*) index.php RewriteCond %{HTTP:Authorization} !^$ RewriteRule .* – [E=REMOTE_USER:%{HTTP:Authorization}] </IfModule>

<IfModule mod_mime.c> AddType image/svg+xml svg svgz AddEncoding gzip svgz
</IfModule>

For .htaccess configuration settings and explanations, please refer to:
https://github.com/h5bp/server-configs-apache/blob/main/dist/.htaccess
https://httpd.apache.org/docs/

END Textpattern

===================================================

And then upgraded MySQL from 10.4.32 to MySQL: 11.8.5-MariaDB, configured and started the server with no issue.
When I went to localhost, no article shows at all just

My site
My site slogan
Home Articles Search

RSS / Atom
Published with Textpattern CMS

That is all, I navigated to (http://localhost/textpattern/index.php?event=diag) Diagnostic I got error:

Fatal error: Uncaught TypeError: Unsupported operand types: string – int in C:\000www\textpattern\include\txp_diag.php:505 Stack trace: #0 C:\000www\textpattern\include\txp_diag.php(85): doDiagnostics() #1 C:\000www\textpattern\index.php(220): include(‘C:\\000www\\textp…’) #2 {main} thrown in C:\000www\textpattern\include\txp_diag.php on line 505

I have changed FROM_UNIXTIME(0), NOW) to
FROM_UNIXTIME(UNIX_TIMESTAMP()), NOW)
the diagnostic worked, and here is the Diagnostic :
======================================
Textpattern version: 4.9.0 (8f64cd2b5ee3ca7d21c9d607fb3716fffeb6eb21de41d3ae)
Last update: 2025-12-29 13:17:16
Site URL: localhost
Admin URL: localhost/textpattern
Document root: C:/000www (C:\000www)
$path_to_site: C:\000www
Textpattern path: C:\000www\textpattern
Article URL pattern: section_title
Production status: debug
PHP.ini: upload_tmp_dir: C:\xampp\tmp
Temporary directory path: C:\000www\textpattern\tmp
PHP version: 8.2.12
GD Graphics Library: Unavailable
Server time zone: UTC
Server local time: 2025-12-29 14:24:08
Daylight Saving Time enabled?: 0
Automatically adjust Daylight Saving Time setting?: 0
Time zone (GMT offset in seconds): UTC (+3600)
MySQL: 11.8.5-MariaDB (MariaDB Server)
Database server time: 2025-12-29 08:24:08
Database server time offset: -1767018248 s
Database server time zone: SYSTEM
Database session time zone: SYSTEM
Locale: English_United States.1252
Site / Admin language: en / en
Web server: Apache/2.4.58 (Win64) OpenSSL/3.1.3 PHP/8.2.12
Apache version: Apache/2.4.58 (Win64) OpenSSL/3.1.3 PHP/8.2.12
PHP server API: apache2handler
PHP SSL version: OpenSSL 3.0.11 19 Sep 2023
RFC 2616 headers:
Server OS: Windows NT 10.0
Admin-side theme: hive 4.9.0

Pre-flight check:
————————————
Some Textpattern files have been modified: C:\000www\textpattern\include\txp_diag.php
————————————

.htaccess file contents: ————————————

BEGIN Textpattern

#DirectoryIndex index.php index.html

<IfModule mod_rewrite.c> RewriteEngine On

#Options +FollowSymlinks #RewriteBase /relative/web/path/ RewriteCond %{REQUEST_FILENAME} -f [OR] RewriteCond %{REQUEST_FILENAME} -d RewriteRule ^(.+) – [PT,L] RewriteCond %{REQUEST_URI} !=/favicon.ico RewriteRule ^(.*) index.php RewriteCond %{HTTP:Authorization} !^$ RewriteRule .* – [E=REMOTE_USER:%{HTTP:Authorization}] </IfModule>

<IfModule mod_mime.c> AddType image/svg+xml svg svgz AddEncoding gzip svgz
</IfModule>

For .htaccess configuration settings and explanations, please refer to:
https://github.com/h5bp/server-configs-apache/blob/main/dist/.htaccess
https://httpd.apache.org/docs/

END Textpattern
————————————
=====================================
The Conclusion:
With MySQL: 11.8.5-MariaDB and up no article shows on the landing page.
When login to admin page , there is no error, I see the article, when I click on it, shows correct, I can edit, change and save, on the Articles page (the list) there is a status (live) on the far right, I click on it and shows the page correctly (http://localhost/articles/welcome-to-textpattern).
also http://localhost/articles (shows nothing).

Hope I narrowed down the issue a little bit. possible something with ids , may be.

Adams · Yesterday 15:44:28

Hi, finally I found it the issue in sql statement where says
FROM_UNIXTIME(0)
this function no longer valid with MySQL: 11.8.5-MariaDB
so I replaced all FROM_UNIXTIME(0) with FROM_UNIXTIME(UNIX_TIMESTAMP())
and all articles shows now as expected on all pages.
I’m sure you guys make this backward compatible and some kind checking mysql version.
So far that was the main issue I found, may be more invisible issues out there.

Textpattern CMS

Textpattern CMS support forum

#1 2025-12-28 15:49:58

Latset version 4.9

#2 2025-12-28 16:14:13

Re: Latset version 4.9

#3 2025-12-28 16:38:42

Re: Latset version 4.9

#4 2025-12-28 16:44:21

Re: Latset version 4.9

#5 2025-12-28 16:53:15

Re: Latset version 4.9

#6 2025-12-28 17:04:51

Re: Latset version 4.9

#7 2025-12-28 19:37:12

Re: Latset version 4.9

#8 2025-12-28 21:46:53

Re: Latset version 4.9

#9 Yesterday 12:55:39

Re: Latset version 4.9

#10 Yesterday 14:32:48

Re: Latset version 4.9

#11 Yesterday 14:45:19

Re: Latset version 4.9

#12 Yesterday 15:44:28

Re: Latset version 4.9

Board footer