ERROR: column \"next_update_time\" of relation \"oc_news_feeds\" does not exist
#3060
Closed
3 tasks done
Labels
Comments
|
Duplicate of #3048 See there for options how to fix it, maybe report it to the AIO project as well since the apps do not control the migration execution they only declare what needs to be done. If you can also check the logs around the time you updated the app to check for possible errors. |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
IMPORTANT
Read and tick the following checkbox after you have created the issue or place an x inside the brackets ;)
Explain the Problem
What problem did you encounter?
Feeds do not update because cron job fails
System Information
Contents of nextcloud/data/nextcloud.log
{ "reqId": "H31rTJEDleKpn9tS9WG5", "level": 3, "time": "2025-01-21T21:52:40+00:00", "remoteAddr": "", "user": "--", "app": "core", "method": "", "url": "--", "message": "Error while running background job OCA\\News\\Cron\\UpdaterJob (id: 8624, arguments: null)", "userAgent": "--", "version": "30.0.4.1", "exception": { "Exception": "OC\\DB\\Exceptions\\DbalException", "Message": "An exception occurred while executing a query: SQLSTATE[42703]: Undefined column: 7 ERROR: column \"next_update_time\" of relation \"oc_news_feeds\" does not exist\nLINE 1: UPDATE \"oc_news_feeds\" SET \"next_update_time\" = $1, \"last_mo...\n ^", "Code": 7, "Trace": [ { "file": "/var/www/html/lib/private/DB/ConnectionAdapter.php", "line": 69, "function": "wrap", "class": "OC\\DB\\Exceptions\\DbalException", "type": "::", "args": [ { "__class__": "Doctrine\\DBAL\\Exception\\InvalidFieldNameException" } ] }, { "file": "/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php", "line": 306, "function": "executeStatement", "class": "OC\\DB\\ConnectionAdapter", "type": "->", "args": [ "UPDATE `*PREFIX*news_feeds` SET `next_update_time` = :dcValue1, `last_modified` = :dcValue2 WHERE `id` = :dcValue3", { "dcValue1": null, "dcValue2": "1737496360211075", "dcValue3": 30 }, { "dcValue1": 1, "dcValue2": 2, "dcValue3": 1 } ] }, { "file": "/var/www/html/lib/public/AppFramework/Db/QBMapper.php", "line": 197, "function": "executeStatement", "class": "OC\\DB\\QueryBuilder\\QueryBuilder", "type": "->", "args": [] }, { "file": "/var/www/html/custom_apps/news/lib/Db/NewsMapperV2.php", "line": 70, "function": "update", "class": "OCP\\AppFramework\\Db\\QBMapper", "type": "->", "args": [ "*** sensitive parameters replaced ***" ] }, { "file": "/var/www/html/custom_apps/news/lib/Service/FeedServiceV2.php", "line": 398, "function": "update", "class": "OCA\\News\\Db\\NewsMapperV2", "type": "->", "args": [ "*** sensitive parameters replaced ***" ] }, { "file": "/var/www/html/custom_apps/news/lib/Service/FeedServiceV2.php", "line": 422, "function": "fetch", "class": "OCA\\News\\Service\\FeedServiceV2", "type": "->", "args": [ "*** sensitive parameters replaced ***" ] }, { "file": "/var/www/html/custom_apps/news/lib/Service/UpdaterService.php", "line": 63, "function": "fetchAll", "class": "OCA\\News\\Service\\FeedServiceV2", "type": "->", "args": [] }, { "file": "/var/www/html/custom_apps/news/lib/Cron/UpdaterJob.php", "line": 58, "function": "update", "class": "OCA\\News\\Service\\UpdaterService", "type": "->", "args": [ "*** sensitive parameters replaced ***" ] }, { "file": "/var/www/html/lib/public/BackgroundJob/Job.php", "line": 61, "function": "run", "class": "OCA\\News\\Cron\\UpdaterJob", "type": "->", "args": [ null ] }, { "file": "/var/www/html/lib/public/BackgroundJob/TimedJob.php", "line": 88, "function": "start", "class": "OCP\\BackgroundJob\\Job", "type": "->", "args": [ { "__class__": "OC\\BackgroundJob\\JobList" } ] }, { "file": "/var/www/html/lib/public/BackgroundJob/TimedJob.php", "line": 75, "function": "start", "class": "OCP\\BackgroundJob\\TimedJob", "type": "->", "args": [ { "__class__": "OC\\BackgroundJob\\JobList" } ] }, { "file": "/var/www/html/cron.php", "line": 162, "function": "execute", "class": "OCP\\BackgroundJob\\TimedJob", "type": "->", "args": [ { "__class__": "OC\\BackgroundJob\\JobList" } ] } ], "File": "/var/www/html/lib/private/DB/Exceptions/DbalException.php", "Line": 54, "Previous": { "Exception": "Doctrine\\DBAL\\Exception\\InvalidFieldNameException", "Message": "An exception occurred while executing a query: SQLSTATE[42703]: Undefined column: 7 ERROR: column \"next_update_time\" of relation \"oc_news_feeds\" does not exist\nLINE 1: UPDATE \"oc_news_feeds\" SET \"next_update_time\" = $1, \"last_mo...\n ^", "Code": 7, "Trace": [ { "file": "/var/www/html/3rdparty/doctrine/dbal/src/Connection.php", "line": 1939, "function": "convert", "class": "Doctrine\\DBAL\\Driver\\API\\PostgreSQL\\ExceptionConverter", "type": "->", "args": [ { "__class__": "Doctrine\\DBAL\\Driver\\PDO\\Exception" }, { "__class__": "Doctrine\\DBAL\\Query" } ] }, { "file": "/var/www/html/3rdparty/doctrine/dbal/src/Connection.php", "line": 1881, "function": "handleDriverException", "class": "Doctrine\\DBAL\\Connection", "type": "->", "args": [ { "__class__": "Doctrine\\DBAL\\Driver\\PDO\\Exception" }, { "__class__": "Doctrine\\DBAL\\Query" } ] }, { "file": "/var/www/html/3rdparty/doctrine/dbal/src/Connection.php", "line": 1213, "function": "convertExceptionDuringQuery", "class": "Doctrine\\DBAL\\Connection", "type": "->", "args": [ { "__class__": "Doctrine\\DBAL\\Driver\\PDO\\Exception" }, "UPDATE \"oc_news_feeds\" SET \"next_update_time\" = ?, \"last_modified\" = ? WHERE \"id\" = ?", [ null, "1737496360211075", 30 ], [ 1, 2, 1 ] ] }, { "file": "/var/www/html/3rdparty/doctrine/dbal/src/Connections/PrimaryReadReplicaConnection.php", "line": 292, "function": "executeStatement", "class": "Doctrine\\DBAL\\Connection", "type": "->", "args": [ "UPDATE \"oc_news_feeds\" SET \"next_update_time\" = ?, \"last_modified\" = ? WHERE \"id\" = ?", [ null, "1737496360211075", 30 ], [ 1, 2, 1 ] ] }, { "file": "/var/www/html/lib/private/DB/Connection.php", "line": 462, "function": "executeStatement", "class": "Doctrine\\DBAL\\Connections\\PrimaryReadReplicaConnection", "type": "->", "args": [ "UPDATE \"oc_news_feeds\" SET \"next_update_time\" = :dcValue1, \"last_modified\" = :dcValue2 WHERE \"id\" = :dcValue3", { "dcValue1": null, "dcValue2": "1737496360211075", "dcValue3": 30 }, { "dcValue1": 1, "dcValue2": 2, "dcValue3": 1 } ] }, { "file": "/var/www/html/lib/private/DB/ConnectionAdapter.php", "line": 67, "function": "executeStatement", "class": "OC\\DB\\Connection", "type": "->", "args": [ "UPDATE \"oc_news_feeds\" SET \"next_update_time\" = :dcValue1, \"last_modified\" = :dcValue2 WHERE \"id\" = :dcValue3", { "dcValue1": null, "dcValue2": "1737496360211075", "dcValue3": 30 }, { "dcValue1": 1, "dcValue2": 2, "dcValue3": 1 } ] }, { "file": "/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php", "line": 306, "function": "executeStatement", "class": "OC\\DB\\ConnectionAdapter", "type": "->", "args": [ "UPDATE `*PREFIX*news_feeds` SET `next_update_time` = :dcValue1, `last_modified` = :dcValue2 WHERE `id` = :dcValue3", { "dcValue1": null, "dcValue2": "1737496360211075", "dcValue3": 30 }, { "dcValue1": 1, "dcValue2": 2, "dcValue3": 1 } ] }, { "file": "/var/www/html/lib/public/AppFramework/Db/QBMapper.php", "line": 197, "function": "executeStatement", "class": "OC\\DB\\QueryBuilder\\QueryBuilder", "type": "->", "args": [] }, { "file": "/var/www/html/custom_apps/news/lib/Db/NewsMapperV2.php", "line": 70, "function": "update", "class": "OCP\\AppFramework\\Db\\QBMapper", "type": "->", "args": [ "*** sensitive parameters replaced ***" ] }, { "file": "/var/www/html/custom_apps/news/lib/Service/FeedServiceV2.php", "line": 398, "function": "update", "class": "OCA\\News\\Db\\NewsMapperV2", "type": "->", "args": [ "*** sensitive parameters replaced ***" ] }, { "file": "/var/www/html/custom_apps/news/lib/Service/FeedServiceV2.php", "line": 422, "function": "fetch", "class": "OCA\\News\\Service\\FeedServiceV2", "type": "->", "args": [ "*** sensitive parameters replaced ***" ] }, { "file": "/var/www/html/custom_apps/news/lib/Service/UpdaterService.php", "line": 63, "function": "fetchAll", "class": "OCA\\News\\Service\\FeedServiceV2", "type": "->", "args": [] }, { "file": "/var/www/html/custom_apps/news/lib/Cron/UpdaterJob.php", "line": 58, "function": "update", "class": "OCA\\News\\Service\\UpdaterService", "type": "->", "args": [ "*** sensitive parameters replaced ***" ] }, { "file": "/var/www/html/lib/public/BackgroundJob/Job.php", "line": 61, "function": "run", "class": "OCA\\News\\Cron\\UpdaterJob", "type": "->", "args": [ null ] }, { "file": "/var/www/html/lib/public/BackgroundJob/TimedJob.php", "line": 88, "function": "start", "class": "OCP\\BackgroundJob\\Job", "type": "->", "args": [ { "__class__": "OC\\BackgroundJob\\JobList" } ] }, { "file": "/var/www/html/lib/public/BackgroundJob/TimedJob.php", "line": 75, "function": "start", "class": "OCP\\BackgroundJob\\TimedJob", "type": "->", "args": [ { "__class__": "OC\\BackgroundJob\\JobList" } ] }, { "file": "/var/www/html/cron.php", "line": 162, "function": "execute", "class": "OCP\\BackgroundJob\\TimedJob", "type": "->", "args": [ { "__class__": "OC\\BackgroundJob\\JobList" } ] } ], "File": "/var/www/html/3rdparty/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php", "Line": 68, "Previous": { "Exception": "Doctrine\\DBAL\\Driver\\PDO\\Exception", "Message": "SQLSTATE[42703]: Undefined column: 7 ERROR: column \"next_update_time\" of relation \"oc_news_feeds\" does not exist\nLINE 1: UPDATE \"oc_news_feeds\" SET \"next_update_time\" = $1, \"last_mo...\n ^", "Code": 7, "Trace": [ { "file": "/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php", "line": 132, "function": "new", "class": "Doctrine\\DBAL\\Driver\\PDO\\Exception", "type": "::", "args": [ { "__class__": "PDOException", "errorInfo": [ "42703", 7, "ERROR: column \"next_update_time\" of relation \"oc_news_feeds\" does not exist\nLINE 1: UPDATE \"oc_news_feeds\" SET \"next_update_time\" = $1, \"last_mo...\n ^" ] } ] }, { "file": "/var/www/html/3rdparty/doctrine/dbal/src/Connection.php", "line": 1207, "function": "execute", "class": "Doctrine\\DBAL\\Driver\\PDO\\Statement", "type": "->", "args": [] }, { "file": "/var/www/html/3rdparty/doctrine/dbal/src/Connections/PrimaryReadReplicaConnection.php", "line": 292, "function": "executeStatement", "class": "Doctrine\\DBAL\\Connection", "type": "->", "args": [ "UPDATE \"oc_news_feeds\" SET \"next_update_time\" = ?, \"last_modified\" = ? WHERE \"id\" = ?", [ null, "1737496360211075", 30 ], [ 1, 2, 1 ] ] }, { "file": "/var/www/html/lib/private/DB/Connection.php", "line": 462, "function": "executeStatement", "class": "Doctrine\\DBAL\\Connections\\PrimaryReadReplicaConnection", "type": "->", "args": [ "UPDATE \"oc_news_feeds\" SET \"next_update_time\" = :dcValue1, \"last_modified\" = :dcValue2 WHERE \"id\" = :dcValue3", { "dcValue1": null, "dcValue2": "1737496360211075", "dcValue3": 30 }, { "dcValue1": 1, "dcValue2": 2, "dcValue3": 1 } ] }, { "file": "/var/www/html/lib/private/DB/ConnectionAdapter.php", "line": 67, "function": "executeStatement", "class": "OC\\DB\\Connection", "type": "->", "args": [ "UPDATE \"oc_news_feeds\" SET \"next_update_time\" = :dcValue1, \"last_modified\" = :dcValue2 WHERE \"id\" = :dcValue3", { "dcValue1": null, "dcValue2": "1737496360211075", "dcValue3": 30 }, { "dcValue1": 1, "dcValue2": 2, "dcValue3": 1 } ] }, { "file": "/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php", "line": 306, "function": "executeStatement", "class": "OC\\DB\\ConnectionAdapter", "type": "->", "args": [ "UPDATE `*PREFIX*news_feeds` SET `next_update_time` = :dcValue1, `last_modified` = :dcValue2 WHERE `id` = :dcValue3", { "dcValue1": null, "dcValue2": "1737496360211075", "dcValue3": 30 }, { "dcValue1": 1, "dcValue2": 2, "dcValue3": 1 } ] }, { "file": "/var/www/html/lib/public/AppFramework/Db/QBMapper.php", "line": 197, "function": "executeStatement", "class": "OC\\DB\\QueryBuilder\\QueryBuilder", "type": "->", "args": [] }, { "file": "/var/www/html/custom_apps/news/lib/Db/NewsMapperV2.php", "line": 70, "function": "update", "class": "OCP\\AppFramework\\Db\\QBMapper", "type": "->", "args": [ "*** sensitive parameters replaced ***" ] }, { "file": "/var/www/html/custom_apps/news/lib/Service/FeedServiceV2.php", "line": 398, "function": "update", "class": "OCA\\News\\Db\\NewsMapperV2", "type": "->", "args": [ "*** sensitive parameters replaced ***" ] }, { "file": "/var/www/html/custom_apps/news/lib/Service/FeedServiceV2.php", "line": 422, "function": "fetch", "class": "OCA\\News\\Service\\FeedServiceV2", "type": "->", "args": [ "*** sensitive parameters replaced ***" ] }, { "file": "/var/www/html/custom_apps/news/lib/Service/UpdaterService.php", "line": 63, "function": "fetchAll", "class": "OCA\\News\\Service\\FeedServiceV2", "type": "->", "args": [] }, { "file": "/var/www/html/custom_apps/news/lib/Cron/UpdaterJob.php", "line": 58, "function": "update", "class": "OCA\\News\\Service\\UpdaterService", "type": "->", "args": [ "*** sensitive parameters replaced ***" ] }, { "file": "/var/www/html/lib/public/BackgroundJob/Job.php", "line": 61, "function": "run", "class": "OCA\\News\\Cron\\UpdaterJob", "type": "->", "args": [ null ] }, { "file": "/var/www/html/lib/public/BackgroundJob/TimedJob.php", "line": 88, "function": "start", "class": "OCP\\BackgroundJob\\Job", "type": "->", "args": [ { "__class__": "OC\\BackgroundJob\\JobList" } ] }, { "file": "/var/www/html/lib/public/BackgroundJob/TimedJob.php", "line": 75, "function": "start", "class": "OCP\\BackgroundJob\\TimedJob", "type": "->", "args": [ { "__class__": "OC\\BackgroundJob\\JobList" } ] }, { "file": "/var/www/html/cron.php", "line": 162, "function": "execute", "class": "OCP\\BackgroundJob\\TimedJob", "type": "->", "args": [ { "__class__": "OC\\BackgroundJob\\JobList" } ] } ], "File": "/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php", "Line": 28, "Previous": { "Exception": "PDOException", "Message": "SQLSTATE[42703]: Undefined column: 7 ERROR: column \"next_update_time\" of relation \"oc_news_feeds\" does not exist\nLINE 1: UPDATE \"oc_news_feeds\" SET \"next_update_time\" = $1, \"last_mo...\n ^", "Code": "42703", "Trace": [ { "file": "/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php", "line": 130, "function": "execute", "class": "PDOStatement", "type": "->", "args": [ null ] }, { "file": "/var/www/html/3rdparty/doctrine/dbal/src/Connection.php", "line": 1207, "function": "execute", "class": "Doctrine\\DBAL\\Driver\\PDO\\Statement", "type": "->", "args": [] }, { "file": "/var/www/html/3rdparty/doctrine/dbal/src/Connections/PrimaryReadReplicaConnection.php", "line": 292, "function": "executeStatement", "class": "Doctrine\\DBAL\\Connection", "type": "->", "args": [ "UPDATE \"oc_news_feeds\" SET \"next_update_time\" = ?, \"last_modified\" = ? WHERE \"id\" = ?", [ null, "1737496360211075", 30 ], [ 1, 2, 1 ] ] }, { "file": "/var/www/html/lib/private/DB/Connection.php", "line": 462, "function": "executeStatement", "class": "Doctrine\\DBAL\\Connections\\PrimaryReadReplicaConnection", "type": "->", "args": [ "UPDATE \"oc_news_feeds\" SET \"next_update_time\" = :dcValue1, \"last_modified\" = :dcValue2 WHERE \"id\" = :dcValue3", { "dcValue1": null, "dcValue2": "1737496360211075", "dcValue3": 30 }, { "dcValue1": 1, "dcValue2": 2, "dcValue3": 1 } ] }, { "file": "/var/www/html/lib/private/DB/ConnectionAdapter.php", "line": 67, "function": "executeStatement", "class": "OC\\DB\\Connection", "type": "->", "args": [ "UPDATE \"oc_news_feeds\" SET \"next_update_time\" = :dcValue1, \"last_modified\" = :dcValue2 WHERE \"id\" = :dcValue3", { "dcValue1": null, "dcValue2": "1737496360211075", "dcValue3": 30 }, { "dcValue1": 1, "dcValue2": 2, "dcValue3": 1 } ] }, { "file": "/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php", "line": 306, "function": "executeStatement", "class": "OC\\DB\\ConnectionAdapter", "type": "->", "args": [ "UPDATE `*PREFIX*news_feeds` SET `next_update_time` = :dcValue1, `last_modified` = :dcValue2 WHERE `id` = :dcValue3", { "dcValue1": null, "dcValue2": "1737496360211075", "dcValue3": 30 }, { "dcValue1": 1, "dcValue2": 2, "dcValue3": 1 } ] }, { "file": "/var/www/html/lib/public/AppFramework/Db/QBMapper.php", "line": 197, "function": "executeStatement", "class": "OC\\DB\\QueryBuilder\\QueryBuilder", "type": "->", "args": [] }, { "file": "/var/www/html/custom_apps/news/lib/Db/NewsMapperV2.php", "line": 70, "function": "update", "class": "OCP\\AppFramework\\Db\\QBMapper", "type": "->", "args": [ "*** sensitive parameters replaced ***" ] }, { "file": "/var/www/html/custom_apps/news/lib/Service/FeedServiceV2.php", "line": 398, "function": "update", "class": "OCA\\News\\Db\\NewsMapperV2", "type": "->", "args": [ "*** sensitive parameters replaced ***" ] }, { "file": "/var/www/html/custom_apps/news/lib/Service/FeedServiceV2.php", "line": 422, "function": "fetch", "class": "OCA\\News\\Service\\FeedServiceV2", "type": "->", "args": [ "*** sensitive parameters replaced ***" ] }, { "file": "/var/www/html/custom_apps/news/lib/Service/UpdaterService.php", "line": 63, "function": "fetchAll", "class": "OCA\\News\\Service\\FeedServiceV2", "type": "->", "args": [] }, { "file": "/var/www/html/custom_apps/news/lib/Cron/UpdaterJob.php", "line": 58, "function": "update", "class": "OCA\\News\\Service\\UpdaterService", "type": "->", "args": [ "*** sensitive parameters replaced ***" ] }, { "file": "/var/www/html/lib/public/BackgroundJob/Job.php", "line": 61, "function": "run", "class": "OCA\\News\\Cron\\UpdaterJob", "type": "->", "args": [ null ] }, { "file": "/var/www/html/lib/public/BackgroundJob/TimedJob.php", "line": 88, "function": "start", "class": "OCP\\BackgroundJob\\Job", "type": "->", "args": [ { "__class__": "OC\\BackgroundJob\\JobList" } ] }, { "file": "/var/www/html/lib/public/BackgroundJob/TimedJob.php", "line": 75, "function": "start", "class": "OCP\\BackgroundJob\\TimedJob", "type": "->", "args": [ { "__class__": "OC\\BackgroundJob\\JobList" } ] }, { "file": "/var/www/html/cron.php", "line": 162, "function": "execute", "class": "OCP\\BackgroundJob\\TimedJob", "type": "->", "args": [ { "__class__": "OC\\BackgroundJob\\JobList" } ] } ], "File": "/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php", "Line": 130 } } }, "message": "Error while running background job OCA\\News\\Cron\\UpdaterJob (id: 8624, arguments: null)", "exception": [], "CustomMessage": "Error while running background job OCA\\News\\Cron\\UpdaterJob (id: 8624, arguments: null)" }, "id": "67901985bb949" }The text was updated successfully, but these errors were encountered: