Roundcube MySQL dbmigration fails with Unknown column 'user_id'

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