News: Numeric value out of range: 1264 Out of range value for column 'pub_date'

[jas4711]

System Information

• News app version: 15.1.0
• Nextcloud version: 20.0.4
• PHP version: 7.3
• Database and version: MariaDB 10.3.27
• Distribution and version: Debian Buster

Contents of nextcloud/data/nextcloud.log

{"reqId":"oxwdXN8Wri77FobRBPKk","level":1,"time":"2020-12-21T13:25:54+00:00","remoteAddr":"","user":"--","app":"news","method":"","url":"/owncloud/cron.php","message":"the stream is modified, parsing it","userAgent":"--","version":"20.0.4.0"}
{"reqId":"oxwdXN8Wri77FobRBPKk","level":1,"time":"2020-12-21T13:25:54+00:00","remoteAddr":"","user":"--","app":"news","method":"","url":"/owncloud/cron.php","message":"hitting https://feedpress.me/elezea","userAgent":"--","version":"20.0.4.0"}
{"reqId":"oxwdXN8Wri77FobRBPKk","level":1,"time":"2020-12-21T13:25:55+00:00","remoteAddr":"","user":"--","app":"news","method":"","url":"/owncloud/cron.php","message":"the stream is modified, parsing it","userAgent":"--","version":"20.0.4.0"}
{"reqId":"oxwdXN8Wri77FobRBPKk","level":1,"time":"2020-12-21T13:25:55+00:00","remoteAddr":"","user":"--","app":"news","method":"","url":"/owncloud/cron.php","message":"correct last modified date for feed Elezea","userAgent":"--","version":"20.0.4.0"}
{"reqId":"oxwdXN8Wri77FobRBPKk","level":1,"time":"2020-12-21T13:25:55+00:00","remoteAddr":"","user":"--","app":"news","method":"","url":"/owncloud/cron.php","message":"set last modified date to modifiedSince arg for feed Elezea","userAgent":"--","version":"20.0.4.0"}
{"reqId":"oxwdXN8Wri77FobRBPKk","level":1,"time":"2020-12-21T13:25:55+00:00","remoteAddr":"","user":"--","app":"news","method":"","url":"/owncloud/cron.php","message":"correct public id for node Elezea","userAgent":"--","version":"20.0.4.0"}
{"reqId":"oxwdXN8Wri77FobRBPKk","level":1,"time":"2020-12-21T13:25:55+00:00","remoteAddr":"","user":"--","app":"news","method":"","url":"/owncloud/cron.php","message":"hitting https://www.imperialviolet.org/iv-rss.xml","userAgent":"--","version":"20.0.4.0"}
{"reqId":"oxwdXN8Wri77FobRBPKk","level":1,"time":"2020-12-21T13:25:56+00:00","remoteAddr":"","user":"--","app":"news","method":"","url":"/owncloud/cron.php","message":"the stream is modified, parsing it","userAgent":"--","version":"20.0.4.0"}
{"reqId":"oxwdXN8Wri77FobRBPKk","level":1,"time":"2020-12-21T13:25:56+00:00","remoteAddr":"","user":"--","app":"news","method":"","url":"/owncloud/cron.php","message":"no 'modifiedSince' parameter given, setting it to 01/01/1970","userAgent":"--","version":"20.0.4.0"}
{"reqId":"oxwdXN8Wri77FobRBPKk","level":1,"time":"2020-12-21T13:25:56+00:00","remoteAddr":"","user":"--","app":"news","method":"","url":"/owncloud/cron.php","message":"hitting http://joyofsource.com/feed.xml","userAgent":"--","version":"20.0.4.0"}
{"reqId":"oxwdXN8Wri77FobRBPKk","level":1,"time":"2020-12-21T13:25:56+00:00","remoteAddr":"","user":"--","app":"news","method":"","url":"/owncloud/cron.php","message":"the stream is modified, parsing it","userAgent":"--","version":"20.0.4.0"}
{"reqId":"oxwdXN8Wri77FobRBPKk","level":1,"time":"2020-12-21T13:25:56+00:00","remoteAddr":"","user":"--","app":"news","method":"","url":"/owncloud/cron.php","message":"correct public id for node joyofsource.com","userAgent":"--","version":"20.0.4.0"}
{"reqId":"oxwdXN8Wri77FobRBPKk","level":1,"time":"2020-12-21T13:25:56+00:00","remoteAddr":"","user":"--","app":"news","method":"","url":"/owncloud/cron.php","message":"correct public id for node Guix Further Reduces Bootstrap Seed to 25%","userAgent":"--","version":"20.0.4.0"}
{"reqId":"oxwdXN8Wri77FobRBPKk","level":1,"time":"2020-12-21T13:25:56+00:00","remoteAddr":"","user":"--","app":"news","method":"","url":"/owncloud/cron.php","message":"correct public id for node Guix System on the Pinebook Pro","userAgent":"--","version":"20.0.4.0"}
{"reqId":"oxwdXN8Wri77FobRBPKk","level":1,"time":"2020-12-21T13:25:56+00:00","remoteAddr":"","user":"--","app":"news","method":"","url":"/owncloud/cron.php","message":"correct public id for node A Bare bones Guix System on the Pinebook Pro","userAgent":"--","version":"20.0.4.0"}
{"reqId":"oxwdXN8Wri77FobRBPKk","level":1,"time":"2020-12-21T13:25:56+00:00","remoteAddr":"","user":"--","app":"news","method":"","url":"/owncloud/cron.php","message":"correct public id for node GNU Mes 0.22 released","userAgent":"--","version":"20.0.4.0"}
{"reqId":"oxwdXN8Wri77FobRBPKk","level":1,"time":"2020-12-21T13:25:56+00:00","remoteAddr":"","user":"--","app":"news","method":"","url":"/owncloud/cron.php","message":"correct public id for node GNU Mes 0.21 released","userAgent":"--","version":"20.0.4.0"}
{"reqId":"oxwdXN8Wri77FobRBPKk","level":1,"time":"2020-12-21T13:25:56+00:00","remoteAddr":"","user":"--","app":"news","method":"","url":"/owncloud/cron.php","message":"correct public id for node Guix Reduces Bootstrap Seed by 50%","userAgent":"--","version":"20.0.4.0"}
{"reqId":"oxwdXN8Wri77FobRBPKk","level":1,"time":"2020-12-21T13:25:56+00:00","remoteAddr":"","user":"--","app":"news","method":"","url":"/owncloud/cron.php","message":"correct public id for node GNU Mes 0.20 released","userAgent":"--","version":"20.0.4.0"}
{"reqId":"oxwdXN8Wri77FobRBPKk","level":1,"time":"2020-12-21T13:25:56+00:00","remoteAddr":"","user":"--","app":"news","method":"","url":"/owncloud/cron.php","message":"correct public id for node GNU Mes 0.19 released","userAgent":"--","version":"20.0.4.0"}
{"reqId":"oxwdXN8Wri77FobRBPKk","level":1,"time":"2020-12-21T13:25:56+00:00","remoteAddr":"","user":"--","app":"news","method":"","url":"/owncloud/cron.php","message":"correct public id for node GNU Mes 0.18 released","userAgent":"--","version":"20.0.4.0"}
{"reqId":"oxwdXN8Wri77FobRBPKk","level":1,"time":"2020-12-21T13:25:56+00:00","remoteAddr":"","user":"--","app":"news","method":"","url":"/owncloud/cron.php","message":"correct public id for node Reduced Binary Seed Bootstrap","userAgent":"--","version":"20.0.4.0"}
{"reqId":"oxwdXN8Wri77FobRBPKk","level":1,"time":"2020-12-21T13:25:56+00:00","remoteAddr":"","user":"--","app":"news","method":"","url":"/owncloud/cron.php","message":"correct public id for node GNU Mes 0.17 released","userAgent":"--","version":"20.0.4.0"}
{"reqId":"oxwdXN8Wri77FobRBPKk","level":1,"time":"2020-12-21T13:25:56+00:00","remoteAddr":"","user":"--","app":"news","method":"","url":"/owncloud/cron.php","message":"correct public id for node on bootstrapping: 2nd status report on Mes","userAgent":"--","version":"20.0.4.0"}
{"reqId":"oxwdXN8Wri77FobRBPKk","level":1,"time":"2020-12-21T13:25:56+00:00","remoteAddr":"","user":"--","app":"news","method":"","url":"/owncloud/cron.php","message":"correct public id for node on bootstrapping: introducing Mes","userAgent":"--","version":"20.0.4.0"}
{"reqId":"oxwdXN8Wri77FobRBPKk","level":1,"time":"2020-12-21T13:25:56+00:00","remoteAddr":"","user":"--","app":"news","method":"","url":"/owncloud/cron.php","message":"correct public id for node Hello, world!","userAgent":"--","version":"20.0.4.0"}
{"reqId":"oxwdXN8Wri77FobRBPKk","level":3,"time":"2020-12-21T13:25:56+00:00","remoteAddr":"","user":"--","app":"core","method":"","url":"/owncloud/cron.php","message":{"Exception":"Doctrine\\DBAL\\Exception\\DriverException","Message":"An exception occurred while executing 'INSERT INTO `oc_news_items` (`unread`, `guid`, `guid_hash`, `pub_date`, `last_modified`, `title`, `author`, `body`, `search_index`, `fingerprint`, `content_hash`, `feed_id`) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [true, \"\\/hello-world.html\", \"a5a0d2daab2399a3a45a6beb0c7d86f1\", -3600, \"1608557156605574\", \"Hello, world!\", \"janneke\", \"<p>Finally, my website has been <a target=\\\"_blank\\\" rel=\\\"noreferrer\\\" href=\\\"http:\\/\\/haunt.dthompson.us\\\">Haunted<\\/a>!<\\/p><p><img src=\\\"images\\/haunt\\/logo.png\\\" alt=\\\"haunt logo\\\" \\/><\\/p><p>Connect with me on <a>#guix @freenode<\\/a>,\\n<a target=\\\"_blank\\\" rel=\\\"noreferrer\\\" href=\\\"https:\\/\\/octodon.social\\/@janneke\\\">mastodon<\\/a> or\\n<a target=\\\"_blank\\\" rel=\\\"noreferrer\\\" href=\\\"https:\\/\\/twitter.com\\/janneke_gnu\\\">twitter<\\/a>.<\\/p>\", \"finally, my website has been haunted!connect with me on #guix @freenode,\\nmastodon or\\ntwitter.jannekehello, world!\", \"a74a521c2171b8c166ebd7503af1fc92\", \"800a295d69a95180680e2066f395b117\", \"122\"]:\n\nSQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'pub_date' at row 1","Code":0,"Trace":[{"file":"/var/www/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php","line":169,"function":"convertException","class":"Doctrine\\DBAL\\Driver\\AbstractMySQLDriver","type":"->","args":["An exception occurred while executing 'INSERT INTO `oc_news_items` (`unread`, `guid`, `guid_hash`, `pub_date`, `last_modified`, `title`, `author`, `body`, `search_index`, `fingerprint`, `content_hash`, `feed_id`) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [true, \"\\/hello-world.html\", \"a5a0d2daab2399a3a45a6beb0c7d86f1\", -3600, \"1608557156605574\", \"Hello, world!\", \"janneke\", \"<p>Finally, my website has been <a target=\\\"_blank\\\" rel=\\\"noreferrer\\\" href=\\\"http:\\/\\/haunt.dthompson.us\\\">Haunted<\\/a>!<\\/p><p><img src=\\\"images\\/haunt\\/logo.png\\\" alt=\\\"haunt logo\\\" \\/><\\/p><p>Connect with me on <a>#guix @freenode<\\/a>,\\n<a target=\\\"_blank\\\" rel=\\\"noreferrer\\\" href=\\\"https:\\/\\/octodon.social\\/@janneke\\\">mastodon<\\/a> or\\n<a target=\\\"_blank\\\" rel=\\\"noreferrer\\\" href=\\\"https:\\/\\/twitter.com\\/janneke_gnu\\\">twitter<\\/a>.<\\/p>\", \"finally, my website has been haunted!connect with me on #guix @freenode,\\nmastodon or\\ntwitter.jannekehello, world!\", \"a74a521c2171b8c166ebd7503af1fc92\", \"800a295d69a95180680e2066f395b117\", \"122\"]:\n\nSQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'pub_date' at row 1",{"errorInfo":["22003",1264,"Out of range value for column 'pub_date' at row 1"],"__class__":"Doctrine\\DBAL\\Driver\\PDOException"}]},{"file":"/var/www/owncloud/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":["22003",1264,"Out of range value for column 'pub_date' at row 1"],"__class__":"Doctrine\\DBAL\\Driver\\PDOException"},"An exception occurred while executing 'INSERT INTO `oc_news_items` (`unread`, `guid`, `guid_hash`, `pub_date`, `last_modified`, `title`, `author`, `body`, `search_index`, `fingerprint`, `content_hash`, `feed_id`) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [true, \"\\/hello-world.html\", \"a5a0d2daab2399a3a45a6beb0c7d86f1\", -3600, \"1608557156605574\", \"Hello, world!\", \"janneke\", \"<p>Finally, my website has been <a target=\\\"_blank\\\" rel=\\\"noreferrer\\\" href=\\\"http:\\/\\/haunt.dthompson.us\\\">Haunted<\\/a>!<\\/p><p><img src=\\\"images\\/haunt\\/logo.png\\\" alt=\\\"haunt logo\\\" \\/><\\/p><p>Connect with me on <a>#guix @freenode<\\/a>,\\n<a target=\\\"_blank\\\" rel=\\\"noreferrer\\\" href=\\\"https:\\/\\/octodon.social\\/@janneke\\\">mastodon<\\/a> or\\n<a target=\\\"_blank\\\" rel=\\\"noreferrer\\\" href=\\\"https:\\/\\/twitter.com\\/janneke_gnu\\\">twitter<\\/a>.<\\/p>\", \"finally, my website has been haunted!connect with me on #guix @freenode,\\nmastodon or\\ntwitter.jannekehello, world!\", \"a74a521c2171b8c166ebd7503af1fc92\", \"800a295d69a95180680e2066f395b117\", \"122\"]:\n\nSQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'pub_date' at row 1"]},{"file":"/var/www/owncloud/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":["22003",1264,"Out of range value for column 'pub_date' at row 1"],"__class__":"Doctrine\\DBAL\\Driver\\PDOException"},"INSERT INTO `oc_news_items` (`unread`, `guid`, `guid_hash`, `pub_date`, `last_modified`, `title`, `author`, `body`, `search_index`, `fingerprint`, `content_hash`, `feed_id`) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",{"1":true,"2":"/hello-world.html","3":"a5a0d2daab2399a3a45a6beb0c7d86f1","4":-3600,"5":"1608557156605574","6":"Hello, world!","7":"janneke","8":"<p>Finally, my website has been <a target=\"_blank\" rel=\"noreferrer\" href=\"http://haunt.dthompson.us\">Haunted</a>!</p><p><img src=\"images/haunt/logo.png\" alt=\"haunt logo\" /></p><p>Connect with me on <a>#guix @freenode</a>,\n<a target=\"_blank\" rel=\"noreferrer\" href=\"https://octodon.social/@janneke\">mastodon</a> or\n<a target=\"_blank\" rel=\"noreferrer\" href=\"https://twitter.com/janneke_gnu\">twitter</a>.</p>","9":"finally, my website has been haunted!connect with me on #guix @freenode,\nmastodon or\ntwitter.jannekehello, world!","10":"a74a521c2171b8c166ebd7503af1fc92","11":"800a295d69a95180680e2066f395b117","12":"122"}]},{"file":"/var/www/owncloud/lib/private/DB/Connection.php","line":222,"function":"executeUpdate","class":"Doctrine\\DBAL\\Connection","type":"->","args":["INSERT INTO `oc_news_items` (`unread`, `guid`, `guid_hash`, `pub_date`, `last_modified`, `title`, `author`, `body`, `search_index`, `fingerprint`, `content_hash`, `feed_id`) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",[true,"/hello-world.html","a5a0d2daab2399a3a45a6beb0c7d86f1",-3600,"1608557156605574","Hello, world!","janneke","<p>Finally, my website has been <a target=\"_blank\" rel=\"noreferrer\" href=\"http://haunt.dthompson.us\">Haunted</a>!</p><p><img src=\"images/haunt/logo.png\" alt=\"haunt logo\" /></p><p>Connect with me on <a>#guix @freenode</a>,\n<a target=\"_blank\" rel=\"noreferrer\" href=\"https://octodon.social/@janneke\">mastodon</a> or\n<a target=\"_blank\" rel=\"noreferrer\" href=\"https://twitter.com/janneke_gnu\">twitter</a>.</p>","finally, my website has been haunted!connect with me on #guix @freenode,\nmastodon or\ntwitter.jannekehello, world!","a74a521c2171b8c166ebd7503af1fc92","800a295d69a95180680e2066f395b117","122"],[5,2,2,1,2,2,2,2,2,2,2,1]]},{"file":"/var/www/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php","line":209,"function":"executeUpdate","class":"OC\\DB\\Connection","type":"->","args":["INSERT INTO `oc_news_items` (`unread`, `guid`, `guid_hash`, `pub_date`, `last_modified`, `title`, `author`, `body`, `search_index`, `fingerprint`, `content_hash`, `feed_id`) VALUES(:dcValue1, :dcValue2, :dcValue3, :dcValue4, :dcValue5, :dcValue6, :dcValue7, :dcValue8, :dcValue9, :dcValue10, :dcValue11, :dcValue12)",{"dcValue1":true,"dcValue2":"/hello-world.html","dcValue3":"a5a0d2daab2399a3a45a6beb0c7d86f1","dcValue4":-3600,"dcValue5":"1608557156605574","dcValue6":"Hello, world!","dcValue7":"janneke","dcValue8":"<p>Finally, my website has been <a target=\"_blank\" rel=\"noreferrer\" href=\"http://haunt.dthompson.us\">Haunted</a>!</p><p><img src=\"images/haunt/logo.png\" alt=\"haunt logo\" /></p><p>Connect with me on <a>#guix @freenode</a>,\n<a target=\"_blank\" rel=\"noreferrer\" href=\"https://octodon.social/@janneke\">mastodon</a> or\n<a target=\"_blank\" rel=\"noreferrer\" href=\"https://twitter.com/janneke_gnu\">twitter</a>.</p>","dcValue9":"finally, my website has been haunted!connect with me on #guix @freenode,\nmastodon or\ntwitter.jannekehello, world!","dcValue10":"a74a521c2171b8c166ebd7503af1fc92","dcValue11":"800a295d69a95180680e2066f395b117","dcValue12":"122"},{"dcValue1":5,"dcValue2":2,"dcValue3":2,"dcValue4":1,"dcValue5":2,"dcValue6":2,"dcValue7":2,"dcValue8":2,"dcValue9":2,"dcValue10":2,"dcValue11":2,"dcValue12":1}]},{"file":"/var/www/owncloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":217,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/owncloud/lib/public/AppFramework/Db/QBMapper.php","line":135,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/owncloud/apps/news/lib/Db/NewsMapperV2.php","line":63,"function":"insert","class":"OCP\\AppFramework\\Db\\QBMapper","type":"->","args":[{"id":null,"__class__":"OCA\\News\\Db\\Item"}]},{"file":"/var/www/owncloud/apps/news/lib/Service/ItemServiceV2.php","line":92,"function":"insert","class":"OCA\\News\\Db\\NewsMapperV2","type":"->","args":[{"id":null,"__class__":"OCA\\News\\Db\\Item"}]},{"file":"/var/www/owncloud/apps/news/lib/Service/FeedServiceV2.php","line":311,"function":"insertOrUpdate","class":"OCA\\News\\Service\\ItemServiceV2","type":"->","args":[{"id":null,"__class__":"OCA\\News\\Db\\Item"}]},{"file":"/var/www/owncloud/apps/news/lib/Service/FeedServiceV2.php","line":339,"function":"fetch","class":"OCA\\News\\Service\\FeedServiceV2","type":"->","args":[{"items":[],"id":122,"__class__":"OCA\\News\\Db\\Feed"}]},{"file":"/var/www/owncloud/apps/news/lib/Service/UpdaterService.php","line":55,"function":"fetchAll","class":"OCA\\News\\Service\\FeedServiceV2","type":"->","args":[]},{"file":"/var/www/owncloud/apps/news/lib/Cron/UpdaterJob.php","line":68,"function":"update","class":"OCA\\News\\Service\\UpdaterService","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/owncloud/lib/private/BackgroundJob/Job.php","line":52,"function":"run","class":"OCA\\News\\Cron\\UpdaterJob","type":"->","args":[null]},{"file":"/var/www/owncloud/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/owncloud/cron.php","line":127,"function":"execute","class":"OC\\BackgroundJob\\TimedJob","type":"->","args":[{"__class__":"OC\\BackgroundJob\\JobList"},{"__class__":"OC\\Log"}]}],"File":"/var/www/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php","Line":106,"Previous":{"Exception":"Doctrine\\DBAL\\Driver\\PDOException","Message":"SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'pub_date' at row 1","Code":"22003","Trace":[{"file":"/var/www/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php","line":1062,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDOStatement","type":"->","args":[]},{"file":"/var/www/owncloud/lib/private/DB/Connection.php","line":222,"function":"executeUpdate","class":"Doctrine\\DBAL\\Connection","type":"->","args":["INSERT INTO `oc_news_items` (`unread`, `guid`, `guid_hash`, `pub_date`, `last_modified`, `title`, `author`, `body`, `search_index`, `fingerprint`, `content_hash`, `feed_id`) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",[true,"/hello-world.html","a5a0d2daab2399a3a45a6beb0c7d86f1",-3600,"1608557156605574","Hello, world!","janneke","<p>Finally, my website has been <a target=\"_blank\" rel=\"noreferrer\" href=\"http://haunt.dthompson.us\">Haunted</a>!</p><p><img src=\"images/haunt/logo.png\" alt=\"haunt logo\" /></p><p>Connect with me on <a>#guix @freenode</a>,\n<a target=\"_blank\" rel=\"noreferrer\" href=\"https://octodon.social/@janneke\">mastodon</a> or\n<a target=\"_blank\" rel=\"noreferrer\" href=\"https://twitter.com/janneke_gnu\">twitter</a>.</p>","finally, my website has been haunted!connect with me on #guix @freenode,\nmastodon or\ntwitter.jannekehello, world!","a74a521c2171b8c166ebd7503af1fc92","800a295d69a95180680e2066f395b117","122"],[5,2,2,1,2,2,2,2,2,2,2,1]]},{"file":"/var/www/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php","line":209,"function":"executeUpdate","class":"OC\\DB\\Connection","type":"->","args":["INSERT INTO `oc_news_items` (`unread`, `guid`, `guid_hash`, `pub_date`, `last_modified`, `title`, `author`, `body`, `search_index`, `fingerprint`, `content_hash`, `feed_id`) VALUES(:dcValue1, :dcValue2, :dcValue3, :dcValue4, :dcValue5, :dcValue6, :dcValue7, :dcValue8, :dcValue9, :dcValue10, :dcValue11, :dcValue12)",{"dcValue1":true,"dcValue2":"/hello-world.html","dcValue3":"a5a0d2daab2399a3a45a6beb0c7d86f1","dcValue4":-3600,"dcValue5":"1608557156605574","dcValue6":"Hello, world!","dcValue7":"janneke","dcValue8":"<p>Finally, my website has been <a target=\"_blank\" rel=\"noreferrer\" href=\"http://haunt.dthompson.us\">Haunted</a>!</p><p><img src=\"images/haunt/logo.png\" alt=\"haunt logo\" /></p><p>Connect with me on <a>#guix @freenode</a>,\n<a target=\"_blank\" rel=\"noreferrer\" href=\"https://octodon.social/@janneke\">mastodon</a> or\n<a target=\"_blank\" rel=\"noreferrer\" href=\"https://twitter.com/janneke_gnu\">twitter</a>.</p>","dcValue9":"finally, my website has been haunted!connect with me on #guix @freenode,\nmastodon or\ntwitter.jannekehello, world!","dcValue10":"a74a521c2171b8c166ebd7503af1fc92","dcValue11":"800a295d69a95180680e2066f395b117","dcValue12":"122"},{"dcValue1":5,"dcValue2":2,"dcValue3":2,"dcValue4":1,"dcValue5":2,"dcValue6":2,"dcValue7":2,"dcValue8":2,"dcValue9":2,"dcValue10":2,"dcValue11":2,"dcValue12":1}]},{"file":"/var/www/owncloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":217,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/owncloud/lib/public/AppFramework/Db/QBMapper.php","line":135,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/owncloud/apps/news/lib/Db/NewsMapperV2.php","line":63,"function":"insert","class":"OCP\\AppFramework\\Db\\QBMapper","type":"->","args":[{"id":null,"__class__":"OCA\\News\\Db\\Item"}]},{"file":"/var/www/owncloud/apps/news/lib/Service/ItemServiceV2.php","line":92,"function":"insert","class":"OCA\\News\\Db\\NewsMapperV2","type":"->","args":[{"id":null,"__class__":"OCA\\News\\Db\\Item"}]},{"file":"/var/www/owncloud/apps/news/lib/Service/FeedServiceV2.php","line":311,"function":"insertOrUpdate","class":"OCA\\News\\Service\\ItemServiceV2","type":"->","args":[{"id":null,"__class__":"OCA\\News\\Db\\Item"}]},{"file":"/var/www/owncloud/apps/news/lib/Service/FeedServiceV2.php","line":339,"function":"fetch","class":"OCA\\News\\Service\\FeedServiceV2","type":"->","args":[{"items":[],"id":122,"__class__":"OCA\\News\\Db\\Feed"}]},{"file":"/var/www/owncloud/apps/news/lib/Service/UpdaterService.php","line":55,"function":"fetchAll","class":"OCA\\News\\Service\\FeedServiceV2","type":"->","args":[]},{"file":"/var/www/owncloud/apps/news/lib/Cron/UpdaterJob.php","line":68,"function":"update","class":"OCA\\News\\Service\\UpdaterService","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/owncloud/lib/private/BackgroundJob/Job.php","line":52,"function":"run","class":"OCA\\News\\Cron\\UpdaterJob","type":"->","args":[null]},{"file":"/var/www/owncloud/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/owncloud/cron.php","line":127,"function":"execute","class":"OC\\BackgroundJob\\TimedJob","type":"->","args":[{"__class__":"OC\\BackgroundJob\\JobList"},{"__class__":"OC\\Log"}]}],"File":"/var/www/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php","Line":129,"Previous":{"Exception":"PDOException","Message":"SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'pub_date' at row 1","Code":"22003","Trace":[{"file":"/var/www/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php","line":127,"function":"execute","class":"PDOStatement","type":"->","args":[null]},{"file":"/var/www/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php","line":1062,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDOStatement","type":"->","args":[]},{"file":"/var/www/owncloud/lib/private/DB/Connection.php","line":222,"function":"executeUpdate","class":"Doctrine\\DBAL\\Connection","type":"->","args":["INSERT INTO `oc_news_items` (`unread`, `guid`, `guid_hash`, `pub_date`, `last_modified`, `title`, `author`, `body`, `search_index`, `fingerprint`, `content_hash`, `feed_id`) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",[true,"/hello-world.html","a5a0d2daab2399a3a45a6beb0c7d86f1",-3600,"1608557156605574","Hello, world!","janneke","<p>Finally, my website has been <a target=\"_blank\" rel=\"noreferrer\" href=\"http://haunt.dthompson.us\">Haunted</a>!</p><p><img src=\"images/haunt/logo.png\" alt=\"haunt logo\" /></p><p>Connect with me on <a>#guix @freenode</a>,\n<a target=\"_blank\" rel=\"noreferrer\" href=\"https://octodon.social/@janneke\">mastodon</a> or\n<a target=\"_blank\" rel=\"noreferrer\" href=\"https://twitter.com/janneke_gnu\">twitter</a>.</p>","finally, my website has been haunted!connect with me on #guix @freenode,\nmastodon or\ntwitter.jannekehello, world!","a74a521c2171b8c166ebd7503af1fc92","800a295d69a95180680e2066f395b117","122"],[5,2,2,1,2,2,2,2,2,2,2,1]]},{"file":"/var/www/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php","line":209,"function":"executeUpdate","class":"OC\\DB\\Connection","type":"->","args":["INSERT INTO `oc_news_items` (`unread`, `guid`, `guid_hash`, `pub_date`, `last_modified`, `title`, `author`, `body`, `search_index`, `fingerprint`, `content_hash`, `feed_id`) VALUES(:dcValue1, :dcValue2, :dcValue3, :dcValue4, :dcValue5, :dcValue6, :dcValue7, :dcValue8, :dcValue9, :dcValue10, :dcValue11, :dcValue12)",{"dcValue1":true,"dcValue2":"/hello-world.html","dcValue3":"a5a0d2daab2399a3a45a6beb0c7d86f1","dcValue4":-3600,"dcValue5":"1608557156605574","dcValue6":"Hello, world!","dcValue7":"janneke","dcValue8":"<p>Finally, my website has been <a target=\"_blank\" rel=\"noreferrer\" href=\"http://haunt.dthompson.us\">Haunted</a>!</p><p><img src=\"images/haunt/logo.png\" alt=\"haunt logo\" /></p><p>Connect with me on <a>#guix @freenode</a>,\n<a target=\"_blank\" rel=\"noreferrer\" href=\"https://octodon.social/@janneke\">mastodon</a> or\n<a target=\"_blank\" rel=\"noreferrer\" href=\"https://twitter.com/janneke_gnu\">twitter</a>.</p>","dcValue9":"finally, my website has been haunted!connect with me on #guix @freenode,\nmastodon or\ntwitter.jannekehello, world!","dcValue10":"a74a521c2171b8c166ebd7503af1fc92","dcValue11":"800a295d69a95180680e2066f395b117","dcValue12":"122"},{"dcValue1":5,"dcValue2":2,"dcValue3":2,"dcValue4":1,"dcValue5":2,"dcValue6":2,"dcValue7":2,"dcValue8":2,"dcValue9":2,"dcValue10":2,"dcValue11":2,"dcValue12":1}]},{"file":"/var/www/owncloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":217,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/owncloud/lib/public/AppFramework/Db/QBMapper.php","line":135,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/owncloud/apps/news/lib/Db/NewsMapperV2.php","line":63,"function":"insert","class":"OCP\\AppFramework\\Db\\QBMapper","type":"->","args":[{"id":null,"__class__":"OCA\\News\\Db\\Item"}]},{"file":"/var/www/owncloud/apps/news/lib/Service/ItemServiceV2.php","line":92,"function":"insert","class":"OCA\\News\\Db\\NewsMapperV2","type":"->","args":[{"id":null,"__class__":"OCA\\News\\Db\\Item"}]},{"file":"/var/www/owncloud/apps/news/lib/Service/FeedServiceV2.php","line":311,"function":"insertOrUpdate","class":"OCA\\News\\Service\\ItemServiceV2","type":"->","args":[{"id":null,"__class__":"OCA\\News\\Db\\Item"}]},{"file":"/var/www/owncloud/apps/news/lib/Service/FeedServiceV2.php","line":339,"function":"fetch","class":"OCA\\News\\Service\\FeedServiceV2","type":"->","args":[{"items":[],"id":122,"__class__":"OCA\\News\\Db\\Feed"}]},{"file":"/var/www/owncloud/apps/news/lib/Service/UpdaterService.php","line":55,"function":"fetchAll","class":"OCA\\News\\Service\\FeedServiceV2","type":"->","args":[]},{"file":"/var/www/owncloud/apps/news/lib/Cron/UpdaterJob.php","line":68,"function":"update","class":"OCA\\News\\Service\\UpdaterService","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/owncloud/lib/private/BackgroundJob/Job.php","line":52,"function":"run","class":"OCA\\News\\Cron\\UpdaterJob","type":"->","args":[null]},{"file":"/var/www/owncloud/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/owncloud/cron.php","line":127,"function":"execute","class":"OC\\BackgroundJob\\TimedJob","type":"->","args":[{"__class__":"OC\\BackgroundJob\\JobList"},{"__class__":"OC\\Log"}]}],"File":"/var/www/owncloud/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.4.0"}

[SMillerDev]

One of your blogs has an item that claims it pre-dates modern computing. You should ask the author to fix it instead

[theorangepotato]

I had this error with one of my feeds recently. For me, this error prevented any of the other feeds from updating during the normal cron update, but I could manually update them individually by toggling "enable full text". If others experience this issue as well, it would probably be worth failing more gracefully to not negatively affect the rest of the feeds. Can anyone else confirm or deny that they experience this behavior?

[jas4711]

I have had that problem (no updated feeds) for some time, but I am using the iOS CloudNews app and I suspected it may be related to it, or the connection with the server. Once in a while it kicks back and I see all unread articles again, but it didn't used to be like this and happened maybe a month or two ago. I haven't really confirmed whether the feeds are updated if I login on the web browser, will try to do that more carefully from now on to see if it is CloudNews issue or indeed related to this bug.

Is the order of which blogs to update predictable? Maybe it over time get all updates if the ordering is random. Alternatively, if the buggy blog site happens to be down during one update, it will complete, and I will see all updates.

[jas4711]

Also it seems a bit vulnerable that it is the database engine that catches this and throws an exception -- rather than the PHP code.

[scde]

Hi,

I also wanted to mention that there might be legitimate usages. For example the podcast/radio show "Desert Island Discs" has archives going back pre Unix time / 1.1.1970. E.g. this is the feed for the archive of 1960-69: https://podcasts.files.bbci.co.uk/p02p715y.rss

Also the dates used in that feed can be resolved by the date utility:

scde@scde-server:~$ date --date='@-311683800'
Mo 15. Feb 14:10:00 CET 1960

Not sure if this is standard conform or anything but it does work there.

First of all it would be nice if these kinds of feeds don't break the whole cron update and down the road maybe support these dates/feeds.

Best regards and thanks for your work.

[anoymouserver]

It is valid (→ Validator), even though it is not recommended to use dates before 1970, since it depends whether the used client supports it.
Theoretically the used library supports dates until 1800-01-01 (feed-io v4.7.12), but apparently the dabase uses an unsigned field for the dates.
Personally, I usually prefer ISO 8601 dates over Unix timestamps, but there was probably a reason why they are used here.
The fields are (already) bigint, but unfortunately unsigned, which did not allow dates before 1970 (as you can see in this initial issue).

The problem that a faulty feeds breaks the update of the following items is known and would need to be solved at some point.