ÇáæíÈ ãíá 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
ÇáãÝÖáÇÊ