From 2a9280c80be73d7b1d4834131439399f333d5295 Mon Sep 17 00:00:00 2001 From: Vincent Bernat Date: Wed, 16 Feb 2011 07:47:49 +0000 Subject: [PATCH] Remove all "ADD INDEX" from MySQL 0.5-1 upgrade file and put them in postinst script. Also add a note in NEWS.Debian file about this problem. Closes: #613586. --- debian/changelog | 8 ++++++++ debian/roundcube-core.NEWS | 15 +++++++++++++++ debian/roundcube-core.postinst | 1 + debian/sql/mysql/0.5-1 | 2 +- 4 files changed, 25 insertions(+), 1 deletion(-) diff --git a/debian/changelog b/debian/changelog index 41c0685..6e85f77 100644 --- a/debian/changelog +++ b/debian/changelog @@ -1,3 +1,11 @@ +roundcube (0.5.1+dfsg-2) unstable; urgency=low + + * Remove all "ADD INDEX" from MySQL 0.5-1 upgrade file and put them in + postinst script. Also add a note in NEWS.Debian file about this + problem. Closes: #613586. + + -- Vincent Bernat Wed, 16 Feb 2011 08:40:34 +0100 + roundcube (0.5.1+dfsg-1) unstable; urgency=low * Add plugins. Closes: #550454. diff --git a/debian/roundcube-core.NEWS b/debian/roundcube-core.NEWS index 58abf9a..635fe43 100644 --- a/debian/roundcube-core.NEWS +++ b/debian/roundcube-core.NEWS @@ -1,3 +1,18 @@ +roundcube (0.5.1+dfsg-2) unstable; urgency=low + + Upgrades to 0.5.X using a MySQL database and with the help of + dbconfig-common may have been incomplete. If you got error from + dbconfig-common about a problem during migration from 0.3.1-6 to + 0.5-1 or if some features are missing, most notably identities and + address book management, please reexecute all commands in this + file (with "-f" flag of mysql command): + /usr/share/dbconfig-common/data/roundcube/upgrade/mysql/0.5-1 + + More information can be found here: + http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=613586 + + -- Vincent Bernat Wed, 16 Feb 2011 08:40:34 +0100 + roundcube (0.3.1-2) unstable; urgency=low Starting from Roundcube 0.3, an incompatibility with Suhosin session diff --git a/debian/roundcube-core.postinst b/debian/roundcube-core.postinst index f4e2a82..e574dae 100644 --- a/debian/roundcube-core.postinst +++ b/debian/roundcube-core.postinst @@ -55,6 +55,7 @@ case "$1" in ALTER TABLE \`messages\` ADD INDEX \`index_index\` (\`user_id\`, \`cache_key\`, \`idx\`); ALTER TABLE \`session\` CHANGE \`vars\` \`vars\` MEDIUMTEXT NOT NULL; ALTER TABLE \`contacts\`ADD INDEX \`user_contacts_index\` (\`user_id\`,\`email\`); +ALTER TABLE \`identities\` ADD INDEX \`user_identities_index\` (\`user_id\`, \`del\`); EOF fi fi diff --git a/debian/sql/mysql/0.5-1 b/debian/sql/mysql/0.5-1 index f9eecba..bca7427 100644 --- a/debian/sql/mysql/0.5-1 +++ b/debian/sql/mysql/0.5-1 @@ -45,7 +45,7 @@ ALTER TABLE `contacts` ALTER `name` SET DEFAULT ''; ALTER TABLE `contacts` ALTER `firstname` SET DEFAULT ''; ALTER TABLE `contacts` ALTER `surname` SET DEFAULT ''; -ALTER TABLE `identities` ADD INDEX `user_identities_index` (`user_id`, `del`); +-- 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`; CREATE TABLE `contactgroups` ( -- 2.39.5