v120/v126: Unable to access Roundcube after updates

Symptoms

v120: Accessing Calendars/Contacts in Roundcube returns a server error. The Roundcube logs return the following message.

DB Error: [1] table carddav_addressbooks has no column named use_categories 
(SQL Query: INSERT INTO carddav_addressbooks("name","username","password",
"url","user_id","sync_token","active","presetname","use_categories","refresh_time")

v126: Access Roundcube after the login returns an Oops page.

Oops... something went wrong! An internal error has occurred.

The Roundcube logs return the following error message.

DB Error: [1] no such table: carddav_accounts 
(SQL Query: SELECT * FROM carddav_accounts WHERE (("user_id" = '1'))) 
in /usr/local/cpanel/base/3rdparty/roundcube/program/lib/Roundcube/
rcube_db.php on line 577 

Description

Since updating to version 120 or to version 126, some users can't access their Roundcube Webmail interface due to an outdated SQLite schema. The schema fails to apply the updates due to an old directory in the dbmigrations path. The old directory should've been removed during an older update, but it still exists on some servers. The empty directory causes a failure when iterating through the path to stage SQLite updates for the user databases.

We've opened an internal case for our development team to investigate this further. For reference, the case number is CPANEL-45763. Follow this article to receive an email notification when a solution is published in the product. 

Workaround

Update: May 30th, 2025.

We've released an auto-recovery command to resolve this issue. This repair command runs automatically via cron, but if you need immediate access to Roundcube, please run the following command:

/usr/local/cpanel/scripts/autorepair recoverymgmt