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

[Vincent Bernat]

 ❦  5 mars 2014 23:00 CET, Matija Nalis <mnalis-debianbug at voyager.hr> :

> It seems that 
> /usr/share/dbconfig-common/data/roundcube/upgrade/mysql/0.5-1
> did get applied correctly, but that this file is broken as packaged.
>
> it contains (among valid SQL) two problematic lines:
> -- ALTER TABLE `identities` ADD INDEX `user_identities_index` (`user_id`, `del`);
> -- ALTER TABLE `identities` ADD `changed` datetime NOT NULL DEFAULT '1000-01-01 00:00:00' AFTER `user_id`;
>
> note that "--" indicates SQL comment, so those two lines DO NOT get
> executed, although they should!
>
> If one executes them manually, (by removing "--" at the begging of the lines)
> the roundcube works normally again (when editing identities).
>
> So, something commented those two lines out with '--' for some reason, but never
> enabled them again, althought clearly they must be executed for roundcube to
> work correctly (none of the other mysql upgrade commands creates that
> "changed" field in "indentities" table, and code uses it -- causing
> roundcube as packaged in wheezy to break when attempting to manipulate
> identities)

What was your previous version of roundcube? The line has been commented
because it is applied in postinst in an attempt to fix #610725 and
#613586. It sould be interesting to know what was your upgrade path and
why the postinst script didn't work for you.
-- 
die_if_kernel("Penguin instruction from Penguin mode??!?!", regs);
	2.2.16 /usr/src/linux/arch/sparc/kernel/traps.c
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 818 bytes
Desc: not available
URL: <http://lists.alioth.debian.org/pipermail/pkg-roundcube-maintainers/attachments/20140306/6ec351b4/attachment.sig>