Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#13 Today 13:24:22

jakob
Admin
From: Germany
Registered: 2005-01-20
Posts: 5,151
Website GitHub

Re: can't save any article

Is that this?

[MariaDB 11.8] UNIX_TIMESTAMP() now returns NULL instead of 0 (zero):


TXP Builders – finely-crafted code, design and txp

Offline

#14 Today 13:30:09

Bloke
Developer
From: Leeds, UK
Registered: 2006-01-29
Posts: 12,368
Website GitHub

Re: can't save any article

jakob wrote #342205:

Is this?

You beat me to it. I was gonna post the same link. Might be related. It’s the only timestampish issues I can find up there at the moment.


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

Offline

#15 Today 13:32:49

Bloke
Developer
From: Leeds, UK
Registered: 2006-01-29
Posts: 12,368
Website GitHub

Re: can't save any article

If it is that, and we get null back instead of an integer, can we detect it and swap the return value for a 0 so everything carries on working? I don’t think PHP allows us to cast null to int any more, but it might.


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

Offline

#16 Today 15:25:17

etc
Developer
Registered: 2010-11-11
Posts: 5,647
Website GitHub

Re: can't save any article

jakob wrote #342205:

Is that this?

Oh, thanks, have not seen it. So yes, this looks like a critical mariadb bug. I was actually thinking of that, but they are certainly related.

Bloke wrote #342207:

If it is that, and we get null back instead of an integer, can we detect it and swap the return value for a 0 so everything carries on working? I don’t think PHP allows us to cast null to int any more, but it might.

Nope, we’d need to do it at the db level, and it looks cumbersome. I would rather avoid this gymnastics.

Offline

Board footer

Powered by FluxBB