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

[bcutter]

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

• News app version: 2.0.2
• ownCloud version: 10.0.1.2
• PHP version: 5.6
• Database and version: MySQL 5.5.55
• Browser and version: not relevant
• Distribution and version: not relevant

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

[bcutter]

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]

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

[bcutter]

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

[BernhardPosselt]

No

[bcutter]

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

[BernhardPosselt]

No idea but at least someone will fix it

[bcutter]

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).