[Pkg-roundcube-maintainers] Bug#613586: roundcube: Missing tables and columns after upgrade

[Laurens Blankers]

On 15-2-2011 23:06, Vincent Bernat wrote:
> Did you get an error while upgrading? The contactgroups table is
> present in the upgrade table.  Another user said that the upgrade failed
> because of user_identities_index was  already present. It seems that you
> have the same problem. Could you look at this file:
>  /usr/share/dbconfig-common/data/roundcube/upgrade/mysql/0.5-1
>
> Search for  "user_identities_index" and execute all the  lines which are
> after this one. I think this should fix your installation.
Thanks for the fast reply.

I didn't notice any obvious error messages during the upgrade, but it is
possible I overlooked them. Executing the commands as you suggested does
indeed solve the problem.

Except for a few details: When I compared the table in my database to
the install script in dbconfig-common I noticed that the tables
identities, cache, messages, and contacts are missing the "ON DELETE
CASCADE ON UPDATE CASCADE" on the foreign key constraint.

This isn't a problem for me, but it may be on sites with a large number
of users.

Laurens