Unable to view activity after install Announcement Center

ℹ️ Support
1

I have just installed the new Announcement Center 2.0.0 Final and am unable to view the activity. When I check the nextcloud.log I notice:

An exception occurred while executing 'SELECT * FROMnc_announcements_groupsWHEREannouncement_idIN (?)' with params [1]:\\n\\nSQLSTATE[42S02]: Base table or view not found: 1146 Table 'nextcloud.nc_announcements_groups' doesn't exist

Not sure if I missed a step installing the Announcement Center.

2

Sounds like the database update of the announcement center app was not executed.

To retry that, you can run the following SQL query:

UPDATE `nc_appconfig`
SET `configvalue` = '0.0.0'
WHERE `configkey` = 'installed_version'
    AND `appid` = 'announcementcenter';

That should retrigger the update and then create the new announcements_groups table.

3

It seems that resolved it :slight_smile: thanks.

The way I installed it was:

  1. Download package
  2. Unzip package
  3. Move folder to /var/www/nextcloud/apps
  4. chmod -R www-data:www-data /var/www/nextcloud/apps/announcementcenter
  5. Login as Admin
  6. Enable Announcement Center