Hi..
I have a server with several domains and the error occurs with all.
If the
[email protected] email account sends an invitation to
[email protected], the event is added to the calendar correctly.
However, if the owner of the invitation (
[email protected]) changes the date/time of this event, when
[email protected] clicks on "Update in my calendar" an error is shown in the lower right part: Failed to import event
Error: In the log /home/USER-CPANEL/logs/roundcube/errors.log we can see the error:
[02-Mar-2023 17:23:48 -0300]: <14f58a19> DB Error: [1] near ",": syntax error (SQL Query: UPDATE "events" SET "changed" = datetime('now'), "start" = , "end" = , "all_day" = '0', "sequence" = '1', "title" = 'Teste HG1', "description" = '-::~:~::~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~::~:~::-
Entrar com o Google Meet: https://meet.google.com/bmg-hyec-wyz
Saiba mais sobre o Meet em: https://support.google.com/a/users/answer/9282720
Não edite esta seção.
-::~:~::~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~::~:~::-', "location" = '', "free_busy" = '1', "priority" = '0', "sensitivity" = NULL, "status" = 'CONFIRMED', "attendees" = '[{"name":"[email protected]","rsvp":false,"email":"[email protected]","role":"ORGANIZER","status":"ACCEPTED"},{"name":"[email protected]","status":"NEEDS-ACTION","role":"REQ-PARTICIPANT","cutype":"INDIVIDUAL","email":"[email protected]"},{"name":"[email protected]","status":"ACCEPTED","role":"REQ-PARTICIPANT","cutype":"INDIVIDUAL","rsvp":false,"email":"[email protected]"}]', "notifyat" = NULL WHERE "event_id" = '5' AND "calendar_id" IN ('1')) in /usr/local/cpanel/base/3rdparty/roundcube/program/lib/Roundcube/rcube_db.php on line 566 (POST /cpsess7374914100/3rdparty/roundcube/index.php?_task=calendar&_framed=1&_action=mailimportitip)
Roundcube's version
[email protected] [roundcube]# grep '' /var/cpanel/roundcube/version
1.5.2.5-1.cp108~el7
[email protected] [roundcube]#DB [email protected] [roundcube]# grep roundcube /var/cpanel/cpanel.config
roundcube_db=sqlite
skiproundcube=0
[email protected] [roundcube]#The cPanel version[email protected] [roundcube]# grep '' /usr/local/cpanel/version
11.108.0.13
[email protected] [roundcube]#[code]
Can someone help me?
Thanks
im not sure but it looks like problem in part:
Quote"description" = '-::~:~::~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~::~:~::-
Entrar com o Google Meet: https://meet.google.com/bmg-hyec-wyz
Saiba mais sobre o Meet em: https://support.google.com/a/users/answer/9282720
Não edite esta seção.
-::~:~::~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~::~:~::-',
I think it must be like "description" = 'some text'
So it looks like broken query test, so DB query broke transaction.