Package: roundcube Version: 0.5.1+dfsg-3 Severity: grave Justification: renders package unusable
The database upgrade fails with: > mysql said: ERROR 1060 (42S21) at line 49: Duplicate column name 'changed' I've attached the backup database (sans the insert statements). -- System Information: Debian Release: wheezy/sid APT prefers testing APT policy: (500, 'testing') Architecture: i386 (i686) Kernel: Linux 2.6.32-5-686 (SMP w/4 CPU cores) Locale: LANG=en_GB.UTF-8, LC_CTYPE=en_GB.UTF-8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/dash Versions of packages roundcube-core depends on: pn apache2 | lighttpd | htt <none> (no description available) ii dbconfig-common 1.8.46 common framework for packaging dat ii debconf [debconf-2.0] 1.5.38 Debian configuration management sy ii libjs-jquery 1.5-2 JavaScript library for dynamic web ii libmagic1 5.04-5 File type determination library us ii php-auth 1.6.2-1 PHP PEAR modules for creating an a ii php-mail-mime 1.8.0-2 PHP PEAR module for creating MIME ii php-mdb2 2.5.0b2-1 PHP PEAR module to provide a commo ii php-net-smtp 1.4.2-3 PHP PEAR module implementing SMTP ii php-net-socket 1.0.9-2 PHP PEAR Network Socket Interface ii php5 5.3.3-7 server-side, HTML-embedded scripti ii php5-gd 5.3.3-7 GD module for php5 pn php5-intl <none> (no description available) ii php5-mcrypt 5.3.3-7 MCrypt module for php5 ii php5-pspell 5.3.3-7 pspell module for php5 pn roundcube-sqlite | round <none> (no description available) ii tinymce 3.3.8+dfsg0-0.1 platform independent web based Jav ii ucf 3.0025+nmu1 Update Configuration File: preserv roundcube-core recommends no packages. Versions of packages roundcube-core suggests: pn php-auth-sasl <none> (no description available) pn roundcube-plugins <none> (no description available) roundcube depends on no packages. -- debconf information: roundcube/password-confirm: (password omitted) roundcube/mysql/admin-pass: (password omitted) * roundcube/mysql/app-pass: (password omitted) * roundcube/app-password-confirm: (password omitted) roundcube/pgsql/app-pass: (password omitted) roundcube/pgsql/admin-pass: (password omitted) * roundcube/dbconfig-install: true roundcube/db/dbname: roundcube roundcube/pgsql/authmethod-admin: ident roundcube/pgsql/admin-user: postgres roundcube/internal/skip-preseed: false roundcube/db/app-user: roundcube roundcube/dbconfig-reinstall: false roundcube/restart-webserver: true roundcube/dbconfig-upgrade: true roundcube/remote/port: roundcube/pgsql/no-empty-passwords: roundcube/passwords-do-not-match: roundcube/internal/reconfiguring: false roundcube/upgrade-error: abort roundcube/pgsql/authmethod-user: password roundcube/purge: false roundcube/language: en_GB roundcube/remote/newhost: roundcube/pgsql/changeconf: false roundcube/upgrade-backup: true roundcube/install-error: abort roundcube/mysql/admin-user: root roundcube/hosts: roundcube/dbconfig-remove: roundcube/mysql/method: unix socket roundcube/remove-error: abort roundcube/pgsql/method: unix socket roundcube/pgsql/manualconf: roundcube/db/basepath: roundcube/reconfigure-webserver: apache2, lighttpd * roundcube/database-type: mysql roundcube/remote/host: roundcube/missing-db-package-error: abort
-- MySQL dump 10.13 Distrib 5.1.49, for debian-linux-gnu (i486) -- -- Host: Database: roundcube -- ------------------------------------------------------ -- Server version 5.1.49-3-log /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `cache` -- DROP TABLE IF EXISTS `cache`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cache` ( `cache_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `cache_key` varchar(128) CHARACTER SET ascii NOT NULL, `created` datetime NOT NULL DEFAULT '1000-01-01 00:00:00', `data` longtext NOT NULL, `user_id` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`cache_id`), KEY `created_index` (`created`), KEY `user_cache_index` (`user_id`,`cache_key`), CONSTRAINT `user_id_fk_cache` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cache` -- LOCK TABLES `cache` WRITE; /*!40000 ALTER TABLE `cache` DISABLE KEYS */; /*!40000 ALTER TABLE `cache` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `contactgroupmembers` -- DROP TABLE IF EXISTS `contactgroupmembers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `contactgroupmembers` ( `contactgroup_id` int(10) unsigned NOT NULL, `contact_id` int(10) unsigned NOT NULL DEFAULT '0', `created` datetime NOT NULL DEFAULT '1000-01-01 00:00:00', PRIMARY KEY (`contactgroup_id`,`contact_id`), KEY `contact_id_fk_contacts` (`contact_id`), CONSTRAINT `contactgroup_id_fk_contactgroups` FOREIGN KEY (`contactgroup_id`) REFERENCES `contactgroups` (`contactgroup_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `contact_id_fk_contacts` FOREIGN KEY (`contact_id`) REFERENCES `contacts` (`contact_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `contactgroupmembers` -- LOCK TABLES `contactgroupmembers` WRITE; /*!40000 ALTER TABLE `contactgroupmembers` DISABLE KEYS */; /*!40000 ALTER TABLE `contactgroupmembers` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `contactgroups` -- DROP TABLE IF EXISTS `contactgroups`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `contactgroups` ( `contactgroup_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(10) unsigned NOT NULL DEFAULT '0', `changed` datetime NOT NULL DEFAULT '1000-01-01 00:00:00', `del` tinyint(1) NOT NULL DEFAULT '0', `name` varchar(128) NOT NULL DEFAULT '', PRIMARY KEY (`contactgroup_id`), KEY `contactgroups_user_index` (`user_id`,`del`), CONSTRAINT `user_id_fk_contactgroups` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `contactgroups` -- LOCK TABLES `contactgroups` WRITE; /*!40000 ALTER TABLE `contactgroups` DISABLE KEYS */; /*!40000 ALTER TABLE `contactgroups` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `contacts` -- DROP TABLE IF EXISTS `contacts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `contacts` ( `contact_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `changed` datetime NOT NULL DEFAULT '1000-01-01 00:00:00', `del` tinyint(1) NOT NULL DEFAULT '0', `name` varchar(128) NOT NULL DEFAULT '', `email` varchar(255) NOT NULL, `firstname` varchar(128) NOT NULL DEFAULT '', `surname` varchar(128) NOT NULL DEFAULT '', `vcard` text, `user_id` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`contact_id`), KEY `user_contacts_index` (`user_id`,`email`), CONSTRAINT `user_id_fk_contacts` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `contacts` -- LOCK TABLES `contacts` WRITE; /*!40000 ALTER TABLE `contacts` DISABLE KEYS */; /*!40000 ALTER TABLE `contacts` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `identities` -- DROP TABLE IF EXISTS `identities`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `identities` ( `identity_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `del` tinyint(1) NOT NULL DEFAULT '0', `standard` tinyint(1) NOT NULL DEFAULT '0', `name` varchar(128) NOT NULL, `organization` varchar(128) NOT NULL DEFAULT '', `email` varchar(128) NOT NULL, `reply-to` varchar(128) NOT NULL DEFAULT '', `bcc` varchar(128) NOT NULL DEFAULT '', `signature` text, `html_signature` tinyint(1) NOT NULL DEFAULT '0', `user_id` int(10) unsigned NOT NULL DEFAULT '0', `changed` datetime NOT NULL DEFAULT '1000-01-01 00:00:00', PRIMARY KEY (`identity_id`), KEY `user_id_fk_identities` (`user_id`), CONSTRAINT `user_id_fk_identities` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `identities` -- LOCK TABLES `identities` WRITE; /*!40000 ALTER TABLE `identities` DISABLE KEYS */; /*!40000 ALTER TABLE `identities` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `messages` -- DROP TABLE IF EXISTS `messages`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `messages` ( `message_id` int(11) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(10) unsigned NOT NULL DEFAULT '0', `del` tinyint(1) NOT NULL DEFAULT '0', `cache_key` varchar(128) CHARACTER SET ascii NOT NULL, `created` datetime NOT NULL DEFAULT '1000-01-01 00:00:00', `idx` int(11) unsigned NOT NULL DEFAULT '0', `uid` int(11) unsigned NOT NULL DEFAULT '0', `subject` varchar(255) NOT NULL, `from` varchar(255) NOT NULL, `to` varchar(255) NOT NULL, `cc` varchar(255) NOT NULL, `date` datetime NOT NULL DEFAULT '1000-01-01 00:00:00', `size` int(11) unsigned NOT NULL DEFAULT '0', `headers` text NOT NULL, `structure` text, PRIMARY KEY (`message_id`), UNIQUE KEY `uniqueness` (`user_id`,`cache_key`,`uid`), KEY `created_index` (`created`), KEY `index_index` (`user_id`,`cache_key`,`idx`), CONSTRAINT `user_id_fk_messages` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `messages` -- LOCK TABLES `messages` WRITE; /*!40000 ALTER TABLE `messages` DISABLE KEYS */; /*!40000 ALTER TABLE `messages` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `session` -- DROP TABLE IF EXISTS `session`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `session` ( `sess_id` varchar(40) NOT NULL, `created` datetime NOT NULL DEFAULT '1000-01-01 00:00:00', `changed` datetime NOT NULL DEFAULT '1000-01-01 00:00:00', `ip` varchar(40) NOT NULL, `vars` mediumtext NOT NULL, PRIMARY KEY (`sess_id`), KEY `changed_index` (`changed`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `session` -- LOCK TABLES `session` WRITE; /*!40000 ALTER TABLE `session` DISABLE KEYS */; /*!40000 ALTER TABLE `session` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `users` ( `user_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `username` varchar(128) NOT NULL, `mail_host` varchar(128) NOT NULL, `alias` varchar(128) NOT NULL, `created` datetime NOT NULL DEFAULT '1000-01-01 00:00:00', `last_login` datetime DEFAULT NULL, `language` varchar(5) DEFAULT NULL, `preferences` text, PRIMARY KEY (`user_id`), UNIQUE KEY `username` (`username`,`mail_host`), KEY `alias_index` (`alias`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `users` -- LOCK TABLES `users` WRITE; /*!40000 ALTER TABLE `users` DISABLE KEYS */; /*!40000 ALTER TABLE `users` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2011-03-07 23:40:08
