search

roundcube / roundcubemail

The Roundcube Webmail suite
https://roundcube.net
GNU General Public License v3.0
5.79k stars 1.62k forks source link

Error in DDL upgrade #7508

Closed fernando-sianet closed 4 years ago

fernando-sianet commented 4 years ago

Hi,

how can i resolve this error? best regards

bin/installto.sh /var/www/roundcube-test/ Target installation already in version 1.4.7. Do you want to update again? (y/N) y Copying files to target location....htaccess.new done.

NOTICE: New .htaccess file saved as .htaccess.new. NOTICE: JavaScript dependencies installation skipped. NOTICE: The 'installer' directory still exists. You should remove it after the upgrade.

Running update script at target... Executing database schema update. Updating database schema (2015111100)... [FAILED] ERROR: Error in DDL upgrade 2015111100: [1060] Duplicate column name 'failed_login' All done.

alecpl commented 4 years ago

What version did you upgrade from?

Looks like the Information in system table is wrong. You'll have to fix it manually. Execute "UPDATE system SET value = '2015111100' WHERE name = 'roundcube-version';` Do the same if the error appears again (with a different version string).

fernando-sianet commented 4 years ago

Hi,

Version is roundcubemail-1.4.4

alecpl commented 4 years ago

There's really not much we can do about this.

jsoref commented 3 years ago

Fwiw, I hit what appears to be this same error:

    │ mysql said: ERROR 1060 (42S21) at line 2: Duplicate column name 'failed_login'                                                                           │
    │                                                                                                                                                          │
    │ Fortunately, /var/cache/dbconfig-common/backups/roundcube_1.2~beta+dfsg.1-0ubuntu1.2021-04-11-03.12.58 should hold a backup of the database, made just   │
    │ before the upgrade (unless the error occurred during backup creation, in which case no changes will have been applied yet). Your options are:            │

2021-04-11 02:29:03 upgrade roundcube:all 1.2~beta+dfsg.1-0ubuntu1 1.3.6+dfsg.1-1

MariaDB [roundcube]> select value from system where name='roundcube-version';
+------------+
| value      |
+------------+
| 2015111100 |
+------------+
1 row in set (0.00 sec)