[Failed to import event]DB Error: UPDATE "events" in calendar

[luanapremoli]

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:

Code Select Expand

[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

Code Select Expand

[email protected] [roundcube]# grep '' /var/cpanel/roundcube/version
1.5.2.5-1.cp108~el7
[email protected] [roundcube]#

DB

Code Select Expand

[email protected] [roundcube]# grep roundcube  /var/cpanel/cpanel.config
roundcube_db=sqlite
skiproundcube=0
[email protected] [roundcube]#

The cPanel version

Code Select Expand

[email protected] [roundcube]# grep '' /usr/local/cpanel/version
11.108.0.13
[email protected] [roundcube]#[code]


Can someone help me?

Thanks

[Dmitry42]

im not sure but it looks like problem in part:

"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.