PHP 8.1: issue with boolean values (unread, starred)

[flozz]

Hello,

I have an issue when running Selfoss with PHP 8.1: all articles are displayed as read (but are not) and the counter on the left menu has the right count of unread articles. This issue is reproductible only with PHP 8.1, everything works as intended with PHP 8.0.

---

Here is the item in the database:

Here is what the browser receive with PHP 8.1:

And here is what the browser receive when running Selfoss with PHP 8.0:

---

I found the following breaking change in the PHP doc that may explain the issue:

PDO::ATTR_STRINGIFY_FETCHES now stringifies values of type bool to "0" or "1". Previously bools were not stringified.

→ https://www.php.net/manual/en/migration81.incompatible.php

I cannot dig more myself but I hope this will help :)

[jtojnar]

Could you please clarify which database backend this is?

[flozz]

I tried with both sqlite and mysql

EDIT: I had this error with sqlite (I just remembered I had an other issue with mysql (10.5.15-MariaDB) so I get back to sqlite)

[jtojnar]

Actually, looks like it happens in both MySQL and SQLite, only PostgreSQL is not affected. Thanks for reporting, should be fixed now.

[flozz]

Yes, I confirm, it works perfectly now. Thank you very much! :D