RoundCube - Security updates 1.6.13 and 1.5.13 released

It failed to update on my Ubuntu server:

Code:
/usr/local/directadmin/custombuild# ./build update_versions
Updating RoundCube
download_cached: using cached '/usr/local/directadmin/custombuild/cache/roundcubemail-1.6.13-complete.tar.gz' file
mysql: Deprecated program name. It will be removed in a future release, use '/usr/local/mariadb-11.4.10-fp4a/bin/mariadb' instead
updating database user da_roundcube@localhost password
mysql: Deprecated program name. It will be removed in a future release, use '/usr/local/mariadb-11.4.10-fp4a/bin/mariadb' instead
mysql: Deprecated program name. It will be removed in a future release, use '/usr/local/mariadb-11.4.10-fp4a/bin/mariadb' instead
mysql: Deprecated program name. It will be removed in a future release, use '/usr/local/mariadb-11.4.10-fp4a/bin/mariadb' instead
Checking for database schema updates...
Updating database schema (2021081000)... [FAILED]
ERROR: Error in DDL upgrade 2021081000: [1005] Can't create table `da_roundcube`.`responses` (errno: 121 "Duplicate key on write or update")
command_roundcube: failed to compile '/usr/local/directadmin/custombuild/cache/roundcubemail-1.6.13-complete.tar.gz' inside '/usr/local/directadmin/custombuild/tmp/tmp.sXWKoGrUyd.roundcubemail-1.6.13-complete.tar.gz'
failed to install Roundcube
 
I found a fix.

1. Edit the file /var/www/html/roundcube/SQL/mysql/2021081000.sql and change CONSTRAINT `user_id_fk_responses` to CONSTRAINT `user_id_fk_responses_fixed`

2. Run /var/www/html/roundcube/bin/updatedb.sh --package=roundcube --dir=./SQL --all-versions

3. Run /usr/local/directadmin/custombuild/build roundcube

4. Run again /usr/local/directadmin/custombuild/build roundcube

It fixed it.
 
Back
Top