Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Re: Latest version 4.9
Bloke wrote #342028:
Oleg: should we alter the txp_lang.lastmod column to be DATETIME instead of TIMESTAMP?
Would this be easily portable between different time zones? Needs some thinking.
Even though we don’t store lang strings with dates < UNIX Epoch, it means we could potentially alter
FROM_UNIXTIME(0)to something else throughout the code without worrying if it’ll produce a timestamp we can’t store.
This change in MariaDB is rather weird: FROM_UNIXTIME(0) now returns NULL, but FROM_UNIXTIME(1) gives the UNIX 0 timestamp as local date, like 1970-01-01 01:00:00. We could switch to FROM_UNIXTIME(1) awaiting a better solution, eventually adjusting by 1 second.
Offline
Re: Latest version 4.9
I’ll make sure the next demo site server build includes MariaDB.
Offline
Re: Latest version 4.9
Congratulations on the release of 4.9.0.
Hope for the future.
Offline
#19 Yesterday 18:58:14
- colin99
- Member
- Registered: 2005-11-15
- Posts: 82
Re: Latest version 4.9
Adams wrote #342025:
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.
OK — so my 4.91 update results in only 1 article displaying on my homepage…
and no <older> links shown…
AND
No new articles published are visible.
The SQL change you make above — where is that change made and how do you do it please?
I know my way around PhpMyAdmin…
On the World Wide Web since Day 1 – Editor/Creator – Coffeecrew.com -
Offline
Re: Latest version 4.9
Hi Colin,
Oleg has, I believe, already patched that in this changeset, which should already be in txp 4.9.1 (the changes are made to the code rather than in phpMyAdmin). If you’ve already updated, maybe your problems lies somewhere else? Would you be able to share your (anonymized) diagnostics?
TXP Builders – finely-crafted code, design and txp
Offline
Re: Latest version 4.9
Colin seems to use 10.6.25-MariaDB, which should not be concerned by this patch. And, afaik, nobody yet has confirmed that the patch is working (or otherwise).
Offline