Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Could not fetch podcast synchronization stat #186

Open
n-marci opened this issue Nov 13, 2024 · 1 comment
Open

Could not fetch podcast synchronization stat #186

n-marci opened this issue Nov 13, 2024 · 1 comment

Comments

@n-marci
Copy link

n-marci commented Nov 13, 2024

Hi,

I have Nextcloud setup with NixOS not using https and am using Tailscale to access my server.
Antennapod fails to synchronize, when I try to login.
When opening the GPodderSync settings in the Nextcloud web interface, I get the folliowing error in the log:

Nextcloud[6902]: {"reqId":"qUfdCj6ulVTTPtIjQjjy","level":3,"time":"2024-11-13T19:56:30+00:00","remoteAddr":"xxx.xxx.xxx.xxx","user":"xxx","app":"index","method":"GET","url":"/apps/gpoddersync/personal_settings/metrics","message":"{\"Exception\":\"OC\\\\DB\\\\Exceptions\\\\DbalException\",\"Message\":\"An exception occurred while executing a query: SQLSTATE[42P01]: Undefined table: 7 ERROR:  relation \\\"oc_gpodder_episode_action\\\" does not exist\\nLINE 1: SELECT * FROM \\\"oc_gpodder_episode_action\\\" WHERE (\\\"timestamp_...\\n                      ^\",\"Code\":7,\"Trace\":[{\"file\":\"/nix/store/a8d1pxj6bikfbbihrky6vph7wqbnmf7i-nextcloud-30.0.1/lib/private/DB/ConnectionAdapter.php\",\"line\":53,\"function\":\"wrap\",\"class\":\"OC\\\\DB\\\\Exceptions\\\\DbalException\",\"type\":\"::\"},{\"file\":\"/nix/store/a8d1pxj6bikfbbihrky6vph7wqbnmf7i-nextcloud-30.0.1/lib/private/DB/QueryBuilder/QueryBuilder.php\",\"line\":289,\"function\":\"executeQuery\",\"class\":\"OC\\\\DB\\\\ConnectionAdapter\",\"type\":\"->\"},{\"file\":\"/nix/store/a8d1pxj6bikfbbihrky6vph7wqbnmf7i-nextcloud-30.0.1/lib/public/AppFramework/Db/QBMapper.php\",\"line\":313,\"function\":\"executeQuery\",\"class\":\"OC\\\\DB\\\\QueryBuilder\\\\QueryBuilder\",\"type\":\"->\"},{\"file\":\"/nix/store/dgiq48mhcmcal5mi72dz0p6qddxww2aj-gpoddersync.tar.gz-patched/lib/Db/EpisodeAction/EpisodeActionMapper.php\",\"line\":37,\"function\":\"findEntities\",\"class\":\"OCP\\\\AppFramework\\\\Db\\\\QBMapper\",\"type\":\"->\"},{\"file\":\"/nix/store/dgiq48mhcmcal5mi72dz0p6qddxww2aj-gpoddersync.tar.gz-patched/lib/Db/EpisodeAction/EpisodeActionRepository.php\",\"line\":25,\"function\":\"findAll\",\"class\":\"OCA\\\\GPodderSync\\\\Db\\\\EpisodeAction\\\\EpisodeActionMapper\",\"type\":\"->\"},{\"file\":\"/nix/store/dgiq48mhcmcal5mi72dz0p6qddxww2aj-gpoddersync.tar.gz-patched/lib/Core/PodcastData/PodcastMetricsReader.php\",\"line\":33,\"function\":\"findAll\",\"class\":\"OCA\\\\GPodderSync\\\\Db\\\\EpisodeAction\\\\EpisodeActionRepository\",\"type\":\"->\"},{\"file\":\"/nix/store/dgiq48mhcmcal5mi72dz0p6qddxww2aj-gpoddersync.tar.gz-patched/lib/Controller/PersonalSettingsController.php\",\"line\":41,\"function\":\"metrics\",\"class\":\"OCA\\\\GPodderSync\\\\Core\\\\PodcastData\\\\PodcastMetricsReader\",\"type\":\"->\"},{\"file\":\"/nix/store/a8d1pxj6bikfbbihrky6vph7wqbnmf7i-nextcloud-30.0.1/lib/private/AppFramework/Http/Dispatcher.php\",\"line\":208,\"function\":\"metrics\",\"class\":\"OCA\\\\GPodderSync\\\\Controller\\\\PersonalSettingsController\",\"type\":\"->\"},{\"file\":\"/nix/store/a8d1pxj6bikfbbihrky6vph7wqbnmf7i-nextcloud-30.0.1/lib/private/AppFramework/Http/Dispatcher.php\",\"line\":114,\"function\":\"executeController\",\"class\":\"OC\\\\AppFramework\\\\Http\\\\Dispatcher\",\"type\":\"->\"},{\"file\":\"/nix/store/a8d1pxj6bikfbbihrky6vph7wqbnmf7i-nextcloud-30.0.1/lib/private/AppFramework/App.php\",\"line\":161,\"function\":\"dispatch\",\"class\":\"OC\\\\AppFramework\\\\Http\\\\Dispatcher\",\"type\":\"->\"},{\"file\":\"/nix/store/a8d1pxj6bikfbbihrky6vph7wqbnmf7i-nextcloud-30.0.1/lib/private/Route/Router.php\",\"line\":302,\"function\":\"main\",\"class\":\"OC\\\\AppFramework\\\\App\",\"type\":\"::\"},{\"file\":\"/nix/store/a8d1pxj6bikfbbihrky6vph7wqbnmf7i-nextcloud-30.0.1/lib/base.php\",\"line\":1001,\"function\":\"match\",\"class\":\"OC\\\\Route\\\\Router\",\"type\":\"->\"},{\"file\":\"/nix/store/a8d1pxj6bikfbbihrky6vph7wqbnmf7i-nextcloud-30.0.1/index.php\",\"line\":24,\"function\":\"handleRequest\",\"class\":\"OC\",\"type\":\"::\"}],\"File\":\"/nix/store/a8d1pxj6bikfbbihrky6vph7wqbnmf7i-nextcloud-30.0.1/lib/private/DB/Exceptions/DbalException.php\",\"Line\":54,\"Previous\":{\"Exception\":\"Doctrine\\\\DBAL\\\\Exception\\\\TableNotFoundException\",\"Message\":\"An exception occurred while executing a query: SQLSTATE[42P01]: Undefined table: 7 ERROR:  relation \\\"oc_gpodder_episode_action\\\" does not exist\\nLINE 1: SELECT * FROM \\\"oc_gpodder_episode_action\\\" WHERE (\\\"timestamp_...\\n                      ^\",\"Code\":7,\"Trace\":[{\"file\":\"/nix/store/a8d1pxj6bikfbbihrky6vph7wqbnmf7i-nextcloud-30.0.1/3rdparty/doctrine/dbal/src/Connection.php\",\"line\":1939,\"function\":\"convert\",\"class\":\"Doctrine\\\\DBAL\\\\Driver\\\\API\\\\PostgreSQL\\\\ExceptionConverter\",\"type\":\"->\"},{\"file\":\"/nix/store/a8d1pxj6bikfbbihrky6vph7wqbnmf7i-nextcloud-30.0.1/3rdparty/doctrine/dbal/src/Connection.php\",\"line\":1881,\"function\":\"handleDriverException\",\"class\":\"Doctrine\\\\DBAL\\\\Connection\",\"type\":\"->\"},{\"file\":\"/nix/store/a8d1pxj6bikfbbihrky6vph7wqbnmf7i-nextcloud-30.0.1/3rdparty/doctrine/dbal/src/Connection.php\",\"line\":1106,\"function\":\"convertExceptionDuringQuery\",\"class\":\"Doctrine\\\\DBAL\\\\Connection\",\"type\":\"->\"},{\"file\":\"/nix/store/a8d1pxj6bikfbbihrky6vph7wqbnmf7i-nextcloud-30.0.1/lib/private/DB/Connection.php\",\"line\":415,\"function\":\"executeQuery\",\"class\":\"Doctrine\\\\DBAL\\\\Connection\",\"type\":\"->\"},{\"file\":\"/nix/store/a8d1pxj6bikfbbihrky6vph7wqbnmf7i-nextcloud-30.0.1/lib/private/DB/ConnectionAdapter.php\",\"line\":50,\"function\":\"executeQuery\",\"class\":\"OC\\\\DB\\\\Connection\",\"type\":\"->\"},{\"file\":\"/nix/store/a8d1pxj6bikfbbihrky6vph7wqbnmf7i-nextcloud-30.0.1/lib/private/DB/QueryBuilder/QueryBuilder.php\",\"line\":289,\"function\":\"executeQuery\",\"class\":\"OC\\\\DB\\\\ConnectionAdapter\",\"type\":\"->\"},{\"file\":\"/nix/store/a8d1pxj6bikfbbihrky6vph7wqbnmf7i-nextcloud-30.0.1/lib/public/AppFramework/Db/QBMapper.php\",\"line\":313,\"function\":\"executeQuery\",\"class\":\"OC\\\\DB\\\\QueryBuilder\\\\QueryBuilder\",\"type\":\"->\"},{\"file\":\"/nix/store/dgiq48mhcmcal5mi72dz0p6qddxww2aj-gpoddersync.tar.gz-patched/lib/Db/EpisodeAction/EpisodeActionMapper.php\",\"line\":37,\"function\":\"findEntities\",\"class\":\"OCP\\\\AppFramework\\\\Db\\\\QBMapper\",\"type\":\"->\"},{\"file\":\"/nix/store/dgiq48mhcmcal5mi72dz0p6qddxww2aj-gpoddersync.tar.gz-patched/lib/Db/EpisodeAction/EpisodeActionRepository.php\",\"line\":25,\"function\":\"findAll\",\"class\":\"OCA\\\\GPodderSync\\\\Db\\\\EpisodeAction\\\\EpisodeActionMapper\",\"type\":\"->\"},{\"file\":\"/nix/store/dgiq48mhcmcal5mi72dz0p6qddxww2aj-gpoddersync.tar.gz-patched/lib/Core/PodcastData/PodcastMetricsReader.php\",\"line\":33,\"function\":\"findAll\",\"class\":\"OCA\\\\GPodderSync\\\\Db\\\\EpisodeAction\\\\EpisodeActionRepository\",\"type\":\"->\"},{\"file\":\"/nix/store/dgiq48mhcmcal5mi72dz0p6qddxww2aj-gpoddersync.tar.gz-patched/lib/Controller/PersonalSettingsController.php\",\"line\":41,\"function\":\"metrics\",\"class\":\"OCA\\\\GPodderSync\\\\Core\\\\PodcastData\\\\PodcastMetricsReader\",\"type\":\"->\"},{\"file\":\"/nix/store/a8d1pxj6bikfbbihrky6vph7wqbnmf7i-nextcloud-30.0.1/lib/private/AppFramework/Http/Dispatcher.php\",\"line\":208,\"function\":\"metrics\",\"class\":\"OCA\\\\GPodderSync\\\\Controller\\\\PersonalSettingsController\",\"type\":\"->\"},{\"file\":\"/nix/store/a8d1pxj6bikfbbihrky6vph7wqbnmf7i-nextcloud-30.0.1/lib/private/AppFramework/Http/Dispatcher.php\",\"line\":114,\"function\":\"executeController\",\"class\":\"OC\\\\AppFramework\\\\Http\\\\Dispatcher\",\"type\":\"->\"},{\"file\":\"/nix/store/a8d1pxj6bikfbbihrky6vph7wqbnmf7i-nextcloud-30.0.1/lib/private/AppFramework/App.php\",\"line\":161,\"function\":\"dispatch\",\"class\":\"OC\\\\AppFramework\\\\Http\\\\Dispatcher\",\"type\":\"->\"},{\"file\":\"/nix/store/a8d1pxj6bikfbbihrky6vph7wqbnmf7i-nextcloud-30.0.1/lib/private/Route/Router.php\",\"line\":302,\"function\":\"main\",\"class\":\"OC\\\\AppFramework\\\\App\",\"type\":\"::\"},{\"file\":\"/nix/store/a8d1pxj6bikfbbihrky6vph7wqbnmf7i-nextcloud-30.0.1/lib/base.php\",\"line\":1001,\"function\":\"match\",\"class\":\"OC\\\\Route\\\\Router\",\"type\":\"->\"},{\"file\":\"/nix/store/a8d1pxj6bikfbbihrky6vph7wqbnmf7i-nextcloud-30.0.1/index.php\",\"line\":24,\"function\":\"handleRequest\",\"class\":\"OC\",\"type\":\"::\"}],\"File\":\"/nix/store/a8d1pxj6bikfbbihrky6vph7wqbnmf7i-nextcloud-30.0.1/3rdparty/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php\",\"Line\":71,\"Previous\":{\"Exception\":\"Doctrine\\\\DBAL\\\\Driver\\\\PDO\\\\Exception\",\"Message\":\"SQLSTATE[42P01]: Undefined table: 7 ERROR:  relation \\\"oc_gpodder_episode_action\\\" does not exist\\nLINE 1: SELECT * FROM \\\"oc_gpodder_episode_action\\\" WHERE (\\\"timestamp_...\\n                      ^\",\"Code\":7,\"Trace\":[{\"file\":\"/nix/store/a8d1pxj6bikfbbihrky6vph7wqbnmf7i-nextcloud-30.0.1/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php\",\"line\":132,\"function\":\"new\",\"class\":\"Doctrine\\\\DBAL\\\\Driver\\\\PDO\\\\Exception\",\"type\":\"::\"},{\"file\":\"/nix/store/a8d1pxj6bikfbbihrky6vph7wqbnmf7i-nextcloud-30.0.1/3rdparty/doctrine/dbal/src/Connection.php\",\"line\":1099,\"function\":\"execute\",\"class\":\"Doctrine\\\\DBAL\\\\Driver\\\\PDO\\\\Statement\",\"type\":\"->\"},{\"file\":\"/nix/store/a8d1pxj6bikfbbihrky6vph7wqbnmf7i-nextcloud-30.0.1/lib/private/DB/Connection.php\",\"line\":415,\"function\":\"executeQuery\",\"class\":\"Doctrine\\\\DBAL\\\\Connection\",\"type\":\"->\"},{\"file\":\"/nix/store/a8d1pxj6bikfbbihrky6vph7wqbnmf7i-nextcloud-30.0.1/lib/private/DB/ConnectionAdapter.php\",\"line\":50,\"function\":\"executeQuery\",\"class\":\"OC\\\\DB\\\\Connection\",\"type\":\"->\"},{\"file\":\"/nix/store/a8d1pxj6bikfbbihrky6vph7wqbnmf7i-nextcloud-30.0.1/lib/private/DB/QueryBuilder/QueryBuilder.php\",\"line\":289,\"function\":\"executeQuery\",\"class\":\"OC\\\\DB\\\\ConnectionAdapter\",\"type\":\"->\"},{\"file\":\"/nix/store/a8d1pxj6bikfbbihrky6vph7wqbnmf7i-nextcloud-30.0.1/lib/public/AppFramework/Db/QBMapper.php\",\"line\":313,\"function\":\"executeQuery\",\"class\":\"OC\\\\DB\\\\QueryBuilder\\\\QueryBuilder\",\"type\":\"->\"},{\"file\":\"/nix/store/dgiq48mhcmcal5mi72dz0p6qddxww2aj-gpoddersync.tar.gz-patched/lib/Db/EpisodeAction/EpisodeActionMapper.php\",\"line\":37,\"function\":\"findEntities\",\"class\":\"OCP\\\\AppFramework\\\\Db\\\\QBMapper\",\"type\":\"->\"},{\"file\":\"/nix/store/dgiq48mhcmcal5mi72dz0p6qddxww2aj-gpoddersync.tar.gz-patched/lib/Db/EpisodeAction/EpisodeActionRepository.php\",\"line\":25,\"function\":\"findAll\",\"class\":\"OCA\\\\GPodderSync\\\\Db\\\\EpisodeAction\\\\EpisodeActionMapper\",\"type\":\"->\"},{\"file\":\"/nix/store/dgiq48mhcmcal5mi72dz0p6qddxww2aj-gpoddersync.tar.gz-patched/lib/Core/PodcastData/PodcastMetricsReader.php\",\"line\":33,\"function\":\"findAll\",\"class\":\"OCA\\\\GPodderSync\\\\Db\\\\EpisodeAction\\\\EpisodeActionRepository\",\"type\":\"->\"},{\"file\":\"/nix/store/dgiq48mhcmcal5mi72dz0p6qddxww2aj-gpoddersync.tar.gz-patched/lib/Controller/PersonalSettingsController.php\",\"line\":41,\"function\":\"metrics\",\"class\":\"OCA\\\\GPodderSync\\\\Core\\\\PodcastData\\\\PodcastMetricsReader\",\"type\":\"->\"},{\"file\":\"/nix/store/a8d1pxj6bikfbbihrky6vph7wqbnmf7i-nextcloud-30.0.1/lib/private/AppFramework/Http/Dispatcher.php\",\"line\":208,\"function\":\"metrics\",\"class\":\"OCA\\\\GPodderSync\\\\Controller\\\\PersonalSettingsController\",\"type\":\"->\"},{\"file\":\"/nix/store/a8d1pxj6bikfbbihrky6vph7wqbnmf7i-nextcloud-30.0.1/lib/private/AppFramework/Http/Dispatcher.php\",\"line\":114,\"function\":\"executeController\",\"class\":\"OC\\\\AppFramework\\\\Http\\\\Dispatcher\",\"type\":\"->\"},{\"file\":\"/nix/store/a8d1pxj6bikfbbihrky6vph7wqbnmf7i-nextcloud-30.0.1/lib/private/AppFramework/App.php\",\"line\":161,\"function\":\"dispatch\",\"class\":\"OC\\\\AppFramework\\\\Http\\\\Dispatcher\",\"type\":\"->\"},{\"file\":\"/nix/store/a8d1pxj6bikfbbihrky6vph7wqbnmf7i-nextcloud-30.0.1/lib/private/Route/Router.php\",\"line\":302,\"function\":\"main\",\"class\":\"OC\\\\AppFramework\\\\App\",\"type\":\"::\"},{\"file\":\"/nix/store/a8d1pxj6bikfbbihrky6vph7wqbnmf7i-nextcloud-30.0.1/lib/base.php\",\"line\":1001,\"function\":\"match\",\"class\":\"OC\\\\Route\\\\Router\",\"type\":\"->\"},{\"file\":\"/nix/store/a8d1pxj6bikfbbihrky6vph7wqbnmf7i-nextcloud-30.0.1/index.php\",\"line\":24,\"function\":\"handleRequest\",\"class\":\"OC\",\"type\":\"::\"}],\"File\":\"/nix/store/a8d1pxj6bikfbbihrky6vph7wqbnmf7i-nextcloud-30.0.1/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php\",\"Line\":28,\"Previous\":{\"Exception\":\"PDOException\",\"Message\":\"SQLSTATE[42P01]: Undefined table: 7 ERROR:  relation \\\"oc_gpodder_episode_action\\\" does not exist\\nLINE 1: SELECT * FROM \\\"oc_gpodder_episode_action\\\" WHERE (\\\"timestamp_...\\n                      ^\",\"Code\":\"42P01\",\"Trace\":[{\"file\":\"/nix/store/a8d1pxj6bikfbbihrky6vph7wqbnmf7i-nextcloud-30.0.1/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php\",\"line\":130,\"function\":\"execute\",\"class\":\"PDOStatement\",\"type\":\"->\"},{\"file\":\"/nix/store/a8d1pxj6bikfbbihrky6vph7wqbnmf7i-nextcloud-30.0.1/3rdparty/doctrine/dbal/src/Connection.php\",\"line\":1099,\"function\":\"execute\",\"class\":\"Doctrine\\\\DBAL\\\\Driver\\\\PDO\\\\Statement\",\"type\":\"->\"},{\"file\":\"/nix/store/a8d1pxj6bikfbbihrky6vph7wqbnmf7i-nextcloud-30.0.1/lib/private/DB/Connection.php\",\"line\":415,\"function\":\"executeQuery\",\"class\":\"Doctrine\\\\DBAL\\\\Connection\",\"type\":\"->\"},{\"file\":\"/nix/store/a8d1pxj6bikfbbihrky6vph7wqbnmf7i-nextcloud-30.0.1/lib/private/DB/ConnectionAdapter.php\",\"line\":50,\"function\":\"executeQuery\",\"class\":\"OC\\\\DB\\\\Connection\",\"type\":\"->\"},{\"file\":\"/nix/store/a8d1pxj6bikfbbihrky6vph7wqbnmf7i-nextcloud-30.0.1/lib/private/DB/QueryBuilder/QueryBuilder.php\",\"line\":289,\"function\":\"executeQuery\",\"class\":\"OC\\\\DB\\\\ConnectionAdapter\",\"type\":\"->\"},{\"file\":\"/nix/store/a8d1pxj6bikfbbihrky6vph7wqbnmf7i-nextcloud-30.0.1/lib/public/AppFramework/Db/QBMapper.php\",\"line\":313,\"function\":\"executeQuery\",\"class\":\"OC\\\\DB\\\\QueryBuilder\\\\QueryBuilder\",\"type\":\"->\"},{\"file\":\"/nix/store/dgiq48mhcmcal5mi72dz0p6qddxww2aj-gpoddersync.tar.gz-patched/lib/Db/EpisodeAction/EpisodeActionMapper.php\",\"line\":37,\"function\":\"findEntities\",\"class\":\"OCP\\\\AppFramework\\\\Db\\\\QBMapper\",\"type\":\"->\"},{\"file\":\"/nix/store/dgiq48mhcmcal5mi72dz0p6qddxww2aj-gpoddersync.tar.gz-patched/lib/Db/EpisodeAction/EpisodeActionRepository.php\",\"line\":25,\"function\":\"findAll\",\"class\":\"OCA\\\\GPodderSync\\\\Db\\\\EpisodeAction\\\\EpisodeActionMapper\",\"type\":\"->\"},{\"file\":\"/nix/store/dgiq48mhcmcal5mi72dz0p6qddxww2aj-gpoddersync.tar.gz-patched/lib/Core/PodcastData/PodcastMetricsReader.php\",\"line\":33,\"function\":\"findAll\",\"class\":\"OCA\\\\GPodderSync\\\\Db\\\\EpisodeAction\\\\EpisodeActionRepository\",\"type\":\"->\"},{\"file\":\"/nix/store/dgiq48mhcmcal5mi72dz0p6qddxww2aj-gpoddersync.tar.gz-patched/lib/Controller/PersonalSettingsController.php\",\"line\":41,\"function\":\"metrics\",\"class\":\"OCA\\\\GPodderSync\\\\Core\\\\PodcastData\\\\PodcastMetricsReader\",\"type\":\"->\"},{\"file\":\"/nix/store/a8d1pxj6bikfbbihrky6vph7wqbnmf7i-nextcloud-30.0.1/lib/private/AppFramework/Http/Dispatcher.php\",\"line\":208,\"function\":\"metrics\",\"class\":\"OCA\\\\GPodderSync\\\\Controller\\\\PersonalSettingsController\",\"type\":\"->\"},{\"file\":\"/nix/store/a8d1pxj6bikfbbihrky6vph7wqbnmf7i-nextcloud-30.0.1/lib/private/AppFramework/Http/Dispatcher.php\",\"line\":114,\"function\":\"executeController\",\"class\":\"OC\\\\AppFramework\\\\Http\\\\Dispatcher\",\"type\":\"->\"},{\"file\":\"/nix/store/a8d1pxj6bikfbbihrky6vph7wqbnmf7i-nextcloud-30.0.1/lib/private/AppFramework/App.php\",\"line\":161,\"function\":\"dispatch\",\"class\":\"OC\\\\AppFramework\\\\Http\\\\Dispatcher\",\"type\":\"->\"},{\"file\":\"/nix/store/a8d1pxj6bikfbbihrky6vph7wqbnmf7i-nextcloud-30.0.1/lib/private/Route/Router.php\",\"line\":302,\"function\":\"main\",\"class\":\"OC\\\\AppFramework\\\\App\",\"type\":\"::\"},{\"file\":\"/nix/store/a8d1pxj6bikfbbihrky6vph7wqbnmf7i-nextcloud-30.0.1/lib/base.php\",\"line\":1001,\"function\":\"match\",\"class\":\"OC\\\\Route\\\\Router\",\"type\":\"->\"},{\"file\":\"/nix/store/a8d1pxj6bikfbbihrky6vph7wqbnmf7i-nextcloud-30.0.1/index.php\",\"line\":24,\"function\":\"handleRequest\",\"class\":\"OC\",\"type\":\"::\"}],\"File\":\"/nix/store/a8d1pxj6bikfbbihrky6vph7wqbnmf7i-nextcloud-30.0.1/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php\",\"Line\":130}}},\"message\":\"An exception occurred while executing a query: SQLSTATE[42P01]: Undefined table: 7 ERROR:  relation \\\"oc_gpodder_episode_action\\\" does not exist\\nLINE 1: SELECT * FROM \\\"oc_gpodder_episode_action\\\" WHERE (\\\"timestamp_...\\n                      ^\",\"exception\":{},\"CustomMessage\":\"An exception occurred while executing a query: SQLSTATE[42P01]: Undefined table: 7 ERROR:  relation \\\"oc_gpodder_episode_action\\\" does not exist\\nLINE 1: SELECT * FROM \\\"oc_gpodder_episode_action\\\" WHERE (\\\"timestamp_...\\n                      ^\"}","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:132.0) Gecko/20100101 Firefox/132.0","version":"30.0.1.2"}

I am guessing there is some problem with the database on NixOS?

@JonOfUs
Copy link
Collaborator

JonOfUs commented Nov 27, 2024

Hmm, I'm not that familiar with NixOS. Does it use the normal Nextcloud app? In the log there is something about gpoddersync.tar.gz-patched that makes me wonder whether the app was changed.

The error looks like the app was not installed correctly. Normally, when activating/installing an app, some DB migrations are executed that create tables and so on. But the logs suggest that the tables were not created in your DB. So maybe reinstalling this app or disabling and then re-enabling it might help.
And if this doesn't help, you have to find out what was changed in the NixOS packages of this app, I fear. If you have the link to the package you used for the app, I can maybe take a look at it.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants