Textpattern CMS

#31 Yesterday 17:56:40

Bloke

Developer

From: Leeds, UK

Registered: 2006-01-29

Posts: 12,591

Website GitHub

Re: Latest version 4.9

etc wrote #343351:

Just in case, what SELECT UNIX_TIMESTAMP(FROM_UNIXTIME(1)) returns?

I get 1 out.

---

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

#32 Yesterday 21:51:30

etc

Developer

Registered: 2010-11-11

Posts: 5,713

Website GitHub

Re: Latest version 4.9

Anyone could send me credentials for a faulty txp site? Or, better, make a sandbox site, to debug safely.

---

bloatware

#33 Yesterday 22:45:58

Bloke

Developer

From: Leeds, UK

Registered: 2006-01-29

Posts: 12,591

Website GitHub

Re: Latest version 4.9

etc wrote #343354:

Anyone could send me credentials for a faulty txp site?

You have mail.

---

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

#34 Today 11:22:04

abu

Plugin Author

From: Switzerland

Registered: 2025-04-03

Posts: 20

GitHub GitLab Mastodon

Re: Latest version 4.9

I stumbled upon another issue relating to the COALESCE/FROM_UNIXTIME trickery. On updating an article, the code

$whenposted = "COALESCE(FROM_UNIXTIME(0), FROM_UNIXTIME(1)) + INTERVAL $uPosted SECOND";

throws an error.

ERROR 1292 (22007): Truncated incorrect unixtime value: ‘0.0’

#35 Today 15:08:32

jakob

Admin

From: Germany

Registered: 2005-01-20

Posts: 5,321

Website GitHub

Re: Latest version 4.9

Bloke wrote #343352:

I get 1 out.

I do too on the aforementioned server.

---

TXP Builders – finely-crafted code, design and txp