Duplicated user entries when upgrading

[mark_valley]

Good day,

Last thurstday i upgraded roundcube 0.3.1 to 0.4.1 version following the instructions at "UPGRADING" guide, without any configuration changes. We use postgresql 8.3.

After that, some random users are complaining about losing information such as contacts and signatures.

Taking a look at the database (at "users" table), i noticed that this users now have a duplicate entry (with two IDs) and all information at tables like identities and contacts are pointing to the older user_id. The figure below is an example about what i am talking about:



We have more than 2000 users and some of then got very pissed off with this situation so a had to restore an older database and got back to 0.3.1 version.

I would like to know is any other people had the same problem and if there is something i can do to solve it and finally upgrade.

Thanks in advance.

[SKaero]

What database are you use, it doesn't seam to be mysql.

[mark_valley]

Forgot to say that: Postgresql  8.3

[SKaero]

Can you run an SQL log when one of the user that gets a duplicate entry in the database logs into 0.4.1 for the first time after the upgrade.

[mark_valley]

It will just take a little bit to exporte the 0.4.1 database to a non-production machine an adjust the configurations. Will show the results as soon as i do it.

Can you run an SQL log when one of the user that gets a duplicate entry in the database logs into 0.4.1 for the first time after the upgrade.