Package: tt-rss Version: 21~git20210204.b4cbc79+dfsg-1.2 Severity: normal Tags: patch
Dear Maintainer, After a dist-upgrade my server from Debien 11 to Debian 12, my Tiny Tiny RSS server diplays all new entries as already ridden. The unread counters are not impacted. To reproduce : - access to new unread entries in any categories (or in "Unread Articles"), unread entries are well displayed but the title text is greyed. - the unread filter is well applied and the unread counters count theses entries. - manually mark an entry as unread -> counter doens't change (this is correct) - manually mark an entry as read -> counter is correctly decreased (this is correct) After a search in the javascript, I see that the entry JSON attribut returned by the backend.php is always "unread: 0". In the class/feeds.php at line 258, I see a specific code that check the unread database value and retest it in case of mysql : if (DB_TYPE == "mysql") { foreach (["unread", "marked", "published"] as $k) { $line[$k] = $line[$k] === "1"; } } I suspect a change in the MariaDB upgrade that cause this problem. I propose the following simple modification : diff classes/feeds.php classes/feeds.php.old 258c258 < $line[$k] = $line[$k] === 1 || $line[$k] === "1"; --- > $line[$k] = $line[$k] === "1"; Regards -- System Information: Debian Release: 12.2 APT prefers stable-updates APT policy: (500, 'stable-updates'), (500, 'stable-security'), (500, 'stable') Architecture: amd64 (x86_64) Foreign Architectures: i386 Kernel: Linux 6.1.0-13-amd64 (SMP w/8 CPU threads; PREEMPT) Kernel taint flags: TAINT_OOT_MODULE, TAINT_UNSIGNED_MODULE Locale: LANG=fr_FR.UTF-8, LC_CTYPE=fr_FR.UTF-8 (charmap=UTF-8), LANGUAGE not set Shell: /bin/sh linked to /usr/bin/dash Init: systemd (via /run/systemd/system) LSM: AppArmor: enabled Versions of packages tt-rss depends on: ii dbconfig-common 2.0.24 ii dbconfig-pgsql 2.0.24 ii debconf [debconf-2.0] 1.5.82 ii fonts-material-design-icons-iconfont 6.7.0+dfsg-1 ii init-system-helpers 1.65.2 ii libapache2-mod-php 2:8.2+93 ii libapache2-mod-php8.2 [php-json] 8.2.7-1~deb12u1 ii libjs-dojo-core 1.17.2+dfsg1-2.1 ii libjs-dojo-dijit 1.17.2+dfsg1-2.1 ii libjs-scriptaculous 1.9.0-3 ii lsb-base 11.6 ii php 2:8.2+93 ii php-cli 2:8.2+93 ii php-intl 2:8.2+93 ii php-json 2:8.2+93 ii php-mbstring 2:8.2+93 ii php-mysql 2:8.2+93 ii php-php-gettext 1.0.12-5 ii php-psr-log 1.1.4-2 ii php-xml 2:8.2+93 ii php8.2 [php] 8.2.7-1~deb12u1 ii php8.2-cli [php-json] 8.2.7-1~deb12u1 ii php8.2-intl [php-intl] 8.2.7-1~deb12u1 ii php8.2-mbstring [php-mbstring] 8.2.7-1~deb12u1 ii php8.2-phpdbg [php-json] 8.2.7-1~deb12u1 ii php8.2-xml [php-xml] 8.2.7-1~deb12u1 ii phpqrcode 1.1.4-3.1 ii sysvinit-utils [lsb-base] 3.06-4 Versions of packages tt-rss recommends: ii apache2 [httpd] 2.4.57-2 ii ca-certificates 20230311 ii php-curl 2:8.2+93 ii php-gd 2:8.2+93 pn php-mcrypt <none> ii php8.2-curl [php-curl] 8.2.7-1~deb12u1 ii php8.2-gd [php-gd] 8.2.7-1~deb12u1 Versions of packages tt-rss suggests: pn php-apc <none> pn sphinxsearch <none> -- Configuration Files: /etc/tt-rss/config.php changed [not included] -- debconf information excluded -- debsums errors found: debsums: changed file /usr/share/tt-rss/www/classes/feeds.php (from tt-rss package) debsums: changed file /usr/share/tt-rss/www/include/errorhandler.php (from tt-rss package)