Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Re: Latset 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: Latset version 4.9
I’ll make sure the next demo site server build includes MariaDB.
Offline
Re: Latset version 4.9
Congratulations on the release of 4.9.0.
Hope for the future.
Offline