Recreate app DB in SQL

Hi,
I encountered the exact same problem as you. A issue on the github repo seems to have a solution: After reset, News App is not working · Issue #838 · nextcloud/news · GitHub.
Perform the following steps:

  1. Disable and remove news app
  2. Remove all settings in the db: DELETE FROM oc_appconfig WHERE appid = ‘news’;
  3. Remove all migrations in the db: DELETE FROM oc_migrations WHERE app = ‘news’;
  4. Reinstall and Enable news app.

Caution: Please be careful when tinkering with the db and always perform a backup beforehand.

2 Likes