[Pkg-roundcube-maintainers] Bug#711904: [roundcube] can't modify identities since wheezy

[Vincent Bernat]

 ❦ 10 juin 2013 21:34 CEST, Adrien Grellier <perso at 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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 835 bytes
Desc: not available
URL: <http://lists.alioth.debian.org/pipermail/pkg-roundcube-maintainers/attachments/20130610/3d5d341c/attachment.pgp>