DB Error: [1] no such table: *_cache_dav_event

Symptoms

Roundcube calendars are not working, or creating a calendar event does not work, with a similar error logged to /home/CPANEL_USER/logs/roundcube/errors.log:

CONFIG_TEXT: [01-Dec-2024 18:49:30 +0100]: <4d3ec67f> DB Error: [1] no such table: kolab_cache_dav_event (SQL Query: SELECT * FROM "kolab_cache_dav_event" WHERE "folder_id" = '0' AND "dtstart" <= '2024-12-02 12:00:00' AND "dtend" >= '2024-11-24 12:00:00') in /usr/local/cpanel/base/3rdparty/roundcube/program/lib/Roundcube/rcube_db.php on line 577 (GET /cpsess4548679224/3rdparty/roundcube/index.php?_task=calendar&source=fdb2c103c05ae7a0aeab1ccb11aaf99d8&action=load_events&start=2024-11-25T00%3a00%3a00&end=2024-12-02T00%3a00%3a00&=1733075118628)

Cause

The Roundcube SQLite databases are missing one or more tables.

Solution

1. Log in to the server via SSH or WHM's Terminal as the root user

2. Run the following command:

   # /usr/local/cpanel/bin/update-roundcube-sqlite-db --foreground