Symptoms
Severs using the MySQL backend for Roundcube are unable to log in after the update to v128. A message similar to the following is shown:
Oops... something went wrong!
An internal error has occurred. Your request cannot be processed at this time.
For administrators: Please check the application and/or server error logs for more information.
A log will be written to /var/cpanel/roundcube/log/errors.log similar to the following:
DB Error: [1054] Unknown column 'user_id' in 'WHERE' (SQL Query: SELECT * FROM carddav_addressbooks WHERE ((`user_id` = '1111'))) in /usr/local/cpanel/base/3rdparty/roundcube/program/lib/Roundcube/rcube_db.php
Description
Information from the database is missing or corrupted, causing the interface to be unable to load.
We've opened an internal case for our development team to investigate this further. For reference, the case number is CPANEL-47622. Follow this article to receive an email notification when a solution is published in the product.
Workaround
The steps to perform this are:
1. Create a backup of the current MySQL database:
mysqldump roundcube > /root/roundcube.sql
2. Drop the RoundCube MySQL database:
mysql -e "DROP DATABASE roundcube"
3. Recreate the RoundCube database:
/usr/local/cpanel/bin/update-roundcube-db --foreground --force
4. Import your backup:
mysql roundcube < /root/roundcube.sql
From there the system can be converted to the supported SQLite backend:
/scripts/convert_roundcube_mysql2sqlite
Comments
0 comments
Article is closed for comments.