❦ 10 juin 2013 21:34 CEST, Adrien Grellier <pe...@adrieng.fr> : > I just update my Debian server from squeeze to wheezy. Since then, the > user can't modified and saved their identities. An error message > appears on the webpage, and in the log I got these messages : > > [10-Jun-2013 19:24:59 UTC] MDB2 Error: no such field (-19): _doQuery: [Error > message: Could not execute statement] > [Last executed query: PREPARE > mdb2_statement_mysql_3cf0664874b7642524188f3b429e8cdfc3300cb6f FROM > UPDATE identities SET changed = now(), `name` = ?, `email` = ?, > organization` = ?, `reply-to` = ?, `bcc` = ?, `standard` = ?, > signature` = ?, `html_signature` = ? WHERE identity_id = ? AND user_id > = ? AND del <> 1'] > [Native code: 1054] > [Native message: Unknown column 'changed' in 'field list'] > > [10-Jun-2013 21:24:59 +0200]: DB Error: _doQuery: [Error message: Could not > execute statement] > [Last executed query: PREPARE > mdb2_statement_mysql_3cf0664874b7642524188f3b429e8cdfc3300cb6f FROM > UPDATE identities SET changed = now(), `name` = ?, `email` = ?, > organization` = ?, `reply-to` = ?, `bcc` = ?, `standard` = ?, > signature` = ?, `html_signature` = ? WHERE identity_id = ? AND user_id > = ? AND del <> 1'] > [Native code: 1054] > [Native message: Unknown column 'changed' in 'field list'] > in /usr/share/roundcube/program/include/rcube_mdb2.php on line 293 (POST > /roundcube/?_task=settings&_action=save-identity) > > > It seems that the db doesn't migrate well… What can be done now in > order to be able to restore a good db and so, be able to modify the > identities ?
From which version did you migrate? You can try to apply the upgrade files by hand: /usr/share/dbconfig-common/data/roundcube/upgrade/mysql -- #ifdef STUPIDLY_TRUST_BROKEN_PCMD_ENA_BIT 2.4.0-test2 /usr/src/linux/drivers/ide/cmd640.c
pgprWIcoDk8S7.pgp
Description: PGP signature