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

[Vincent Bernat]

OoO En ce doux début de matinée du mercredi 16 février 2011, vers 08:09,
Laurens Blankers <laurens at blankersfamily.com> disait :

>> 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.

In the  0.5-1 upgrade file,  there is some  ALTER TABLE ...  FOREIGN KEY
... ON  DELETE CASCADE  ON UPDATE  CASCADE. I think  the whole  file was
played in  a transaction  which rolled back.  Could you execute  them as
well and see if this fixed your issue?

In the mean time, I will move away the ADD INDEX into another location.
-- 
panic("CPU too expensive - making holiday in the ANDES!");
	2.2.16 /usr/src/linux/arch/mips/kernel/traps.c
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 197 bytes
Desc: not available
URL: <http://lists.alioth.debian.org/pipermail/pkg-roundcube-maintainers/attachments/20110216/819c80fc/attachment.pgp>