search

owncloud-archive / news

:newspaper: News app for ownCloud
GNU Affero General Public License v3.0
290 stars 106 forks source link

"OCP\AppFramework\Db\DoesNotExistException" when no (unread) articles exist #1028

Open bcutter opened 7 years ago

bcutter commented 7 years ago

Explain the Problem

OwnCloud log shows Error index OCP\AppFramework\Db\DoesNotExistException: Did expect one result but found none when executing: query "SELECT `items`.* FROM `*PREFIX*news_items` `items` JOIN `*PREFIX*news_feeds` `feeds` ON `feeds`.`id` = `items`.`feed_id` AND `feeds`.`deleted_at` = 0 AND `feeds`.`user_id` = ? AND `items`.`id` = ? LEFT OUTER JOIN `*PREFIX*news_folders` `folders` ON `folders`.`id` = `feeds`.`folder_id` WHERE `feeds`.`folder_id` = 0 OR `folders`.`deleted_at` = 0 ORDER BY `items`.`id` DESC"; parameters Array ( [0] => Username [1] => 13490 ) ; limit ""; offset ""

Steps to Reproduce

Sync feeds with iOS app "CloudNews". This results in above pasted error.

System Information

What does the error log entry want to let me know? That SQL statement is too much for my basic SQL knowledge :-(

bcutter commented 7 years ago

Update: It seems this message is NOT relevant to an empty set of articles. I need to revert that. I made some more tests and the log entry exists whenever updating feeds with the iOS app "CloudNews" (which currently is the only one supporting OwnCloud News app). Therefore I updated the description and issue title.

Would be good to know what the error is for - so I can consult the developer of the iOS app (even I´m currently not 100% sure the app is the root cause).

BernhardPosselt commented 7 years ago

You need to switch to nextcloud the owncloud version is unmaintained fyi

bcutter commented 7 years ago

Can the the NextCloud version of the news app be run under OwnCloud?

BernhardPosselt commented 7 years ago

No

bcutter commented 7 years ago

So this issue doesn´t exist (anymore) in the NextCloud news app?

BernhardPosselt commented 7 years ago

No idea but at least someone will fix it

bcutter commented 7 years ago

Good point. Will update this issue so anybody else looking for this will be forwarded to the nextcloud news app issue (if it even exists in that app).