nextcloud-gpodder java.io.IOException: Response code: 500

That`s the only error i get after sucessfull login.

java.io.IOException: Response code: 500

Jun 27 '22 06:06 Mannshoch

Hi, is gpoddersync installed?

Jun 27 '22 08:06 JonOfUs

yes. v. 3.4.0 on my Nextcloud 24.0.2
I added https://cloudsubdomain.domain.com I triedt to uninstall and reinstalled.

Jun 27 '22 11:06 Mannshoch

Okay. I'll need some more information in order to help:

Do you have access to Nextcloud logs? If so, please send the corresponding log entries (remember to remove sensitive values), this means all log entries regarding gpoddersync.
Is there a message after java.io.IOException: Response code: 500 (like "user not logged in" or so)? If so, please send it.
Open the url https://cloudsubdomain.domain.com/index.php/apps/gpoddersync/episode_action?since=0 (with your Nextcloud domain) and send me any error messages. (Not only Response code: 500, but also the error message's text)
If no errors occur and the output looks like actions: [...], timestamp: 1656..., open the url https://cloudsubdomain.domain.com/index.php/apps/gpoddersync/subscriptions?since=0 (with your Nextcloud domain) and send any error messages.

Jun 27 '22 12:06 JonOfUs

"app":"geoblocker","method":"GET","url":"/ocs/v2.php/apps/notifications/api/v2/notifications","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead." that's the only line. It repeats
no.
and 3. looks like normal json to me.

Jun 27 '22 14:06 Mannshoch

Hmm, since accessing the URLs directly seems to work, the problem could be connected to AntennaPod.

Did you try removing and the re-enabling sync in AntennaPod?

Do you have any very special podcasts subscribed like some with authentication credentials inside the feed url?

If you have backend access to your Nextcloud, you could temporarily lower the log level, retry syncing and send any log entries in nextcloud.log (or from the web log, if they occur there as well) concerning the 500 error.

Jun 28 '22 07:06 JonOfUs

Jun 29 '22 09:06 Mannshoch

Thanks, maybe this helps.

It's very odd, sadly I can't reproduce this error - I tried a lot to break anything but never recreated your error. I can't find problems in the corresponding code section. So unless I overlooked something, this problem is more complicated.

Is it possible that you manually edited your DB?
Or have some kind of distributed DB or so?
Or anything else that may be unordinary?
Which DB type are you using, anyway?

I fear in order to help and (hopefully) fix this issue I will need an extract of the oc_gpodder_episode_action table as well as the above log with debug mode on (in order to get all details, as mentioned in "And 25 more entries, set log level to debug to see all entries"). With these information I should be able to reproduce the error.

@thrillfall any idea? It looks like EpisodeActionSaver->updateEpisodeAction() creates the trouble, especially line 81, because somehow in this setup $episodeActionToUpdate is null in this line. This function is only called on UNIQUE_CONSTRAINT_VIOLATIONS, so if the episode (episode or guid) is already present. And if it is present, $episodeActionToUpdate should never be null in line 81, because in every case the episode gets searched by guid if possible and then by episode - so if the search works correctly, this has to work, since the entry has to exist in the DB. I can't find logical gaps here.

Jun 30 '22 11:06 JonOfUs

No idea. Looks like a "broken" database to me too. Without that database dump it is just wild guessing

Jul 07 '22 20:07 thrillfall

Is it possible that you manually edited your DB?

No.

Or have some kind of distributed DB or so?

No

Or anything else that may be unordinary?

My php/mysql only webshare use Nextcloud since 2012 (owncloud) and upgrade this Nextcloud since.

Which DB type are you using, anyway?

Mysql

If you say the gpodder app database is broken, how could I may somehow reset the Gpodder database in Nextcloud?

Jul 09 '22 15:07 Mannshoch

The gpoddersync data is located in the Nextcloud database (with all data like calendars, contacts, file shares, user accounts, ...), so if the gpoddersync data is broken, it is quite possible that there is something else broken in your Nextcloud as well. And if not the data but the database structure (schema) is the problem, the following won't help either.

However, resetting the gpoddersync data can probably fix your problems with podcast syncing, so if this is your main concern: Resetting the gpodder table responsible for episode timestamps is always possible directly through MySQL by just deleting the contents of the table oc_gpodder_episode_action - but always do a backup of the DB before altering anything. And be careful to specify the correct table in the SQL queries. Here are two sql commands that will both delete all gpoddersync episode timestamp data:

-- assuming the main Nextcloud db specified in config.php is currently selected in the MySQL CLI
-- this can be done by running the following command inside a terminal on your server: mysql -u nextcloud-user -p nextcloud-database
-- (with nextcloud-user as the Nextcloud database's MySQL user and nextcloud-database as the Nextcloud database's name)

DELETE FROM `oc_gpodder_episode_action`;
-- this will delete all stored gpoddersync episode timestamps.

DELETE FROM `oc_gpodder_episode_action` WHERE user_id='admin'; -- replace admin with your username
-- this will delete all stored gpoddersync episode timestamps for the specified user only

You can also use database management tools with GUIs like phpmyadmin for this, just be careful to delete only contents of the table oc_gpodder_episode_action and nothing else since the DB is kind of the heart of Nextcloud (or the brain).

After doing this, even many old episode timestamps can probably be sent to your Nextcloud again by using the 'force full sync' function in Antennapod.

Jul 10 '22 13:07 JonOfUs

Uh.. I do not have any intend to manually modify the database. Do you have a occ command for that?

I don't think that nextcloud have any other problems.

Jul 10 '22 14:07 Mannshoch

There is no such command. You'll have to do it manually. Or someone might provide a command...maybe you want to contribute?

Jul 10 '22 18:07 thrillfall

Stale: No further information provided. Closing

Sep 03 '22 18:09 thrillfall

@thrillfall What Information do you need?

Sep 03 '22 18:09 Mannshoch

@thrillfall What Information do you need?

As i said. Database dump

Sep 03 '22 19:09 thrillfall

I seem to have the same problem described here. Nextcloud 24.0.5 GPodderSync 3.4.0 AntennaPod 2.7.0

I do not know what triggered the problem in the first place - I have it now for several weeks. I just uninstalled GPodderSync, dropped the oc_gpodder_episode_action and oc_gpodder_subscriptions in the mysql database and then reinstalled GPodderSync, created the two tables again empty and then tried a new sync with AntennaPod. (Yes, deleting the table content would probably also do the trick.) That was successfull (for now).

I still have the backup of the two tables. - @thrillfall If you are interested, I can supply it directly.

Sep 16 '22 18:09 RedFoxPi

I seem to have the same problem described here. Nextcloud 24.0.5 GPodderSync 3.4.0 AntennaPod 2.7.0

I do not know what triggered the problem in the first place - I have it now for several weeks. I just uninstalled GPodderSync, dropped the oc_gpodder_episode_action and oc_gpodder_subscriptions in the mysql database and then reinstalled GPodderSync, created the two tables again empty and then tried a new sync with AntennaPod. (Yes, deleting the table content would probably also do the trick.) That was successfull (for now).

I still have the backup of the two tables. - @thrillfall If you are interested, I can supply it directly.

That would definetly help

Sep 17 '22 19:09 thrillfall

I was provided a database dump which would result in this error when trying to update an episode action. But since the request itself cannot be reconstructed it is still pure guesswork what is happening here.

The database has no obvious inconsistencies.

Sep 22 '22 18:09 thrillfall

Hello @thrillfall, I just run into this issue an the culprit was the length of oc_gpodder_episode_action->episode: 500 bytes is not enough for paid podcasts managed by acast.com where they add a long key; in my case the URL is 612 characters.
I changed this filed to 1000 an sync succeeded.

Sep 26 '22 22:09 Oliv4945

Ooooooooooohhhhhh. Thanks!. Well increase the length then

Sep 28 '22 17:09 thrillfall

I installed gpoddersync again. It still not work.

{"reqId":"Y2lAtFCu4JiIlST2RkwzpAAAABI","level":3,"time":"2022.11.07, 18:30:29","user":"USER","app":"index","method":"GET","url":"//index.php/apps/gpoddersync/subscriptions?since=0","message":"An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'Cloud.oc_gpodder_subscriptions' doesn't exist","userAgent":"AntennaPod/2.7.1","version":"24.0.7.1","exception":{"Exception":"OC\\DB\\Exceptions\\DbalException","Message":"An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'Cloud.oc_gpodder_subscriptions' doesn't exist","Code":1146,"Trace":[{"file":"/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":296,"function":"wrap","class":"OC\\DB\\Exceptions\\DbalException","type":"::","args":[{"__class__":"Doctrine\\DBAL\\Exception\\TableNotFoundException"}]},{"file":"/nextcloud/lib/public/AppFramework/Db/QBMapper.php","line":336,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/nextcloud/apps/gpoddersync/lib/Db/SubscriptionChange/SubscriptionChangeMapper.php","line":66,"function":"findEntities","class":"OCP\\AppFramework\\Db\\QBMapper","type":"->","args":[{"__class__":"OC\\DB\\QueryBuilder\\QueryBuilder"}]},{"file":"/nextcloud/apps/gpoddersync/lib/Db/SubscriptionChange/SubscriptionChangeRepository.php","line":26,"function":"findAllSubscriptionState","class":"OCA\\GPodderSync\\Db\\SubscriptionChange\\SubscriptionChangeMapper","type":"->","args":[true,{"__class__":"DateTime"},"USER"]},{"file":"/nextcloud/apps/gpoddersync/lib/Controller/SubscriptionChangeController.php","line":60,"function":"findAllSubscribed","class":"OCA\\GPodderSync\\Db\\SubscriptionChange\\SubscriptionChangeRepository","type":"->","args":[{"__class__":"DateTime"},"USER"]},{"file":"/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":225,"function":"list","class":"OCA\\GPodderSync\\Controller\\SubscriptionChangeController","type":"->","args":[0]},{"file":"/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":133,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\GPodderSync\\Controller\\SubscriptionChangeController"},"list"]},{"file":"/nextcloud/lib/private/AppFramework/App.php","line":172,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\GPodderSync\\Controller\\SubscriptionChangeController"},"list"]},{"file":"/nextcloud/lib/private/Route/Router.php","line":298,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\GPodderSync\\Controller\\SubscriptionChangeController","list",{"__class__":"OC\\AppFramework\\DependencyInjection\\DIContainer"},["gpoddersync.subscription_change.list"]]},{"file":"/nextcloud/lib/base.php","line":1030,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/apps/gpoddersync/subscriptions"]},{"file":"/nextcloud/index.php","line":36,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/nextcloud/lib/private/DB/Exceptions/DbalException.php","Line":71,"Previous":{"Exception":"Doctrine\\DBAL\\Exception\\TableNotFoundException","Message":"An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'Cloud.oc_gpodder_subscriptions' doesn't exist","Code":1146,"Trace":[{"file":"/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1780,"function":"convert","class":"Doctrine\\DBAL\\Driver\\API\\MySQL\\ExceptionConverter","type":"->","args":[{"__class__":"Doctrine\\DBAL\\Driver\\PDO\\Exception"},{"__class__":"Doctrine\\DBAL\\Query"}]},{"file":"/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1719,"function":"handleDriverException","class":"Doctrine\\DBAL\\Connection","type":"->","args":[{"__class__":"Doctrine\\DBAL\\Driver\\PDO\\Exception"},{"__class__":"Doctrine\\DBAL\\Query"}]},{"file":"/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1067,"function":"convertExceptionDuringQuery","class":"Doctrine\\DBAL\\Connection","type":"->","args":[{"__class__":"Doctrine\\DBAL\\Driver\\PDO\\Exception"},"SELECT `url` FROM `oc_gpodder_subscriptions` WHERE (`subscribed` = ?) AND (`updated` > ?) AND (`user_id` = ?)",[true,{"__class__":"DateTime"},"USER"],[5,"datetime",2]]},{"file":"/nextcloud/lib/private/DB/Connection.php","line":261,"function":"executeQuery","class":"Doctrine\\DBAL\\Connection","type":"->","args":["SELECT `url` FROM `oc_gpodder_subscriptions` WHERE (`subscribed` = ?) AND (`updated` > ?) AND (`user_id` = ?)",[true,{"__class__":"DateTime"},"USER"],[5,"datetime",2],null]},{"file":"/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":345,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->","args":["SELECT `url` FROM `oc_gpodder_subscriptions` WHERE (`subscribed` = :dcValue1) AND (`updated` > :dcValue2) AND (`user_id` = :dcValue3)",[true,{"__class__":"DateTime"},"USER"],[5,"datetime",2]]},{"file":"/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":281,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":294,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/nextcloud/lib/public/AppFramework/Db/QBMapper.php","line":336,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/nextcloud/apps/gpoddersync/lib/Db/SubscriptionChange/SubscriptionChangeMapper.php","line":66,"function":"findEntities","class":"OCP\\AppFramework\\Db\\QBMapper","type":"->","args":[{"__class__":"OC\\DB\\QueryBuilder\\QueryBuilder"}]},{"file":"/nextcloud/apps/gpoddersync/lib/Db/SubscriptionChange/SubscriptionChangeRepository.php","line":26,"function":"findAllSubscriptionState","class":"OCA\\GPodderSync\\Db\\SubscriptionChange\\SubscriptionChangeMapper","type":"->","args":[true,{"__class__":"DateTime"},"USER"]},{"file":"/nextcloud/apps/gpoddersync/lib/Controller/SubscriptionChangeController.php","line":60,"function":"findAllSubscribed","class":"OCA\\GPodderSync\\Db\\SubscriptionChange\\SubscriptionChangeRepository","type":"->","args":[{"__class__":"DateTime"},"USER"]},{"file":"/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":225,"function":"list","class":"OCA\\GPodderSync\\Controller\\SubscriptionChangeController","type":"->","args":[0]},{"file":"/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":133,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\GPodderSync\\Controller\\SubscriptionChangeController"},"list"]},{"file":"/nextcloud/lib/private/AppFramework/App.php","line":172,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\GPodderSync\\Controller\\SubscriptionChangeController"},"list"]},{"file":"/nextcloud/lib/private/Route/Router.php","line":298,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\GPodderSync\\Controller\\SubscriptionChangeController","list",{"__class__":"OC\\AppFramework\\DependencyInjection\\DIContainer"},["gpoddersync.subscription_change.list"]]},{"file":"/nextcloud/lib/base.php","line":1030,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/apps/gpoddersync/subscriptions"]},{"file":"/nextcloud/index.php","line":36,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/nextcloud/3rdparty/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php","Line":47,"Previous":{"Exception":"Doctrine\\DBAL\\Driver\\PDO\\Exception","Message":"SQLSTATE[42S02]: Base table or view not found: 1146 Table 'Cloud.oc_gpodder_subscriptions' doesn't exist","Code":1146,"Trace":[{"file":"/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","line":94,"function":"new","class":"Doctrine\\DBAL\\Driver\\PDO\\Exception","type":"::","args":[{"__class__":"PDOException","errorInfo":["42S02",1146,"Table 'Cloud.oc_gpodder_subscriptions' doesn't exist"]}]},{"file":"/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1057,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDO\\Statement","type":"->","args":[]},{"file":"/nextcloud/lib/private/DB/Connection.php","line":261,"function":"executeQuery","class":"Doctrine\\DBAL\\Connection","type":"->","args":["SELECT `url` FROM `oc_gpodder_subscriptions` WHERE (`subscribed` = ?) AND (`updated` > ?) AND (`user_id` = ?)",[true,{"__class__":"DateTime"},"USER"],[5,"datetime",2],null]},{"file":"/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":345,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->","args":["SELECT `url` FROM `oc_gpodder_subscriptions` WHERE (`subscribed` = :dcValue1) AND (`updated` > :dcValue2) AND (`user_id` = :dcValue3)",[true,{"__class__":"DateTime"},"USER"],[5,"datetime",2]]},{"file":"/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":281,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":294,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/nextcloud/lib/public/AppFramework/Db/QBMapper.php","line":336,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/nextcloud/apps/gpoddersync/lib/Db/SubscriptionChange/SubscriptionChangeMapper.php","line":66,"function":"findEntities","class":"OCP\\AppFramework\\Db\\QBMapper","type":"->","args":[{"__class__":"OC\\DB\\QueryBuilder\\QueryBuilder"}]},{"file":"/nextcloud/apps/gpoddersync/lib/Db/SubscriptionChange/SubscriptionChangeRepository.php","line":26,"function":"findAllSubscriptionState","class":"OCA\\GPodderSync\\Db\\SubscriptionChange\\SubscriptionChangeMapper","type":"->","args":[true,{"__class__":"DateTime"},"USER"]},{"file":"/nextcloud/apps/gpoddersync/lib/Controller/SubscriptionChangeController.php","line":60,"function":"findAllSubscribed","class":"OCA\\GPodderSync\\Db\\SubscriptionChange\\SubscriptionChangeRepository","type":"->","args":[{"__class__":"DateTime"},"USER"]},{"file":"/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":225,"function":"list","class":"OCA\\GPodderSync\\Controller\\SubscriptionChangeController","type":"->","args":[0]},{"file":"/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":133,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\GPodderSync\\Controller\\SubscriptionChangeController"},"list"]},{"file":"/nextcloud/lib/private/AppFramework/App.php","line":172,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\GPodderSync\\Controller\\SubscriptionChangeController"},"list"]},{"file":"/nextcloud/lib/private/Route/Router.php","line":298,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\GPodderSync\\Controller\\SubscriptionChangeController","list",{"__class__":"OC\\AppFramework\\DependencyInjection\\DIContainer"},["gpoddersync.subscription_change.list"]]},{"file":"/nextcloud/lib/base.php","line":1030,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/apps/gpoddersync/subscriptions"]},{"file":"/nextcloud/index.php","line":36,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php","Line":26,"Previous":{"Exception":"PDOException","Message":"SQLSTATE[42S02]: Base table or view not found: 1146 Table 'Cloud.oc_gpodder_subscriptions' doesn't exist","Code":"42S02","Trace":[{"file":"/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","line":92,"function":"execute","class":"PDOStatement","type":"->","args":[null]},{"file":"/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1057,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDO\\Statement","type":"->","args":[]},{"file":"/nextcloud/lib/private/DB/Connection.php","line":261,"function":"executeQuery","class":"Doctrine\\DBAL\\Connection","type":"->","args":["SELECT `url` FROM `oc_gpodder_subscriptions` WHERE (`subscribed` = ?) AND (`updated` > ?) AND (`user_id` = ?)",[true,{"__class__":"DateTime"},"USER"],[5,"datetime",2],null]},{"file":"/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":345,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->","args":["SELECT `url` FROM `oc_gpodder_subscriptions` WHERE (`subscribed` = :dcValue1) AND (`updated` > :dcValue2) AND (`user_id` = :dcValue3)",[true,{"__class__":"DateTime"},"USER"],[5,"datetime",2]]},{"file":"/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":281,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":294,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/nextcloud/lib/public/AppFramework/Db/QBMapper.php","line":336,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/nextcloud/apps/gpoddersync/lib/Db/SubscriptionChange/SubscriptionChangeMapper.php","line":66,"function":"findEntities","class":"OCP\\AppFramework\\Db\\QBMapper","type":"->","args":[{"__class__":"OC\\DB\\QueryBuilder\\QueryBuilder"}]},{"file":"/nextcloud/apps/gpoddersync/lib/Db/SubscriptionChange/SubscriptionChangeRepository.php","line":26,"function":"findAllSubscriptionState","class":"OCA\\GPodderSync\\Db\\SubscriptionChange\\SubscriptionChangeMapper","type":"->","args":[true,{"__class__":"DateTime"},"USER"]},{"file":"/nextcloud/apps/gpoddersync/lib/Controller/SubscriptionChangeController.php","line":60,"function":"findAllSubscribed","class":"OCA\\GPodderSync\\Db\\SubscriptionChange\\SubscriptionChangeRepository","type":"->","args":[{"__class__":"DateTime"},"USER"]},{"file":"/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":225,"function":"list","class":"OCA\\GPodderSync\\Controller\\SubscriptionChangeController","type":"->","args":[0]},{"file":"/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":133,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\GPodderSync\\Controller\\SubscriptionChangeController"},"list"]},{"file":"/nextcloud/lib/private/AppFramework/App.php","line":172,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\GPodderSync\\Controller\\SubscriptionChangeController"},"list"]},{"file":"/nextcloud/lib/private/Route/Router.php","line":298,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\GPodderSync\\Controller\\SubscriptionChangeController","list",{"__class__":"OC\\AppFramework\\DependencyInjection\\DIContainer"},["gpoddersync.subscription_change.list"]]},{"file":"/nextcloud/lib/base.php","line":1030,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/apps/gpoddersync/subscriptions"]},{"file":"/nextcloud/index.php","line":36,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","Line":92}}},"CustomMessage":"--"}}
{"reqId":"Y2lAtvopAWrAiuOsPpnvcAAAAAs","level":3,"time":"2022.11.07, 18:30:30","user":"USER","app":"index","method":"GET","url":"//index.php/apps/gpoddersync/subscriptions?since=0","message":"An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'Cloud.oc_gpodder_subscriptions' doesn't exist","userAgent":"AntennaPod/2.7.1","version":"24.0.7.1","exception":{"Exception":"OC\\DB\\Exceptions\\DbalException","Message":"An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'Cloud.oc_gpodder_subscriptions' doesn't exist","Code":1146,"Trace":[{"file":"/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":296,"function":"wrap","class":"OC\\DB\\Exceptions\\DbalException","type":"::","args":[{"__class__":"Doctrine\\DBAL\\Exception\\TableNotFoundException"}]},{"file":"/nextcloud/lib/public/AppFramework/Db/QBMapper.php","line":336,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/nextcloud/apps/gpoddersync/lib/Db/SubscriptionChange/SubscriptionChangeMapper.php","line":66,"function":"findEntities","class":"OCP\\AppFramework\\Db\\QBMapper","type":"->","args":[{"__class__":"OC\\DB\\QueryBuilder\\QueryBuilder"}]},{"file":"/nextcloud/apps/gpoddersync/lib/Db/SubscriptionChange/SubscriptionChangeRepository.php","line":26,"function":"findAllSubscriptionState","class":"OCA\\GPodderSync\\Db\\SubscriptionChange\\SubscriptionChangeMapper","type":"->","args":[true,{"__class__":"DateTime"},"USER"]},{"file":"/nextcloud/apps/gpoddersync/lib/Controller/SubscriptionChangeController.php","line":60,"function":"findAllSubscribed","class":"OCA\\GPodderSync\\Db\\SubscriptionChange\\SubscriptionChangeRepository","type":"->","args":[{"__class__":"DateTime"},"USER"]},{"file":"/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":225,"function":"list","class":"OCA\\GPodderSync\\Controller\\SubscriptionChangeController","type":"->","args":[0]},{"file":"/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":133,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\GPodderSync\\Controller\\SubscriptionChangeController"},"list"]},{"file":"/nextcloud/lib/private/AppFramework/App.php","line":172,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\GPodderSync\\Controller\\SubscriptionChangeController"},"list"]},{"file":"/nextcloud/lib/private/Route/Router.php","line":298,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\GPodderSync\\Controller\\SubscriptionChangeController","list",{"__class__":"OC\\AppFramework\\DependencyInjection\\DIContainer"},["gpoddersync.subscription_change.list"]]},{"file":"/nextcloud/lib/base.php","line":1030,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/apps/gpoddersync/subscriptions"]},{"file":"/nextcloud/index.php","line":36,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/nextcloud/lib/private/DB/Exceptions/DbalException.php","Line":71,"Previous":{"Exception":"Doctrine\\DBAL\\Exception\\TableNotFoundException","Message":"An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'Cloud.oc_gpodder_subscriptions' doesn't exist","Code":1146,"Trace":[{"file":"/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1780,"function":"convert","class":"Doctrine\\DBAL\\Driver\\API\\MySQL\\ExceptionConverter","type":"->","args":[{"__class__":"Doctrine\\DBAL\\Driver\\PDO\\Exception"},{"__class__":"Doctrine\\DBAL\\Query"}]},{"file":"/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1719,"function":"handleDriverException","class":"Doctrine\\DBAL\\Connection","type":"->","args":[{"__class__":"Doctrine\\DBAL\\Driver\\PDO\\Exception"},{"__class__":"Doctrine\\DBAL\\Query"}]},{"file":"/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1067,"function":"convertExceptionDuringQuery","class":"Doctrine\\DBAL\\Connection","type":"->","args":[{"__class__":"Doctrine\\DBAL\\Driver\\PDO\\Exception"},"SELECT `url` FROM `oc_gpodder_subscriptions` WHERE (`subscribed` = ?) AND (`updated` > ?) AND (`user_id` = ?)",[true,{"__class__":"DateTime"},"USER"],[5,"datetime",2]]},{"file":"/nextcloud/lib/private/DB/Connection.php","line":261,"function":"executeQuery","class":"Doctrine\\DBAL\\Connection","type":"->","args":["SELECT `url` FROM `oc_gpodder_subscriptions` WHERE (`subscribed` = ?) AND (`updated` > ?) AND (`user_id` = ?)",[true,{"__class__":"DateTime"},"USER"],[5,"datetime",2],null]},{"file":"/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":345,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->","args":["SELECT `url` FROM `oc_gpodder_subscriptions` WHERE (`subscribed` = :dcValue1) AND (`updated` > :dcValue2) AND (`user_id` = :dcValue3)",[true,{"__class__":"DateTime"},"USER"],[5,"datetime",2]]},{"file":"/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":281,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":294,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/nextcloud/lib/public/AppFramework/Db/QBMapper.php","line":336,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/nextcloud/apps/gpoddersync/lib/Db/SubscriptionChange/SubscriptionChangeMapper.php","line":66,"function":"findEntities","class":"OCP\\AppFramework\\Db\\QBMapper","type":"->","args":[{"__class__":"OC\\DB\\QueryBuilder\\QueryBuilder"}]},{"file":"/nextcloud/apps/gpoddersync/lib/Db/SubscriptionChange/SubscriptionChangeRepository.php","line":26,"function":"findAllSubscriptionState","class":"OCA\\GPodderSync\\Db\\SubscriptionChange\\SubscriptionChangeMapper","type":"->","args":[true,{"__class__":"DateTime"},"USER"]},{"file":"/nextcloud/apps/gpoddersync/lib/Controller/SubscriptionChangeController.php","line":60,"function":"findAllSubscribed","class":"OCA\\GPodderSync\\Db\\SubscriptionChange\\SubscriptionChangeRepository","type":"->","args":[{"__class__":"DateTime"},"USER"]},{"file":"/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":225,"function":"list","class":"OCA\\GPodderSync\\Controller\\SubscriptionChangeController","type":"->","args":[0]},{"file":"/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":133,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\GPodderSync\\Controller\\SubscriptionChangeController"},"list"]},{"file":"/nextcloud/lib/private/AppFramework/App.php","line":172,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\GPodderSync\\Controller\\SubscriptionChangeController"},"list"]},{"file":"/nextcloud/lib/private/Route/Router.php","line":298,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\GPodderSync\\Controller\\SubscriptionChangeController","list",{"__class__":"OC\\AppFramework\\DependencyInjection\\DIContainer"},["gpoddersync.subscription_change.list"]]},{"file":"/nextcloud/lib/base.php","line":1030,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/apps/gpoddersync/subscriptions"]},{"file":"/nextcloud/index.php","line":36,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/nextcloud/3rdparty/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php","Line":47,"Previous":{"Exception":"Doctrine\\DBAL\\Driver\\PDO\\Exception","Message":"SQLSTATE[42S02]: Base table or view not found: 1146 Table 'Cloud.oc_gpodder_subscriptions' doesn't exist","Code":1146,"Trace":[{"file":"/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","line":94,"function":"new","class":"Doctrine\\DBAL\\Driver\\PDO\\Exception","type":"::","args":[{"__class__":"PDOException","errorInfo":["42S02",1146,"Table 'Cloud.oc_gpodder_subscriptions' doesn't exist"]}]},{"file":"/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1057,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDO\\Statement","type":"->","args":[]},{"file":"/nextcloud/lib/private/DB/Connection.php","line":261,"function":"executeQuery","class":"Doctrine\\DBAL\\Connection","type":"->","args":["SELECT `url` FROM `oc_gpodder_subscriptions` WHERE (`subscribed` = ?) AND (`updated` > ?) AND (`user_id` = ?)",[true,{"__class__":"DateTime"},"USER"],[5,"datetime",2],null]},{"file":"/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":345,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->","args":["SELECT `url` FROM `oc_gpodder_subscriptions` WHERE (`subscribed` = :dcValue1) AND (`updated` > :dcValue2) AND (`user_id` = :dcValue3)",[true,{"__class__":"DateTime"},"USER"],[5,"datetime",2]]},{"file":"/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":281,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":294,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/nextcloud/lib/public/AppFramework/Db/QBMapper.php","line":336,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/nextcloud/apps/gpoddersync/lib/Db/SubscriptionChange/SubscriptionChangeMapper.php","line":66,"function":"findEntities","class":"OCP\\AppFramework\\Db\\QBMapper","type":"->","args":[{"__class__":"OC\\DB\\QueryBuilder\\QueryBuilder"}]},{"file":"/nextcloud/apps/gpoddersync/lib/Db/SubscriptionChange/SubscriptionChangeRepository.php","line":26,"function":"findAllSubscriptionState","class":"OCA\\GPodderSync\\Db\\SubscriptionChange\\SubscriptionChangeMapper","type":"->","args":[true,{"__class__":"DateTime"},"USER"]},{"file":"/nextcloud/apps/gpoddersync/lib/Controller/SubscriptionChangeController.php","line":60,"function":"findAllSubscribed","class":"OCA\\GPodderSync\\Db\\SubscriptionChange\\SubscriptionChangeRepository","type":"->","args":[{"__class__":"DateTime"},"USER"]},{"file":"/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":225,"function":"list","class":"OCA\\GPodderSync\\Controller\\SubscriptionChangeController","type":"->","args":[0]},{"file":"/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":133,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\GPodderSync\\Controller\\SubscriptionChangeController"},"list"]},{"file":"/nextcloud/lib/private/AppFramework/App.php","line":172,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\GPodderSync\\Controller\\SubscriptionChangeController"},"list"]},{"file":"/nextcloud/lib/private/Route/Router.php","line":298,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\GPodderSync\\Controller\\SubscriptionChangeController","list",{"__class__":"OC\\AppFramework\\DependencyInjection\\DIContainer"},["gpoddersync.subscription_change.list"]]},{"file":"/nextcloud/lib/base.php","line":1030,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/apps/gpoddersync/subscriptions"]},{"file":"/nextcloud/index.php","line":36,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php","Line":26,"Previous":{"Exception":"PDOException","Message":"SQLSTATE[42S02]: Base table or view not found: 1146 Table 'Cloud.oc_gpodder_subscriptions' doesn't exist","Code":"42S02","Trace":[{"file":"/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","line":92,"function":"execute","class":"PDOStatement","type":"->","args":[null]},{"file":"/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1057,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDO\\Statement","type":"->","args":[]},{"file":"/nextcloud/lib/private/DB/Connection.php","line":261,"function":"executeQuery","class":"Doctrine\\DBAL\\Connection","type":"->","args":["SELECT `url` FROM `oc_gpodder_subscriptions` WHERE (`subscribed` = ?) AND (`updated` > ?) AND (`user_id` = ?)",[true,{"__class__":"DateTime"},"USER"],[5,"datetime",2],null]},{"file":"/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":345,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->","args":["SELECT `url` FROM `oc_gpodder_subscriptions` WHERE (`subscribed` = :dcValue1) AND (`updated` > :dcValue2) AND (`user_id` = :dcValue3)",[true,{"__class__":"DateTime"},"USER"],[5,"datetime",2]]},{"file":"/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":281,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":294,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/nextcloud/lib/public/AppFramework/Db/QBMapper.php","line":336,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/nextcloud/apps/gpoddersync/lib/Db/SubscriptionChange/SubscriptionChangeMapper.php","line":66,"function":"findEntities","class":"OCP\\AppFramework\\Db\\QBMapper","type":"->","args":[{"__class__":"OC\\DB\\QueryBuilder\\QueryBuilder"}]},{"file":"/nextcloud/apps/gpoddersync/lib/Db/SubscriptionChange/SubscriptionChangeRepository.php","line":26,"function":"findAllSubscriptionState","class":"OCA\\GPodderSync\\Db\\SubscriptionChange\\SubscriptionChangeMapper","type":"->","args":[true,{"__class__":"DateTime"},"USER"]},{"file":"/nextcloud/apps/gpoddersync/lib/Controller/SubscriptionChangeController.php","line":60,"function":"findAllSubscribed","class":"OCA\\GPodderSync\\Db\\SubscriptionChange\\SubscriptionChangeRepository","type":"->","args":[{"__class__":"DateTime"},"USER"]},{"file":"/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":225,"function":"list","class":"OCA\\GPodderSync\\Controller\\SubscriptionChangeController","type":"->","args":[0]},{"file":"/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":133,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\GPodderSync\\Controller\\SubscriptionChangeController"},"list"]},{"file":"/nextcloud/lib/private/AppFramework/App.php","line":172,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\GPodderSync\\Controller\\SubscriptionChangeController"},"list"]},{"file":"/nextcloud/lib/private/Route/Router.php","line":298,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\GPodderSync\\Controller\\SubscriptionChangeController","list",{"__class__":"OC\\AppFramework\\DependencyInjection\\DIContainer"},["gpoddersync.subscription_change.list"]]},{"file":"/nextcloud/lib/base.php","line":1030,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/apps/gpoddersync/subscriptions"]},{"file":"/nextcloud/index.php","line":36,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","Line":92}}},"CustomMessage":"--"}}

Nov 07 '22 17:11 Mannshoch

It looks like the table oc_gpodder_subscriptions is missing. Did you alter your database manually recently?

Nov 07 '22 21:11 JonOfUs

Yes. -> https://github.com/thrillfall/nextcloud-gpodder/issues/81#issuecomment-1179727890 I'm not sure if i removed more than `oc_gpodder_episode_action`` I after that removed gpodder completely and now reinstalled it again.

Nov 08 '22 16:11 Mannshoch

Yes. -> https://github.com/thrillfall/nextcloud-gpodder/issues/81#issuecomment-1179727890 I'm not sure if i removed more than `oc_gpodder_episode_action`` I after that removed gpodder completely and now reinstalled it again.

Hmm, looks like you removed not only the contents of oc_gpodder_episode_action but also the whole table oc_gpodder_subscriptions. Restoring it is not very easy, sadly.

Best way to restore the table is to restore a backup.

Another possibility (without guarantees): I didn't test this, but another user managed to completely remove everything from gpoddersync from his Nextcloud: https://github.com/thrillfall/nextcloud-gpodder/issues/94#issuecomment-1273992608 (use nextcloud references your db's name, if your db is named nextcloud_db, type use nextcloud_db) You could try this and then install it again. Since the mentioned commands should clear all data of gpoddersync, reinstalling should also create the necessary tables like oc_gpodder_subscription, since Nextcloud has no data of previous installations of the app. But again, I didn't test this and don't know for sure whether this works, definitely backup before. Or just restore from a backup where the table is not yet deleted.

Nov 08 '22 20:11 JonOfUs

deactivate -> uninstall -> reinstall do not work.

{"reqId":"Y2vO3BolORvpVyyYpOoDUwAAACw","level":3,"time":"2022.11.09, 17:01:32","user":"USER","app":"index","method":"GET","url":"//index.php/apps/gpoddersync/subscriptions?since=0","message":"An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'Cloud.oc_gpodder_subscriptions' doesn't exist","userAgent":"AntennaPod/2.7.1","version":"24.0.7.1","exception":{"Exception":"OC\\DB\\Exceptions\\DbalException","Message":"An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'Cloud.oc_gpodder_subscriptions' doesn't exist","Code":1146,"Trace":[{"file":"/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":296,"function":"wrap","class":"OC\\DB\\Exceptions\\DbalException","type":"::","args":[{"__class__":"Doctrine\\DBAL\\Exception\\TableNotFoundException"}]},{"file":"/nextcloud/lib/public/AppFramework/Db/QBMapper.php","line":336,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/nextcloud/apps/gpoddersync/lib/Db/SubscriptionChange/SubscriptionChangeMapper.php","line":66,"function":"findEntities","class":"OCP\\AppFramework\\Db\\QBMapper","type":"->","args":[{"__class__":"OC\\DB\\QueryBuilder\\QueryBuilder"}]},{"file":"/nextcloud/apps/gpoddersync/lib/Db/SubscriptionChange/SubscriptionChangeRepository.php","line":26,"function":"findAllSubscriptionState","class":"OCA\\GPodderSync\\Db\\SubscriptionChange\\SubscriptionChangeMapper","type":"->","args":[true,{"__class__":"DateTime"},"USER"]},{"file":"/nextcloud/apps/gpoddersync/lib/Controller/SubscriptionChangeController.php","line":60,"function":"findAllSubscribed","class":"OCA\\GPodderSync\\Db\\SubscriptionChange\\SubscriptionChangeRepository","type":"->","args":[{"__class__":"DateTime"},"USER"]},{"file":"/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":225,"function":"list","class":"OCA\\GPodderSync\\Controller\\SubscriptionChangeController","type":"->","args":[0]},{"file":"/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":133,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\GPodderSync\\Controller\\SubscriptionChangeController"},"list"]},{"file":"/nextcloud/lib/private/AppFramework/App.php","line":172,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\GPodderSync\\Controller\\SubscriptionChangeController"},"list"]},{"file":"/nextcloud/lib/private/Route/Router.php","line":298,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\GPodderSync\\Controller\\SubscriptionChangeController","list",{"__class__":"OC\\AppFramework\\DependencyInjection\\DIContainer"},["gpoddersync.subscription_change.list"]]},{"file":"/nextcloud/lib/base.php","line":1030,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/apps/gpoddersync/subscriptions"]},{"file":"/nextcloud/index.php","line":36,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/nextcloud/lib/private/DB/Exceptions/DbalException.php","Line":71,"Previous":{"Exception":"Doctrine\\DBAL\\Exception\\TableNotFoundException","Message":"An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'Cloud.oc_gpodder_subscriptions' doesn't exist","Code":1146,"Trace":[{"file":"/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1780,"function":"convert","class":"Doctrine\\DBAL\\Driver\\API\\MySQL\\ExceptionConverter","type":"->","args":[{"__class__":"Doctrine\\DBAL\\Driver\\PDO\\Exception"},{"__class__":"Doctrine\\DBAL\\Query"}]},{"file":"/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1719,"function":"handleDriverException","class":"Doctrine\\DBAL\\Connection","type":"->","args":[{"__class__":"Doctrine\\DBAL\\Driver\\PDO\\Exception"},{"__class__":"Doctrine\\DBAL\\Query"}]},{"file":"/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1067,"function":"convertExceptionDuringQuery","class":"Doctrine\\DBAL\\Connection","type":"->","args":[{"__class__":"Doctrine\\DBAL\\Driver\\PDO\\Exception"},"SELECT `url` FROM `oc_gpodder_subscriptions` WHERE (`subscribed` = ?) AND (`updated` > ?) AND (`user_id` = ?)",[true,{"__class__":"DateTime"},"USER"],[5,"datetime",2]]},{"file":"/nextcloud/lib/private/DB/Connection.php","line":261,"function":"executeQuery","class":"Doctrine\\DBAL\\Connection","type":"->","args":["SELECT `url` FROM `oc_gpodder_subscriptions` WHERE (`subscribed` = ?) AND (`updated` > ?) AND (`user_id` = ?)",[true,{"__class__":"DateTime"},"USER"],[5,"datetime",2],null]},{"file":"/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":345,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->","args":["SELECT `url` FROM `oc_gpodder_subscriptions` WHERE (`subscribed` = :dcValue1) AND (`updated` > :dcValue2) AND (`user_id` = :dcValue3)",[true,{"__class__":"DateTime"},"USER"],[5,"datetime",2]]},{"file":"/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":281,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":294,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/nextcloud/lib/public/AppFramework/Db/QBMapper.php","line":336,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/nextcloud/apps/gpoddersync/lib/Db/SubscriptionChange/SubscriptionChangeMapper.php","line":66,"function":"findEntities","class":"OCP\\AppFramework\\Db\\QBMapper","type":"->","args":[{"__class__":"OC\\DB\\QueryBuilder\\QueryBuilder"}]},{"file":"/nextcloud/apps/gpoddersync/lib/Db/SubscriptionChange/SubscriptionChangeRepository.php","line":26,"function":"findAllSubscriptionState","class":"OCA\\GPodderSync\\Db\\SubscriptionChange\\SubscriptionChangeMapper","type":"->","args":[true,{"__class__":"DateTime"},"USER"]},{"file":"/nextcloud/apps/gpoddersync/lib/Controller/SubscriptionChangeController.php","line":60,"function":"findAllSubscribed","class":"OCA\\GPodderSync\\Db\\SubscriptionChange\\SubscriptionChangeRepository","type":"->","args":[{"__class__":"DateTime"},"USER"]},{"file":"/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":225,"function":"list","class":"OCA\\GPodderSync\\Controller\\SubscriptionChangeController","type":"->","args":[0]},{"file":"/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":133,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\GPodderSync\\Controller\\SubscriptionChangeController"},"list"]},{"file":"/nextcloud/lib/private/AppFramework/App.php","line":172,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\GPodderSync\\Controller\\SubscriptionChangeController"},"list"]},{"file":"/nextcloud/lib/private/Route/Router.php","line":298,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\GPodderSync\\Controller\\SubscriptionChangeController","list",{"__class__":"OC\\AppFramework\\DependencyInjection\\DIContainer"},["gpoddersync.subscription_change.list"]]},{"file":"/nextcloud/lib/base.php","line":1030,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/apps/gpoddersync/subscriptions"]},{"file":"/nextcloud/index.php","line":36,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/nextcloud/3rdparty/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php","Line":47,"Previous":{"Exception":"Doctrine\\DBAL\\Driver\\PDO\\Exception","Message":"SQLSTATE[42S02]: Base table or view not found: 1146 Table 'Cloud.oc_gpodder_subscriptions' doesn't exist","Code":1146,"Trace":[{"file":"/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","line":94,"function":"new","class":"Doctrine\\DBAL\\Driver\\PDO\\Exception","type":"::","args":[{"__class__":"PDOException","errorInfo":["42S02",1146,"Table 'Cloud.oc_gpodder_subscriptions' doesn't exist"]}]},{"file":"/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1057,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDO\\Statement","type":"->","args":[]},{"file":"/nextcloud/lib/private/DB/Connection.php","line":261,"function":"executeQuery","class":"Doctrine\\DBAL\\Connection","type":"->","args":["SELECT `url` FROM `oc_gpodder_subscriptions` WHERE (`subscribed` = ?) AND (`updated` > ?) AND (`user_id` = ?)",[true,{"__class__":"DateTime"},"USER"],[5,"datetime",2],null]},{"file":"/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":345,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->","args":["SELECT `url` FROM `oc_gpodder_subscriptions` WHERE (`subscribed` = :dcValue1) AND (`updated` > :dcValue2) AND (`user_id` = :dcValue3)",[true,{"__class__":"DateTime"},"USER"],[5,"datetime",2]]},{"file":"/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":281,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":294,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/nextcloud/lib/public/AppFramework/Db/QBMapper.php","line":336,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/nextcloud/apps/gpoddersync/lib/Db/SubscriptionChange/SubscriptionChangeMapper.php","line":66,"function":"findEntities","class":"OCP\\AppFramework\\Db\\QBMapper","type":"->","args":[{"__class__":"OC\\DB\\QueryBuilder\\QueryBuilder"}]},{"file":"/nextcloud/apps/gpoddersync/lib/Db/SubscriptionChange/SubscriptionChangeRepository.php","line":26,"function":"findAllSubscriptionState","class":"OCA\\GPodderSync\\Db\\SubscriptionChange\\SubscriptionChangeMapper","type":"->","args":[true,{"__class__":"DateTime"},"USER"]},{"file":"/nextcloud/apps/gpoddersync/lib/Controller/SubscriptionChangeController.php","line":60,"function":"findAllSubscribed","class":"OCA\\GPodderSync\\Db\\SubscriptionChange\\SubscriptionChangeRepository","type":"->","args":[{"__class__":"DateTime"},"USER"]},{"file":"/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":225,"function":"list","class":"OCA\\GPodderSync\\Controller\\SubscriptionChangeController","type":"->","args":[0]},{"file":"/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":133,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\GPodderSync\\Controller\\SubscriptionChangeController"},"list"]},{"file":"/nextcloud/lib/private/AppFramework/App.php","line":172,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\GPodderSync\\Controller\\SubscriptionChangeController"},"list"]},{"file":"/nextcloud/lib/private/Route/Router.php","line":298,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\GPodderSync\\Controller\\SubscriptionChangeController","list",{"__class__":"OC\\AppFramework\\DependencyInjection\\DIContainer"},["gpoddersync.subscription_change.list"]]},{"file":"/nextcloud/lib/base.php","line":1030,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/apps/gpoddersync/subscriptions"]},{"file":"/nextcloud/index.php","line":36,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php","Line":26,"Previous":{"Exception":"PDOException","Message":"SQLSTATE[42S02]: Base table or view not found: 1146 Table 'Cloud.oc_gpodder_subscriptions' doesn't exist","Code":"42S02","Trace":[{"file":"/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","line":92,"function":"execute","class":"PDOStatement","type":"->","args":[null]},{"file":"/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1057,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDO\\Statement","type":"->","args":[]},{"file":"/nextcloud/lib/private/DB/Connection.php","line":261,"function":"executeQuery","class":"Doctrine\\DBAL\\Connection","type":"->","args":["SELECT `url` FROM `oc_gpodder_subscriptions` WHERE (`subscribed` = ?) AND (`updated` > ?) AND (`user_id` = ?)",[true,{"__class__":"DateTime"},"USER"],[5,"datetime",2],null]},{"file":"/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":345,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->","args":["SELECT `url` FROM `oc_gpodder_subscriptions` WHERE (`subscribed` = :dcValue1) AND (`updated` > :dcValue2) AND (`user_id` = :dcValue3)",[true,{"__class__":"DateTime"},"USER"],[5,"datetime",2]]},{"file":"/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":281,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":294,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/nextcloud/lib/public/AppFramework/Db/QBMapper.php","line":336,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/nextcloud/apps/gpoddersync/lib/Db/SubscriptionChange/SubscriptionChangeMapper.php","line":66,"function":"findEntities","class":"OCP\\AppFramework\\Db\\QBMapper","type":"->","args":[{"__class__":"OC\\DB\\QueryBuilder\\QueryBuilder"}]},{"file":"/nextcloud/apps/gpoddersync/lib/Db/SubscriptionChange/SubscriptionChangeRepository.php","line":26,"function":"findAllSubscriptionState","class":"OCA\\GPodderSync\\Db\\SubscriptionChange\\SubscriptionChangeMapper","type":"->","args":[true,{"__class__":"DateTime"},"USER"]},{"file":"/nextcloud/apps/gpoddersync/lib/Controller/SubscriptionChangeController.php","line":60,"function":"findAllSubscribed","class":"OCA\\GPodderSync\\Db\\SubscriptionChange\\SubscriptionChangeRepository","type":"->","args":[{"__class__":"DateTime"},"USER"]},{"file":"/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":225,"function":"list","class":"OCA\\GPodderSync\\Controller\\SubscriptionChangeController","type":"->","args":[0]},{"file":"/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":133,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\GPodderSync\\Controller\\SubscriptionChangeController"},"list"]},{"file":"/nextcloud/lib/private/AppFramework/App.php","line":172,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\GPodderSync\\Controller\\SubscriptionChangeController"},"list"]},{"file":"/nextcloud/lib/private/Route/Router.php","line":298,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\GPodderSync\\Controller\\SubscriptionChangeController","list",{"__class__":"OC\\AppFramework\\DependencyInjection\\DIContainer"},["gpoddersync.subscription_change.list"]]},{"file":"/nextcloud/lib/base.php","line":1030,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/apps/gpoddersync/subscriptions"]},{"file":"/nextcloud/index.php","line":36,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","Line":92}}},"CustomMessage":"--"}}

Nov 09 '22 16:11 Mannshoch

Yes, this won't work, since you deleted the table oc_gpodder_subscriptions. This isn't restored from just reinstalling. Your options are to do one of the following:

restore the table (by restoring only this table or by restoring your whole DB from backup)
also remove oc_gpodder_episode_action (if it is not yet removed), then remove gpoddersync associated appconfig and migrations (e.g. with the commands presented here: https://github.com/thrillfall/nextcloud-gpodder/issues/94#issuecomment-1273992608) and then reinstall the app

The first option definitely is the safer one and I can't guarantee that the second one will work at all (never tested it), but both of them are your best shot, I guess.

Nov 10 '22 21:11 JonOfUs

Uninstalled, removed, database cleaned. And waited for 3.7.1. Now after reinstalling everything works. thanks @JonOfUs

Nov 11 '22 13:11 Mannshoch

nextcloud-gpodder nextcloud-gpodder copied to clipboard

java.io.IOException: Response code: 500

nextcloud-gpodder
nextcloud-gpodder copied to clipboard