Package: roundcube Version: 0.7.2-9+deb7u1 Followup-For: Bug #711904 same problem here...
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) -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
