ÇáæíÈ ãíá Web Mail ÇáÊÞæíã Calendar Íá ãÔßáÉ Server Error! (Internal Server Error)
Server Error! (Internal Server Error) when Deleting Calendar Event
after installing CCS plugin : Roundcube Calendar returns "Failed to save changes. while create / delete calendar
Cannot delete calendars created in RoundCube when the Calendar and Contacts Server is installed on cPanel 108
How do I convert Roundcube from MySQL to SQLite?
How to Convert Roundcube to SQLite



ÇáãÔßáÉ :

ÈÚÏ ÊÝÚíá CCS plugin : Roundcube Calendar returns
áÇ íãßä ÇäÔÇÁ Çæ ÍÐÝ Calendar æíÙåÑ ÎØÇ Server Error

After installing CCS plugin : Roundcube Calendar returns "Failed to save changes. while create / delete calendar , this happen on all my servers if i uninstalled Calendar and Contacts Server from Manage Plugins it's working.

When removing a calendar event in Roundcube, a message similar to the following is shown and the event is not removed: Server Error! (Internal Server Error)

ÓÈÈ ÇáãÔßáÉ :

The cPanel CCS plugin is incompatible with servers that use MySQL for Roundcube databases resulting in syntax errors.

æåÊÌÏ Ýì ÇááæÌ LOG ÇáÎØÇ

[server]cPs# tail /home/companyemail/logs/roundcube/errors.log
[26-Feb-2023 22:18:36 +0200]: <e967d990> DB Error: [1] no such column: NEW.calendar_id (SQL Query: DELETE FROM caldav_calendars_merged WHERE calendar_id='3') in /usr/local/cpanel/base/3rdparty/roundcube/program/lib/Roundcube/rcube_db.php on line 566 (POST /cpsess4240388833/3rdparty/roundcube/index.php?_task=calendar&_action=calendar)

Íá ÇáãÔßáÉ :

åÐÇ ÇáÍá áä íÚãá æáßä ááÚáã ÝÞØ
Convert the server to use SQLite for Roundcube
For a more stable, portable, and faster experience with Roundcube, user databases should be converted to SQLite from MySQL.

Warning:
If you change Roundcube’s database to an SQLite database,
you cannot revert back to a MySQL database.

To convert the Roundcube database in cPanel & WHM from MySQL to SQLite,


ÇÏÎá åÐÇ ÇáÇãÑ áÊÍæíá ÞÇÚÏÉ ÇáÈíÇäÇÊ

ßæÏ:
/usr/local/cpanel/scripts/convert_roundcube_mysql2sqlite
ÇÐÇ ÙåÑ áß åÐÇ
info [convert_roundcube_mysql2sqlite] Roundcube conversion already occurred, bailing out.

åÐÇ íÚäì Çä ÞÇÚÏÉ ÇáÈíÇäÇÊ ãÍæáå ÈÇáÝÚá
æÈÇáÊÇáì áíÓ ááãÔßáÉ ÚáÇÞÉ ÈåÇ !

After you convert the system to an SQLite database, you can use this script to troubleshoot issues with specific users. When troubleshooting a failed conversion, to convert the Roundcube data for a single cPanel user from MySQL to SQLite, run the same command with the user parameter, where user represents the database user:

ÇÏÎá åÐÇ ÇáÇãÑ áÊÍæíá ÞÇÚÏÉ ÇáÈíÇäÇÊ áãÓÊÎÏã ãÍÏÏ

ßæÏ:
/usr/local/cpanel/scripts/convert_roundcube_mysql2sqlite user
Note, all users on a system must use the same database format. You cannot use this script to convert just one user and leave the rest using MySQL.

åá åäÇß ÎØÑ Ýì ÊÍæíá ÞÇÚÏÉ ÇáÈíÇäÇÊ ¿

Does converting MySQL Roundcube to SQLite Roundcube involve the risk of data loss?

There is no risk of data loss as cPanel creates a backup of MySQL Roundcube before converting. cPanel also retains the existing data to convert after the errors have been corrected in the event of error or conversion failure

-------------------------------------------------
Çíä ÇáÍá áåÐå ÇáãÔßáÉ ¿

I was able to replicate this issue on your server as well as a testing server, and have therefore filed this as an issue to our developers with case ID CPANEL-42492. I have also created the following article which provides further information on this as well: Cannot delete calendars created in RoundCube when the Calendar and Contacts Server is installed on cPanel 108

At this time, there is currently no workaround to this issue. You can follow this article to receive a notification when additional information is available.


Êã ÝÊÍ ÊÐßÑå áÏÚã cpanel æÞãæÇ ÈÇáÊÌÑÈÉ Úáì ÇáÓíÑÝÑ ÇáÎÇÕ ÈäÇ æÇÎÑ ÎÇÕ Èåã
ææÌÏæÇ Çä ÇáãÔßáÉ ãæÌæÏÉ ÈÇáÝÚá æåì ãÔßáÉ ÚÇãÉ æÚãáæÇ ãÞÇáå ÈåÐå ÇáãÔßáÉ åäÇ

https://support.cpanel.net/hc/en-us/...OrR-1SRAySkbpY
æÝì ÇäÊÙÇÑ ÇáÍá ãä ÌÇäÈåã Ýì åÐå ÇáãÞÇáå.

ÇáãÑÌÚ:
https://support.cpanel.net/hc/en-us/...2PTvGZJaBBZC-w
https://support.cpanel.net/hc/en-us/...s/360050870614
https://support.cpanel.net/hc/en-us/...-of-data-loss-
https://docs.cpanel.net/knowledge-ba...ube-to-sqlite/
https://www.thecpaneladmin.com/round...sql-or-sqlite/
https://support.cpanel.net/hc/en-us/...OrR-1SRAySkbpY