Skip to main content

Clear Roundcube Calendars

Comments

9 comments

  • cPRex Jurassic Moderator

    Hey there!  I'm not sure I have a good explanation for this one as the data in /home/account/domain/email.roundcube.db really should be the only location where Roundcube is storing information.  We may need to see a ticket on this one to get you better information on what may be happening.

    0
  • Servinformatica

    Hello.

    Thanks for the answer, I will try to expose the problem in more detail, because between the cpanel reseller and my technical team we do not find the solution.

    We have a specific calendar in Roundcube that does strange things. Other accounts within the same cPanel work without problems.

    What are these problems?

    For example, strange characters appear when importing a calendar, especially in the vowels with tilde and on the other hand, you can not delete these calendar entries. When we try to delete them from webmail or an external client, they reappear.

    Video: https://www.youtube.com/watch?v=tbUjXfBGgpE

    The next test we did is to delete the SQLite databases of that email stored in the path /home/user/domain/user.rcube.db*, deleting everything related to that user. Then we execute the command to regenerate the DB /usr/local/cpanel/bin/update-roundcube-sqlite-db and after a few seconds everything appears again in the webmail... as if everything was picked up from the cache or some other place.

    Any ideas?

    0
  • Servinformatica

    Errors logs say:

     

    Apr-2024 14:59:46 Europe/Madrid] PHP Warning:  Undefined array key "end" in /usr/local/cpanel/base/3rdparty/roundcube/plugins/libcalendaring/libvcalendar.php on line 738
    [16-Apr-2024 14:59:46 Europe/Madrid] PHP Warning:  Undefined array key "end" in /usr/local/cpanel/base/3rdparty/roundcube/plugins/libcalendaring/libvcalendar.php on line 738
    [16-Apr-2024 14:59:46 Europe/Madrid] PHP Warning:  Undefined array key "start" in /usr/local/cpanel/base/3rdparty/roundcube/plugins/libcalendaring/libvcalendar.php on line 738
    [16-Apr-2024 14:59:46 Europe/Madrid] PHP Warning:  Undefined array key "start" in /usr/local/cpanel/base/3rdparty/roundcube/plugins/libcalendaring/libvcalendar.php on line 738
    [16-Apr-2024 14:59:46 Europe/Madrid] PHP Warning:  Undefined array key "end" in /usr/local/cpanel/base/3rdparty/roundcube/plugins/libcalendaring/libvcalendar.php on line 738
    [16-Apr-2024 14:59:46 Europe/Madrid] PHP Warning:  Undefined array key "end" in /usr/local/cpanel/base/3rdparty/roundcube/plugins/libcalendaring/libvcalendar.php on line 738
    [16-Apr-2024 14:59:46 Europe/Madrid] PHP Warning:  Undefined array key "start" in /usr/local/cpanel/base/3rdparty/roundcube/plugins/libcalendaring/libvcalendar.php on line 738
    [16-Apr-2024 14:59:46 Europe/Madrid] PHP Warning:  Undefined array key "start" in /usr/local/cpanel/base/3rdparty/roundcube/plugins/libcalendaring/libvcalendar.php on line 738
    [16-Apr-2024 14:59:46 Europe/Madrid] PHP Warning:  Undefined array key "end" in /usr/local/cpanel/base/3rdparty/roundcube/plugins/libcalendaring/libvcalendar.php on line 738
    [16-Apr-2024 14:59:46 Europe/Madrid] PHP Warning:  Undefined array key "end" in /usr/local/cpanel/base/3rdparty/roundcube/plugins/libcalendaring/libvcalendar.php on line 738
    [16-Apr-2024 14:59:46 Europe/Madrid] PHP Warning:  Undefined array key "start" in /usr/local/cpanel/base/3rdparty/roundcube/plugins/libcalendaring/libvcalendar.php on line 738
    [16-Apr-2024 14:59:46 Europe/Madrid] PHP Warning:  Undefined array key "start" in /usr/local/cpanel/base/3rdparty/roundcube/plugins/libcalendaring/libvcalendar.php on line 738
    [16-Apr-2024 14:59:46 Europe/Madrid] PHP Warning:  Undefined array key "end" in /usr/local/cpanel/base/3rdparty/roundcube/plugins/libcalendaring/libvcalendar.php on line 738
    [16-Apr-2024 14:59:46 Europe/Madrid] PHP Warning:  Undefined array key "end" in /usr/local/cpanel/base/3rdparty/roundcube/plugins/libcalendaring/libvcalendar.php on line 738
    [16-Apr-2024 14:59:46 Europe/Madrid] PHP Warning:  Undefined array key "start" in /usr/local/cpanel/base/3rdparty/roundcube/plugins/libcalendaring/libvcalendar.php on line 738
    [16-Apr-2024 14:59:46 Europe/Madrid] PHP Warning:  Undefined array key "start" in /usr/local/cpanel/base/3rdparty/roundcube/plugins/libcalendaring/libvcalendar.php on line 738
    [16-Apr-2024 14:59:46 Europe/Madrid] PHP Warning:  Undefined array key "end" in /usr/local/cpanel/base/3rdparty/roundcube/plugins/libcalendaring/libvcalendar.php on line 738
    [16-Apr-2024 14:59:46 Europe/Madrid] PHP Warning:  Undefined array key "end" in /usr/local/cpanel/base/3rdparty/roundcube/plugins/libcalendaring/libvcalendar.php on line 738
    [16-Apr-2024 14:59:46 Europe/Madrid] PHP Warning:  Undefined array key "start" in /usr/local/cpanel/base/3rdparty/roundcube/plugins/libcalendaring/libvcalendar.php on line 738
    [16-Apr-2024 14:59:46 Europe/Madrid] PHP Warning:  Undefined array key "start" in /usr/local/cpanel/base/3rdparty/roundcube/plugins/libcalendaring/libvcalendar.php on line 738
    [16-Apr-2024 14:59:46 Europe/Madrid] PHP Warning:  Undefined array key "end" in /usr/local/cpanel/base/3rdparty/roundcube/plugins/libcalendaring/libvcalendar.php on line 738
    [16-Apr-2024 14:59:46 Europe/Madrid] PHP Warning:  Undefined array key "end" in /usr/local/cpanel/base/3rdparty/roundcube/plugins/libcalendaring/libvcalendar.php on line 738
    [16-Apr-2024 14:59:46 Europe/Madrid] PHP Warning:  Undefined array key "end" in /usr/local/cpanel/base/3rdparty/roundcube/plugins/libcalendaring/libvcalendar.php on line 738
    [16-Apr-2024 14:59:46 Europe/Madrid] PHP Warning:  Undefined array key "end" in /usr/local/cpanel/base/3rdparty/roundcube/plugins/libcalendaring/libvcalendar.php on line 738
    [16-Apr-2024 14:59:46 Europe/Madrid] PHP Warning:  Undefined array key "start" in /usr/local/cpanel/base/3rdparty/roundcube/plugins/libcalendaring/libvcalendar.php on line 738
    [16-Apr-2024 14:59:46 Europe/Madrid] PHP Warning:  Undefined array key "start" in /usr/local/cpanel/base/3rdparty/roundcube/plugins/libcalendaring/libvcalendar.php on line 738
    [16-Apr-2024 14:59:46 Europe/Madrid] PHP Warning:  Undefined array key "end" in /usr/local/cpanel/base/3rdparty/roundcube/plugins/libcalendaring/libvcalendar.php on line 738
    [16-Apr-2024 14:59:46 Europe/Madrid] PHP Warning:  Undefined array key "end" in /usr/local/cpanel/base/3rdparty/roundcube/plugins/libcalendaring/libvcalendar.php on line 738
    [16-Apr-2024 14:59:46 Europe/Madrid] PHP Warning:  Undefined array key "start" in /usr/local/cpanel/base/3rdparty/roundcube/plugins/libcalendaring/libvcalendar.php on line 738
    [16-Apr-2024 14:59:46 Europe/Madrid] PHP Warning:  Undefined array key "start" in /usr/local/cpanel/base/3rdparty/roundcube/plugins/libcalendaring/libvcalendar.php on line 738
    [16-Apr-2024 14:59:46 Europe/Madrid] PHP Warning:  Undefined array key "end" in /usr/local/cpanel/base/3rdparty/roundcube/plugins/libcalendaring/libvcalendar.php on line 738

     

    Apr-2024 15:04:10 Europe/Madrid] PHP Warning:  Undefined array key "role" in /usr/local/cpanel/base/3rdparty/roundcube/plugins/calendar/calendar.php on line 2263
    [16-Apr-2024 15:04:10 Europe/Madrid] PHP Warning:  Undefined array key "role" in /usr/local/cpanel/base/3rdparty/roundcube/plugins/calendar/calendar.php on line 2263
    [16-Apr-2024 15:04:10 Europe/Madrid] PHP Warning:  Undefined array key "role" in /usr/local/cpanel/base/3rdparty/roundcube/plugins/calendar/calendar.php on line 2263

     

    Apr-2024 15:05:57 Europe/Madrid] PHP Warning:  Undefined array key "status" in /usr/local/cpanel/base/3rdparty/roundcube/plugins/calendar/drivers/caldav/caldav_driver.php on line 1068
    [16-Apr-2024 15:05:57 Europe/Madrid] PHP Warning:  Undefined array key "status" in /usr/local/cpanel/base/3rdparty/roundcube/plugins/calendar/drivers/caldav/caldav_driver.php on line 1068
    [16-Apr-2024 15:05:57 Europe/Madrid] PHP Warning:  Undefined array key "status" in /usr/local/cpanel/base/3rdparty/roundcube/plugins/calendar/drivers/caldav/caldav_driver.php on line 1068
    [16-Apr-2024 15:05:57 Europe/Madrid] PHP Warning:  Undefined array key "status" in /usr/local/cpanel/base/3rdparty/roundcube/plugins/calendar/drivers/caldav/caldav_driver.php on line 1068
    [16-Apr-2024 15:05:57 Europe/Madrid] PHP Warning:  Undefined array key "status" in /usr/local/cpanel/base/3rdparty/roundcube/plugins/calendar/drivers/caldav/caldav_driver.php on line 1068

    0
  • Servinformatica

    Thank you for your response.

    The grace is that indicate that we delete these entries from the webmail but it is not possible. You can not delete and the truth is that this situation is disrupting all our operations with cpanel losing some customers who are leaving to Microsoft 365 and others who want us to migrate their infrastructure to Plesk ... is unfortunate.

    0
  • cPRex Jurassic Moderator

    We'll need to see a ticket on this issue to get you better details.  Could you submit one?

    0
  • Servinformatica

    My technical team is asking on the other hand how to migrate to the new calendars and contacts functionality of the 120.

    0
  • cPRex Jurassic Moderator

    There is nothing that needs to be done on the user end - cPanel moves everything into the new system automatically as part of the update to 120!

    0
  • Frank Andersen

    Hi, being end-user - have same problem, and difficult support from hosting provider, so created account to be able to contribute. Hope i'm forgiven if this conflicts with rules!

     

    I have been working on this for a while, based on same problem - that data is recreated.

    Not sure if this is the reason (have not tested yet) but browsing with ftp i find .ics data several places besides roundcube db itself. 

    X:/.cpanel/icals/*.*

    - looks a bit like an export / backup thing?

    X:/etc/domain.xyz/*.*

    - contains database itself

    X:/.caldav/mailuser@domain.xyz/*.*

    - contains the/a caldav version of data.... folder for addressbook, calendar, and any additional calendars created for user

    X:/.caldav/mailuser@domain.xyz/calendar/*.*

    - contains seemingly all calendar entries as individual .ics files <==== !!!!!!!!!!!!

     

    So: probably a delete of roundcube db file leads to recreation of empty db, and then automated import of .ics files from location above.

    Theory - not tested: to force empty calendar - delete all .ics files - and then the db files.

    ...going to try this in not to far future, as syching is really causing problems after some sort of recent cpanel upgrade.

     

    TIP:

    our problem is mainly caldav synchronizer to Outlook - and seems a FULL export from outlook, and full import into EMPTY (new testcalender created with that purpose) - creates a fully funtional and healthy roundcube db. 

     

    BR Frank

    0

Please sign in to leave a comment.