[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 example@gmail.com email account sends an invitation to example@domain.com, the event is added to the calendar correctly.
However, if the owner of the invitation (example@gmail.com) changes the date/time of this event, when example@domain.com 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]

[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":"exemple@gmail.com","rsvp":false,"email":"exemple@gmail.com","role":"ORGANIZER","status":"ACCEPTED"},{"name":"example@domain.com","status":"NEEDS-ACTION","role":"REQ-PARTICIPANT","cutype":"INDIVIDUAL","email":"testehg@websecretinternet.com.br"},{"name":"example2@domain.com","status":"ACCEPTED","role":"REQ-PARTICIPANT","cutype":"INDIVIDUAL","rsvp":false,"email":"example2@domain.com"}]', "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]

root@dedi-5129251.domain.com [roundcube]# grep '' /var/cpanel/roundcube/version
1.5.2.5-1.cp108~el7
root@dedi-5129251.domain.com [roundcube]#
DB

Code: [Select]

root@dedi-5129251.domain.com [roundcube]# grep roundcube  /var/cpanel/cpanel.config
roundcube_db=sqlite
skiproundcube=0
root@dedi-5129251.domain.com [roundcube]#
The cPanel version

Code: [Select]

root@dedi-5129251.domain.com [roundcube]# grep '' /usr/local/cpanel/version
11.108.0.13
root@dedi-5129251.domain.com [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.