After update to FreshRSS 1.20.2, I can't access subscriptions anymore

[necrevistonnezr]

After updating to FreshRSS 1.20.2, I get a HTTP ERROR 500 when clicking on "Subscription Management" or similar links like

https://freshrss.domain.com/i/?c=subscription
https://freshrss.domain.com/i/?c=update&a=checkInstall

From the logs:

Dec 12 11:35:14 [Mon Dec 12 10:35:14.548525 2022] [php:warn] [pid 46] [client 172.18.0.1:38456] PHP Warning: foreach() argument must be of type array|object, bool given in /app/code/app/Models/CategoryDAO.php on line 429
Dec 12 11:35:14 [Mon Dec 12 10:35:14.578365 2022] [php:warn] [pid 46] [client 172.18.0.1:38456] PHP Warning: foreach() argument must be of type array|object, bool given in /app/code/app/Controllers/indexController.php on line 66
Dec 12 11:35:14 [Mon Dec 12 10:35:14.585091 2022] [php:warn] [pid 46] [client 172.18.0.1:38456] PHP Warning: Trying to access array offset on value of type bool in /app/code/app/layout/aside_feed.phtml on line 41
Dec 12 11:35:14 [Mon Dec 12 10:35:14.587493 2022] [php:warn] [pid 46] [client 172.18.0.1:38456] PHP Warning: Trying to access array offset on value of type bool in /app/code/app/layout/aside_feed.phtml on line 42
Dec 12 11:35:14 [Mon Dec 12 10:35:14.587900 2022] [php:warn] [pid 46] [client 172.18.0.1:38456] PHP Warning: foreach() argument must be of type array|object, bool given in /app/code/app/layout/aside_feed.phtml on line 58
Dec 12 11:35:14 [Mon Dec 12 10:35:14.587969 2022] [php:warn] [pid 46] [client 172.18.0.1:38456] PHP Warning: foreach() argument must be of type array|object, bool given in /app/code/app/layout/aside_feed.phtml on line 75
Dec 12 11:35:14 [Mon Dec 12 10:35:14.588022 2022] [php:warn] [pid 46] [client 172.18.0.1:38456] PHP Warning: foreach() argument must be of type array|object, bool given in /app/code/app/layout/aside_feed.phtml on line 79
Dec 12 11:35:14 94.199.##.### - - [12/Dec/2022:10:35:14 +0000] "GET /i/ HTTP/1.1" 200 4068 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36"
Dec 12 11:35:15 [Mon Dec 12 10:35:15.581383 2022] [php:error] [pid 47] [client 172.18.0.1:38458] PHP Fatal error: Uncaught Error: Call to a member function fetchAll() on bool in /app/code/app/Models/CategoryDAO.php:308\nStack trace:\n#0 /app/code/app/Models/CategoryDAO.php(262): FreshRSS_CategoryDAO->listCategories()\n#1 /app/code/app/Controllers/subscriptionController.php(22): FreshRSS_CategoryDAO->listSortedCategories()\n#2 /app/code/lib/Minz/Dispatcher.php(43): FreshRSS_subscription_Controller->firstAction()\n#3 /app/code/lib/Minz/FrontController.php(58): Minz_Dispatcher->run()\n#4 /app/code/p/i/index.php(57): Minz_FrontController->run()\n#5 {main}\n thrown in /app/code/app/Models/CategoryDAO.php on line 308
Dec 12 11:35:15 94.199.##.### - - [12/Dec/2022:10:35:15 +0000] "GET /i/?c=subscription HTTP/1.1" 500 - "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36"
Dec 12 11:35:20 - - - [12/Dec/2022:10:35:20 +0000] "GET / HTTP/1.1" 302 - "-" "Mozilla (CloudronHealth)"

[girish]

@necrevistonnezr thanks for reporting. It seems 1.20.2 has hardly any changes, so most likely this is some issue with PHP 8.1 support.

[jdaviescoates]

Seems to still be working for me with Cloudron 7.3.4 and FreshRSS 1.20.2

[girish]

Did this get sorted out? This seems to be working for me atleast.

[necrevistonnezr]

@girish
I still have error when opening subscription management…

Dec 24 17:14:18 [Sat Dec 24 16:14:18.631919 2022] [php:error] [pid 53] [client 172.18.0.1:33208] PHP Fatal error: Uncaught Error: Call to a member function fetchAll() on bool in /app/code/app/Models/CategoryDAO.php:308\nStack trace:\n#0 /app/code/app/Models/CategoryDAO.php(262): FreshRSS_CategoryDAO->listCategories()\n#1 /app/code/app/Controllers/subscriptionController.php(22): FreshRSS_CategoryDAO->listSortedCategories()\n#2 /app/code/lib/Minz/Dispatcher.php(43): FreshRSS_subscription_Controller->firstAction()\n#3 /app/code/lib/Minz/FrontController.php(58): Minz_Dispatcher->run()\n#4 /app/code/p/i/index.php(57): Minz_FrontController->run()\n#5 {main}\n thrown in /app/code/app/Models/CategoryDAO.php on line 308
Dec 24 17:14:18 82.143.59.117 - - [24/Dec/2022:16:14:18 +0000] "GET /i/?c=subscription HTTP/1.1" 500 - "-" "Mozilla/5.0 (iPad; CPU OS 16_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.1 Mobile/15E148 Safari/604.1"