Skip to main content

RoundCube saves to .ics file but event disappears then isn't dislplayed

FredQ
  • Edited

AlmaLinux v8.10.0 STANDARD standard
134.0.41

Just as per the title.

Events added via roundcube are saved to the .ics - see below. They are displayed in iCal and other client software - but NOT in roundcube.

on a newly created email account I've tried:

  • adding just one vanilla event 'test' to the new account - no special chars etc. - and it is saved as the only event to the .ics, but despite remaining in the .ics it disappears from roundcube on refresh and is not displayed
  • deleting all .ics files and re-adding just the one vanilla event - no special chars - same result
  • importing the .ics from a user's account which does display all events in roundcube - same result.

Here is the .ics with the one event:

BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Roundcube 1.6.16//Sabre VObject 4.5.8//EN
CALSCALE:GREGORIAN
BEGIN:VTIMEZONE
TZID:Europe/London
X-MICROSOFT-CDO-TZID:1
BEGIN:STANDARD
DTSTART:20251026T010000
TZOFFSETFROM:+0100
TZOFFSETTO:+0000
TZNAME:GMT
END:STANDARD
BEGIN:STANDARD
DTSTART:20261025T010000
TZOFFSETFROM:+0100
TZOFFSETTO:+0000
TZNAME:GMT
END:STANDARD
BEGIN:DAYLIGHT
DTSTART:20260329T010000
TZOFFSETFROM:+0000
TZOFFSETTO:+0100
TZNAME:BST
END:DAYLIGHT
END:VTIMEZONE
BEGIN:VEVENT
UID:6AF34AFD99D11F61D0EDB955E3B8EDCB-2BF898CCCBAB4616
DTSTAMP:20260630T132942Z
CREATED:20260630T132942Z
DTSTART;TZID=Europe/London:20260630T150000
DTEND;TZID=Europe/London:20260630T153000
SUMMARY:test
TRANSP:OPAQUE
ORGANIZER:mailto:name@domain.com
END:VEVENT
END:VCALENDAR

The roundcube error log seems to located at /home/accountname/logs/roundcube/errors.log. It is constantly throwing errors and is therefore quite large - 54Mb.

Here are the last few errors:

[30-Jun-2026 13:52:46 +0100]: <56d9f934> PHP Error: Failed to write to kolab cache (GET /cpsess6416586177/3rdparty/roundcube/index.php?_task=calendar&source=f250c7a438885db6b36383252063bc05a&_action=load_events&start=2026-06-29T00%3a00%3a00&end=2026-07-06T00%3a00%3a00&_=1782823963814)
[30-Jun-2026 13:52:46 +0100]: <56d9f934> DB Error: [1] no such table: kolab_cache_dav_event (SQL Query: INSERT INTO "kolab_cache_dav_event" ("folder_id", "uid", "etag", "created", "changed", "data", "tags", "words", "dtstart", "dtend") VALUES ('0', 'EFE68271-65DB-4A58-BA12-275BC1AF03F8', '1782823770', datetime('now'), '2026-06-02 07:38:31', '{"attendees":[{"rsvp":false,"email":"name@domain.com","role":"ORGANIZER","status":"ACCEPTED"}]}', ' x-has-alarms x-partstat:name@domain.com:accepted ', ' yvonne name@domain.com ', '2026-06-08 17:00:00', '2026-06-08 18:00:00')) in /usr/local/cpanel/base/3rdparty/roundcube/program/lib/Roundcube/rcube_db.php on line 577 (GET /cpsess6416586177/3rdparty/roundcube/index.php?_task=calendar&source=f250c7a438885db6b36383252063bc05a&_action=load_events&start=2026-06-29T00%3a00%3a00&end=2026-07-06T00%3a00%3a00&_=1782823963814)
[30-Jun-2026 13:52:46 +0100]: <56d9f934> PHP Error: Failed to write to kolab cache (GET /cpsess6416586177/3rdparty/roundcube/index.php?_task=calendar&source=f250c7a438885db6b36383252063bc05a&_action=load_events&start=2026-06-29T00%3a00%3a00&end=2026-07-06T00%3a00%3a00&_=1782823963814)
[30-Jun-2026 13:52:46 +0100]: <56d9f934> DB Error: [1] no such table: kolab_cache_dav_event (SQL Query: SELECT * FROM "kolab_cache_dav_event" WHERE "folder_id" = '0' AND "dtstart" <= '2026-07-06 12:00:00' AND "dtend" >= '2026-06-28 12:00:00') in /usr/local/cpanel/base/3rdparty/roundcube/program/lib/Roundcube/rcube_db.php on line 577 (GET /cpsess6416586177/3rdparty/roundcube/index.php?_task=calendar&source=f250c7a438885db6b36383252063bc05a&_action=load_events&start=2026-06-29T00%3a00%3a00&end=2026-07-06T00%3a00%3a00&_=1782823963814)
[30-Jun-2026 13:55:35 +0100]: <d5aea522> DB Error: [1] no such table: kolab_alarms (SQL Query: SELECT * FROM "kolab_alarms" WHERE "alarm_id" IN ('8c168e007b42ab14-20260703T100000','92db4616b35bbfb4','f4d70f1857ae2003-20260704T140000','8f6dbec8fef9f8a1','c6b42d6199fb31b4','8251c45db0abd43b','270ed51696af4d92','d08928b798754e85-20260712T114500') AND "user_id" = '13') in /usr/local/cpanel/base/3rdparty/roundcube/program/lib/Roundcube/rcube_db.php on line 577 (POST /cpsess2188330187/3rdparty/roundcube/index.php?_task=calendar&_action=refresh)
[30-Jun-2026 14:00:37 +0100]: <d5aea522> DB Error: [1] no such table: kolab_alarms (SQL Query: SELECT * FROM "kolab_alarms" WHERE "alarm_id" IN ('8c168e007b42ab14-20260703T100000','92db4616b35bbfb4','f4d70f1857ae2003-20260704T140000','8f6dbec8fef9f8a1','c6b42d6199fb31b4','8251c45db0abd43b','270ed51696af4d92','d08928b798754e85-20260712T114500') AND "user_id" = '13') in /usr/local/cpanel/base/3rdparty/roundcube/program/lib/Roundcube/rcube_db.php on line 577 (POST /cpsess2188330187/3rdparty/roundcube/index.php?_task=calendar&_action=refresh)
[30-Jun-2026 14:05:39 +0100]: <d5aea522> DB Error: [1] no such table: kolab_alarms (SQL Query: SELECT * FROM "kolab_alarms" WHERE "alarm_id" IN ('8c168e007b42ab14-20260703T100000','92db4616b35bbfb4','f4d70f1857ae2003-20260704T140000','8f6dbec8fef9f8a1','c6b42d6199fb31b4','8251c45db0abd43b','270ed51696af4d92','d08928b798754e85-20260712T114500') AND "user_id" = '13') in /usr/local/cpanel/base/3rdparty/roundcube/program/lib/Roundcube/rcube_db.php on line 577 (POST /cpsess2188330187/3rdparty/roundcube/index.php?_task=calendar&_action=refresh)
[30-Jun-2026 14:10:41 +0100]: <d5aea522> DB Error: [1] no such table: kolab_alarms (SQL Query: SELECT * FROM "kolab_alarms" WHERE "alarm_id" IN ('8c168e007b42ab14-20260703T100000','92db4616b35bbfb4','f4d70f1857ae2003-20260704T140000','c6b42d6199fb31b4','8251c45db0abd43b','270ed51696af4d92','d08928b798754e85-20260712T114500') AND "user_id" = '13') in /usr/local/cpanel/base/3rdparty/roundcube/program/lib/Roundcube/rcube_db.php on line 577 (POST /cpsess2188330187/3rdparty/roundcube/index.php?_task=calendar&_action=refresh)
[30-Jun-2026 14:15:43 +0100]: <d5aea522> DB Error: [1] no such table: kolab_alarms (SQL Query: SELECT * FROM "kolab_alarms" WHERE "alarm_id" IN ('8c168e007b42ab14-20260703T100000','92db4616b35bbfb4','f4d70f1857ae2003-20260704T140000','c6b42d6199fb31b4','8251c45db0abd43b','270ed51696af4d92','d08928b798754e85-20260712T114500') AND "user_id" = '13') in /usr/local/cpanel/base/3rdparty/roundcube/program/lib/Roundcube/rcube_db.php on line 577 (POST /cpsess2188330187/3rdparty/roundcube/index.php?_task=calendar&_action=refresh)
[30-Jun-2026 14:20:47 +0100]: <d5aea522> DB Error: [1] no such table: kolab_alarms (SQL Query: SELECT * FROM "kolab_alarms" WHERE "alarm_id" IN ('8c168e007b42ab14-20260703T100000','92db4616b35bbfb4','f4d70f1857ae2003-20260704T140000','c6b42d6199fb31b4','8251c45db0abd43b','270ed51696af4d92','d08928b798754e85-20260712T114500') AND "user_id" = '13') in /usr/local/cpanel/base/3rdparty/roundcube/program/lib/Roundcube/rcube_db.php on line 577 (POST /cpsess2188330187/3rdparty/roundcube/index.php?_task=calendar&_action=refresh)

Comments

3 comments

Date Votes
  • cPRex Jurassic Moderator

    Hey there!  This error typically means that there is a problem with the table structure in the Roundcube database.  Can you try running this to see if that takes care of things?

    /usr/local/cpanel/bin/update-roundcube-sqlite-db --foreground
    0
  • FredQ

    Thank you Rex, that seems to have worked. Roundcube is now actually displaying events.

    However, a couple of issues:

    1. the update of Roundcube has restored the 'WebMail Home' link in the navigation which we had previously suppressed via the $config['plugins'> = array(. Pls can you confirm the new way to remove the 'WebMail Home' link? and
    2. In Roundcube there's a 'Default' calendar which just gets in the way - can this be deleted or it's display suppressed?
    0
  • cPRex Jurassic Moderator

    For issue #1, I would expect all future cPanel updates to restore that link, as that isn't an area that we allow to be customized.  The best option would likely be to create a feature request if you'd like to see an official way to keep that option removed from the interface.  You could likely workaround it with a post-upcp script, but that is never an elegant solution.

    For #2, unfortunately there is not a way to remove this calendar.  

    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post