News: News not syncing to external FeedReader anymore (since update to NCv20)

Created on 10 Oct 2020  ·  10Comments  ·  Source: nextcloud/news

IMPORTANT

Read and tick the following checkbox after you have created the issue or place an x inside the brackets ;)

Explain the Problem

After updating to NCv20, my external news app does not retrieve news anymore.

Steps to Reproduce

I am using news 15.0.3, everything works fine in the web app. Android app also working and a curl to the API v1-2 looks good, as well. But the app FeedReader only retrieves the list of feeds, no content. It shows one old article as unread and nothing else. As I did not change anything besides the upgrade of nextcloud / the news app, I was wondering if there is a bug somewhere, introducing these incompatibilities.

System Information

  • News app version: 15.0.3
  • Nextcloud version: 20.0.0
  • Cron type: crontab
  • php version: PHP 7.4.11 (cli) (built: Oct 1 2020 19:35:35) ( NTS )

Contents of nextcloud/data/nextcloud.log


{"reqId":"ezrn33qPECoIbInFUBuC","level":0,"time":"2020-10-10T07:39:13+00:00","remoteAddr":"***details removed****","user":"matthias","app":"news","method":"GET","url":"/imperator/index.php/apps/news/api/v1-2/version","message":"new parser added : FeedIo\\Standard\\Json","userAgent":"FeedReader 2.11.0","version":"20.0.0.9"}
{"reqId":"ezrn33qPECoIbInFUBuC","level":0,"time":"2020-10-10T07:39:13+00:00","remoteAddr":"***details removed****","user":"matthias","app":"news","method":"GET","url":"/imperator/index.php/apps/news/api/v1-2/version","message":"new parser added : FeedIo\\Standard\\Atom","userAgent":"FeedReader 2.11.0","version":"20.0.0.9"}
{"reqId":"ezrn33qPECoIbInFUBuC","level":0,"time":"2020-10-10T07:39:13+00:00","remoteAddr":"***details removed****","user":"matthias","app":"news","method":"GET","url":"/imperator/index.php/apps/news/api/v1-2/version","message":"new parser added : FeedIo\\Standard\\Rss","userAgent":"FeedReader 2.11.0","version":"20.0.0.9"}
{"reqId":"ezrn33qPECoIbInFUBuC","level":0,"time":"2020-10-10T07:39:13+00:00","remoteAddr":"***details removed****","user":"matthias","app":"news","method":"GET","url":"/imperator/index.php/apps/news/api/v1-2/version","message":"new parser added : FeedIo\\Standard\\Rdf","userAgent":"FeedReader 2.11.0","version":"20.0.0.9"}
{"reqId":"jC0LktABkRKskPAERqaY","level":0,"time":"2020-10-10T07:39:13+00:00","remoteAddr":"***details removed****","user":"--","app":"contacts","method":"GET","url":"/imperator/index.php/apps/news/api/v1-2/folders","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"FeedReader 2.11.0","version":"20.0.0.9"}
{"reqId":"jC0LktABkRKskPAERqaY","level":0,"time":"2020-10-10T07:39:13+00:00","remoteAddr":"***details removed****","user":"--","app":"groupfolders","method":"GET","url":"/imperator/index.php/apps/news/api/v1-2/folders","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"FeedReader 2.11.0","version":"20.0.0.9"}
{"reqId":"jC0LktABkRKskPAERqaY","level":0,"time":"2020-10-10T07:39:13+00:00","remoteAddr":"***details removed****","user":"--","app":"files_external","method":"GET","url":"/imperator/index.php/apps/news/api/v1-2/folders","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"FeedReader 2.11.0","version":"20.0.0.9"}
{"reqId":"jC0LktABkRKskPAERqaY","level":0,"time":"2020-10-10T07:39:13+00:00","remoteAddr":"***details removed****","user":"--","app":"files_sharing","method":"GET","url":"/imperator/index.php/apps/news/api/v1-2/folders","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"FeedReader 2.11.0","version":"20.0.0.9"}
{"reqId":"jC0LktABkRKskPAERqaY","level":0,"time":"2020-10-10T07:39:13+00:00","remoteAddr":"***details removed****","user":"--","app":"maps","method":"GET","url":"/imperator/index.php/apps/news/api/v1-2/folders","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"FeedReader 2.11.0","version":"20.0.0.9"}
{"reqId":"jC0LktABkRKskPAERqaY","level":0,"time":"2020-10-10T07:39:13+00:00","remoteAddr":"***details removed****","user":"matthias","app":"polls","method":"GET","url":"/imperator/index.php/apps/news/api/v1-2/folders","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"FeedReader 2.11.0","version":"20.0.0.9"}
{"reqId":"jC0LktABkRKskPAERqaY","level":0,"time":"2020-10-10T07:39:13+00:00","remoteAddr":"***details removed****","user":"matthias","app":"twofactor_totp","method":"GET","url":"/imperator/index.php/apps/news/api/v1-2/folders","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"FeedReader 2.11.0","version":"20.0.0.9"}
{"reqId":"GxO6I1x5nsK4CNRDyHdi","level":0,"time":"2020-10-10T07:39:13+00:00","remoteAddr":"***details removed****","user":"--","app":"contacts","method":"GET","url":"/imperator/index.php/apps/news/api/v1-2/items/updated?lastModified=1586322178&type=3&id=0","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"FeedReader 2.11.0","version":"20.0.0.9"}
{"reqId":"GxO6I1x5nsK4CNRDyHdi","level":0,"time":"2020-10-10T07:39:13+00:00","remoteAddr":"***details removed****","user":"--","app":"groupfolders","method":"GET","url":"/imperator/index.php/apps/news/api/v1-2/items/updated?lastModified=1586322178&type=3&id=0","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"FeedReader 2.11.0","version":"20.0.0.9"}
{"reqId":"GxO6I1x5nsK4CNRDyHdi","level":0,"time":"2020-10-10T07:39:13+00:00","remoteAddr":"***details removed****","user":"--","app":"files_external","method":"GET","url":"/imperator/index.php/apps/news/api/v1-2/items/updated?lastModified=1586322178&type=3&id=0","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"FeedReader 2.11.0","version":"20.0.0.9"}
{"reqId":"GxO6I1x5nsK4CNRDyHdi","level":0,"time":"2020-10-10T07:39:13+00:00","remoteAddr":"***details removed****","user":"--","app":"files_sharing","method":"GET","url":"/imperator/index.php/apps/news/api/v1-2/items/updated?lastModified=1586322178&type=3&id=0","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"FeedReader 2.11.0","version":"20.0.0.9"}
{"reqId":"GxO6I1x5nsK4CNRDyHdi","level":0,"time":"2020-10-10T07:39:13+00:00","remoteAddr":"***details removed****","user":"--","app":"maps","method":"GET","url":"/imperator/index.php/apps/news/api/v1-2/items/updated?lastModified=1586322178&type=3&id=0","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"FeedReader 2.11.0","version":"20.0.0.9"}
{"reqId":"GxO6I1x5nsK4CNRDyHdi","level":0,"time":"2020-10-10T07:39:13+00:00","remoteAddr":"***details removed****","user":"matthias","app":"polls","method":"GET","url":"/imperator/index.php/apps/news/api/v1-2/items/updated?lastModified=1586322178&type=3&id=0","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"FeedReader 2.11.0","version":"20.0.0.9"}
{"reqId":"GxO6I1x5nsK4CNRDyHdi","level":0,"time":"2020-10-10T07:39:13+00:00","remoteAddr":"***details removed****","user":"matthias","app":"twofactor_totp","method":"GET","url":"/imperator/index.php/apps/news/api/v1-2/items/updated?lastModified=1586322178&type=3&id=0","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"FeedReader 2.11.0","version":"20.0.0.9"}

I also found this in the logs related to the news app:


{"reqId":"t3OYxpZZU59CcTjo2yIj","level":1,"time":"2020-10-10T07:20:06+00:00","remoteAddr":"","user":"--","app":"news","method":"","url":"/imperator/cron.php","message":"unsupported date format, use strtotime() to build the DateTime instance : 23 Sep 2020 16:00:00 GMT","userAgent":"--","version":"20.0.0.9"}
{"reqId":"t3OYxpZZU59CcTjo2yIj","level":1,"time":"2020-10-10T07:20:06+00:00","remoteAddr":"","user":"--","app":"news","method":"","url":"/imperator/cron.php","message":"correct last modified date for feed ***details removed****","userAgent":"--","version":"20.0.0.9"}
{"reqId":"t3OYxpZZU59CcTjo2yIj","level":1,"time":"2020-10-10T07:20:06+00:00","remoteAddr":"","user":"--","app":"news","method":"","url":"/imperator/cron.php","message":"set last modified date to modifiedSince arg for feed ***details removed****","userAgent":"--","version":"20.0.0.9"}
{"reqId":"t3OYxpZZU59CcTjo2yIj","level":1,"time":"2020-10-10T07:20:06+00:00","remoteAddr":"","user":"--","app":"news","method":"","url":"/imperator/cron.php","message":"correct public id for node ***details removed****","userAgent":"--","version":"20.0.0.9"}
{"reqId":"t3OYxpZZU59CcTjo2yIj","level":0,"time":"2020-10-10T07:20:06+00:00","remoteAddr":"","user":"--","app":"news","method":"","url":"/imperator/cron.php","message":"Feed ***details removed**** was modified since last fetch. #0 items","userAgent":"--","version":"20.0.0.9"}
{"reqId":"t3OYxpZZU59CcTjo2yIj","level":0,"time":"2020-10-10T07:20:06+00:00","remoteAddr":"","user":"--","app":"news","method":"","url":"/imperator/cron.php","message":"read access : ***details removed**** into a feed instance (feed class : FeedIo\\Feed)","userAgent":"--","version":"20.0.0.9"}
{"reqId":"t3OYxpZZU59CcTjo2yIj","level":0,"time":"2020-10-10T07:20:06+00:00","remoteAddr":"","user":"--","app":"news","method":"","url":"/imperator/cron.php","message":"start reading ***details removed****","userAgent":"--","version":"20.0.0.9"}
{"reqId":"t3OYxpZZU59CcTjo2yIj","level":1,"time":"2020-10-10T07:20:06+00:00","remoteAddr":"","user":"--","app":"news","method":"","url":"/imperator/cron.php","message":"hitting h***details removed****","userAgent":"--","version":"20.0.0.9"}
{"reqId":"t3OYxpZZU59CcTjo2yIj","level":0,"time":"2020-10-10T07:20:07+00:00","remoteAddr":"","user":"--","app":"news","method":"","url":"/imperator/cron.php","message":"response ok, now turning it into a document","userAgent":"--","version":"20.0.0.9"}
{"reqId":"t3OYxpZZU59CcTjo2yIj","level":1,"time":"2020-10-10T07:20:07+00:00","remoteAddr":"","user":"--","app":"news","method":"","url":"/imperator/cron.php","message":"the stream is modified, parsing it","userAgent":"--","version":"20.0.0.9"}
{"reqId":"t3OYxpZZU59CcTjo2yIj","level":0,"time":"2020-10-10T07:20:07+00:00","remoteAddr":"","user":"--","app":"news","method":"","url":"/imperator/cron.php","message":"accurate parser : FeedIo\\Parser\\XmlParser","userAgent":"--","version":"20.0.0.9"}
{"reqId":"t3OYxpZZU59CcTjo2yIj","level":1,"time":"2020-10-10T07:20:07+00:00","remoteAddr":"","user":"--","app":"news","method":"","url":"/imperator/cron.php","message":"correct public id for node ***details removed****","userAgent":"--","version":"20.0.0.9"}
{"reqId":"t3OYxpZZU59CcTjo2yIj","level":0,"time":"2020-10-10T07:20:07+00:00","remoteAddr":"","user":"--","app":"news","method":"","url":"/imperator/cron.php","message":"Feed ***details removed**** was modified since last fetch. #1 items","userAgent":"--","version":"20.0.0.9"}
{"reqId":"t3OYxpZZU59CcTjo2yIj","level":0,"time":"2020-10-10T07:20:07+00:00","remoteAddr":"","user":"--","app":"news","method":"","url":"/imperator/cron.php","message":"Added item ***details removed**** for ***details removed**** publishdate: 1601500200","userAgent":"--","version":"20.0.0.9"}
{"reqId":"t3OYxpZZU59CcTjo2yIj","level":3,"time":"2020-10-10T07:20:07+00:00","remoteAddr":"","user":"--","app":"core","method":"","url":"/imperator/cron.php","message":{"Exception":"Doctrine\\DBAL\\Exception\\DriverException","Message":"An exception occurred while executing 'UPDATE `oc_news_items` SET `unread` = ?, `url` = ?, `guid` = ?, `guid_hash` = ?, `pub_date` = ?, `last_modified` = ?, `title` = ?, `body` = ?, `enclosure_mime` = ?, `enclosure_link` = ?, `search_index` = ?, `fingerprint` = ?, `content_hash` = ?, `feed_id` = ? WHERE `id` = ?' with params [false, \"***details removed****\", \"***details removed****\", \"8ebb740b7728929fad4b03c1072d95c9\", 1601500200, \"1602314407049987\", \"***details removed****\", \"***details removed****\", \"ccd66a93b5cf9e6664f41677a5a53ad3\", \"e6b9274750dab29254227a651fbf4130\", \"17\", \"3301\"]:\n\nSQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: '' for column `nextcloud`.`oc_news_items`.`unread` at row 1","Code":0,"Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php","line":169,"function":"convertException","class":"Doctrine\\DBAL\\Driver\\AbstractMySQLDriver","type":"->","args":["An exception occurred while executing 'UPDATE `oc_news_items` SET `unread` = ?, `url` = ?, `guid` = ?, `guid_hash` = ?, `pub_date` = ?, `last_modified` = ?, `title` = ?, `body` = ?, `enclosure_mime` = ?, `enclosure_link` = ?, `search_index` = ?, `fingerprint` = ?, `content_hash` = ?, `feed_id` = ? WHERE `id` = ?' with params [false, \"***details removed****\", \"***details removed****\", \"8ebb740b7728929fad4b03c1072d95c9\", 1601500200, \"1602314407049987\", \"***details removed****\", \"***details removed****\", \"ccd66a93b5cf9e6664f41677a5a53ad3\", \"e6b9274750dab29254227a651fbf4130\", \"17\", \"3301\"]:\n\nSQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: '' for column `nextcloud`.`oc_news_items`.`unread` at row 1",{"errorInfo":["22007",1366,"Incorrect integer value: '' for column `nextcloud`.`oc_news_items`.`unread` at row 1"],"__class__":"Doctrine\\DBAL\\Driver\\PDOException"}]},{"file":"/var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php","line":149,"function":"wrapException","class":"Doctrine\\DBAL\\DBALException","type":"::","args":[{"__class__":"Doctrine\\DBAL\\Driver\\PDOMySql\\Driver"},{"errorInfo":["22007",1366,"Incorrect integer value: '' for column `nextcloud`.`oc_news_items`.`unread` at row 1"],"__class__":"Doctrine\\DBAL\\Driver\\PDOException"},"An exception occurred while executing 'UPDATE `oc_news_items` SET `unread` = ?, `url` = ?, `guid` = ?, `guid_hash` = ?, `pub_date` = ?, `last_modified` = ?, `title` = ?, `body` = ?, `enclosure_mime` = ?, `enclosure_link` = ?, `search_index` = ?, `fingerprint` = ?, `content_hash` = ?, `feed_id` = ? WHERE `id` = ?' with params [false, \"***details removed****\", \"***details removed****\", \"8ebb740b7728929fad4b03c1072d95c9\", 1601500200, \"1602314407049987\", \"***details removed****\", \"***details removed****\", \"***details removed****\", \"***details removed****\", \"ccd66a93b5cf9e6664f41677a5a53ad3\", \"e6b9274750dab29254227a651fbf4130\", \"17\", \"3301\"]:\n\nSQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: '' for column `nextcloud`.`oc_news_items`.`unread` at row 1"]},{"file":"/var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php","line":1071,"function":"driverExceptionDuringQuery","class":"Doctrine\\DBAL\\DBALException","type":"::","args":[{"__class__":"Doctrine\\DBAL\\Driver\\PDOMySql\\Driver"},{"errorInfo":["22007",1366,"Incorrect integer value: '' for column `nextcloud`.`oc_news_items`.`unread` at row 1"],"__class__":"Doctrine\\DBAL\\Driver\\PDOException"},"UPDATE `oc_news_items` SET `unread` = ?, `url` = ?, `guid` = ?, `guid_hash` = ?, `pub_date` = ?, `last_modified` = ?, `title` = ?, `body` = ?, `enclosure_mime` = ?, `enclosure_link` = ?, `search_index` = ?, `fingerprint` = ?, `content_hash` = ?, `feed_id` = ? WHERE `id` = ?",{"1":false,"2":"***details removed****","3":"***details removed****","4":"8ebb740b7728929fad4b03c1072d95c9","5":1601500200,"6":"1602314407049987","7":"***details removed****","8":"***details removed****","9":"video/mp4","10":"***details removed****","11":"***details removed****","12":"ccd66a93b5cf9e6664f41677a5a53ad3","13":"e6b9274750dab29254227a651fbf4130","14":"17","15":"3301"}]},{"file":"/var/www/html/lib/private/DB/Connection.php","line":214,"function":"executeUpdate","class":"Doctrine\\DBAL\\Connection","type":"->","args":["UPDATE `oc_news_items` SET `unread` = ?, `url` = ?, `guid` = ?, `guid_hash` = ?, `pub_date` = ?, `last_modified` = ?, `title` = ?, `body` = ?, `enclosure_mime` = ?, `enclosure_link` = ?, `search_index` = ?, `fingerprint` = ?, `content_hash` = ?, `feed_id` = ? WHERE `id` = ?",[false,"***details removed****","***details removed****","8ebb740b7728929fad4b03c1072d95c9",1601500200,"1602314407049987","***details removed****","***details removed****","video/mp4","***details removed****","***details removed****","ccd66a93b5cf9e6664f41677a5a53ad3","e6b9274750dab29254227a651fbf4130","17","3301"],[2,2,2,2,2,2,2,2,2,2,2,2,2,2,1]]},{"file":"/var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php","line":209,"function":"executeUpdate","class":"OC\\DB\\Connection","type":"->","args":["UPDATE `oc_news_items` SET `unread` = :dcValue1, `url` = :dcValue2, `guid` = :dcValue3, `guid_hash` = :dcValue4, `pub_date` = :dcValue5, `last_modified` = :dcValue6, `title` = :dcValue7, `body` = :dcValue8, `enclosure_mime` = :dcValue9, `enclosure_link` = :dcValue10, `search_index` = :dcValue11, `fingerprint` = :dcValue12, `content_hash` = :dcValue13, `feed_id` = :dcValue14 WHERE `id` = :dcValue15",{"dcValue1":false,"dcValue2":"***details removed****","dcValue3":"***details removed****","dcValue4":"8ebb740b7728929fad4b03c1072d95c9","dcValue5":1601500200,"dcValue6":"1602314407049987","dcValue7":"***details removed****","dcValue8":"***details removed****","dcValue9":"video/mp4","dcValue10":"***details removed****","dcValue11":"***details removed****","dcValue12":"ccd66a93b5cf9e6664f41677a5a53ad3","dcValue13":"e6b9274750dab29254227a651fbf4130","dcValue14":"17","dcValue15":"3301"},{"dcValue1":2,"dcValue2":2,"dcValue3":2,"dcValue4":2,"dcValue5":2,"dcValue6":2,"dcValue7":2,"dcValue8":2,"dcValue9":2,"dcValue10":2,"dcValue11":2,"dcValue12":2,"dcValue13":2,"dcValue14":2,"dcValue15":1}]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":217,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/public/AppFramework/Db/QBMapper.php","line":200,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/custom_apps/news/lib/Db/NewsMapperV2.php","line":57,"function":"update","class":"OCP\\AppFramework\\Db\\QBMapper","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/custom_apps/news/lib/Service/ItemServiceV2.php","line":85,"function":"update","class":"OCA\\News\\Db\\NewsMapperV2","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/custom_apps/news/lib/Service/FeedServiceV2.php","line":310,"function":"insertOrUpdate","class":"OCA\\News\\Service\\ItemServiceV2","type":"->","args":["*** sensitive parameter replaced ***"]},{"file":"/var/www/html/custom_apps/news/lib/Service/FeedServiceV2.php","line":338,"function":"fetch","class":"OCA\\News\\Service\\FeedServiceV2","type":"->","args":[{"items":[],"id":17,"__class__":"OCA\\News\\Db\\Feed"}]},{"file":"/var/www/html/custom_apps/news/lib/Service/UpdaterService.php","line":55,"function":"fetchAll","class":"OCA\\News\\Service\\FeedServiceV2","type":"->","args":[]},{"file":"/var/www/html/custom_apps/news/lib/Cron/UpdaterJob.php","line":68,"function":"update","class":"OCA\\News\\Service\\UpdaterService","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/BackgroundJob/Job.php","line":52,"function":"run","class":"OCA\\News\\Cron\\UpdaterJob","type":"->","args":[null]},{"file":"/var/www/html/lib/private/BackgroundJob/TimedJob.php","line":59,"function":"execute","class":"OC\\BackgroundJob\\Job","type":"->","args":[{"__class__":"OC\\BackgroundJob\\JobList"},{"__class__":"OC\\Log"}]},{"file":"/var/www/html/cron.php","line":126,"function":"execute","class":"OC\\BackgroundJob\\TimedJob","type":"->","args":[{"__class__":"OC\\BackgroundJob\\JobList"},{"__class__":"OC\\Log"}]}],"File":"/var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php","Line":106,"Previous":{"Exception":"Doctrine\\DBAL\\Driver\\PDOException","Message":"SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: '' for column `nextcloud`.`oc_news_items`.`unread` at row 1","Code":"22007","Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php","line":1062,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDOStatement","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/Connection.php","line":214,"function":"executeUpdate","class":"Doctrine\\DBAL\\Connection","type":"->","args":["UPDATE `oc_news_items` SET `unread` = ?, `url` = ?, `guid` = ?, `guid_hash` = ?, `pub_date` = ?, `last_modified` = ?, `title` = ?, `body` = ?, `enclosure_mime` = ?, `enclosure_link` = ?, `search_index` = ?, `fingerprint` = ?, `content_hash` = ?, `feed_id` = ? WHERE `id` = ?",[false,"h(...) ***repeating log stripped***...{"file":"/var/www/html/custom_apps/news/lib/Service/ItemServiceV2.php","line":85,"function":"update","class":"OCA\\News\\Db\\NewsMapperV2","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/custom_apps/news/lib/Service/FeedServiceV2.php","line":310,"function":"insertOrUpdate","class":"OCA\\News\\Service\\ItemServiceV2","type":"->","args":["*** sensitive parameter replaced ***"]},{"file":"/var/www/html/custom_apps/news/lib/Service/FeedServiceV2.php","line":338,"function":"fetch","class":"OCA\\News\\Service\\FeedServiceV2","type":"->","args":[{"items":[],"id":17,"__class__":"OCA\\News\\Db\\Feed"}]},{"file":"/var/www/html/custom_apps/news/lib/Service/UpdaterService.php","line":55,"function":"fetchAll","class":"OCA\\News\\Service\\FeedServiceV2","type":"->","args":[]},{"file":"/var/www/html/custom_apps/news/lib/Cron/UpdaterJob.php","line":68,"function":"update","class":"OCA\\News\\Service\\UpdaterService","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/BackgroundJob/Job.php","line":52,"function":"run","class":"OCA\\News\\Cron\\UpdaterJob","type":"->","args":[null]},{"file":"/var/www/html/lib/private/BackgroundJob/TimedJob.php","line":59,"function":"execute","class":"OC\\BackgroundJob\\Job","type":"->","args":[{"__class__":"OC\\BackgroundJob\\JobList"},{"__class__":"OC\\Log"}]},{"file":"/var/www/html/cron.php","line":126,"function":"execute","class":"OC\\BackgroundJob\\TimedJob","type":"->","args":[{"__class__":"OC\\BackgroundJob\\JobList"},{"__class__":"OC\\Log"}]}],"File":"/var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php","Line":127}},"CustomMessage":"Error while running background job (class: OCA\\News\\Cron\\UpdaterJob, arguments: )"},"userAgent":"--","version":"20.0.0.9"}

bug

All 10 comments

This should be resolved with 15.0.4

This should be resolved with 15.0.4

Hi and thank you for your feedback. Unfortunately still no updates in my FeedReader. Only the list of feeds is updated but no articles. Is there anything I can or need to do?

I see after updating to NC20 following error in FieryFeeds “ service unavailable (503) “

I have installed the news app in 15.0.4

Also I see so content on the news WebUI

@SMillerDev any news about the 15.0.5 update ?

It'll be there when one of the volunteers feels like releasing it.

Ok :)

Hi. I saw you closed this issue, but even in version 15.0.6 the problem is still there, I do not get any news with my external reader. Did I miss a solution?

We don't really provide support for software that uses our API. The issues that are logged in your report are resolved so I consider this solved. If you can work out a test case with the developer of the external reader we can look into it.

Thank you for the feedback. Of course you don't have to debug other people's software. It's just that it happened after an update of your app and without changes to their software, so I was wondering if this break was intentional or a bug. I guess I have to downgrade the news app then, or can you recommend an external feed reader for linux that works with the latest version?

Was this page helpful?
0 / 5 - 0 ratings