jsoares / ttrss-plugin-feedstatistics Goto Github PK

Hello, yesterday I noticed that Statistics are empty. The system log items are:

Error: E_USER_ERROR (256)
Filename:classes/db/pgsql.php:46

Message:
Query SELECT ttrss_feeds.title as feed, ttrss_feed_categories.title as category, COUNT(ref_id) as items, COUNT(NULLIF(marked, false)) as starred, COUNT(NULLIF(published, false)) AS published, ROUND(CAST(COUNT(ref_id) AS DECIMAL)/0,2) as items_day FROM ttrss_feeds LEFT JOIN ttrss_user_entries ON ttrss_feeds.id = ttrss_user_entries.feed_id AND ttrss_user_entries.last_read > '2015-10-03' LEFT JOIN ttrss_entries ON ttrss_user_entries.ref_id = ttrss_entries.id LEFT JOIN ttrss_feed_categories ON ttrss_feeds.cat_id = ttrss_feed_categories.id WHERE ttrss_feeds.owner_uid = 2 GROUP BY feed, category ORDER BY items_day DESC failed: ERROR: division by zero

And second error:

Error: E_WARNING (2)
Filename:classes/db/pgsql.php:38

Message:
pg_query(): Query failed: ERROR: division by zero

Can you think of where there may be a problem please? Thank you.

Hello, thanks for plugin.
Today I did update after TTRSS PDO update ( https://discourse.tt-rss.org/t/pdo-is-coming-heres-what-you-need-to-know/689 ) (from TTRSS 17.4 to 17.12)

And when I refresh statistics, I get this error in Error log:

Legacy connect requested to pgsql1.
1. classes/db.php(22): user_error(Legacy connect requested to pgsql, 1024)
2. classes/db.php(89): legacy_connect()
3. include/db.php(8): get()
4. plugins/feedstatistics/init.php(27): db_query(SELECT value FROM ttrss_user_prefs
WHERE pref_name = 'PURGE_OLD_DAYS' AND owner_uid = 2 AND profile IS NULL)
5. classes/pluginhost.php(120): hook_prefs_tab(prefFeeds)
6. classes/pref/feeds.php(1350): run_hooks(3, hook_prefs_tab, prefFeeds)
7. backend.php(123): index()

Can you please look at this sometimes ? Thank you:)