Roundcube Update failed from 1.5.0~ynh2 to 1.5.1~ynh1

The problem seems due to a SQL error with these lines when configuring the database

2021-12-19 12:43:41,084: DEBUG - Creating database schema... ERROR: [1050] Table 'collected_contacts' already exists (SQL Query: CREATE TABLE `collected_contacts` (
2021-12-19 12:43:41,085: DEBUG -  `contact_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
2021-12-19 12:43:41,085: DEBUG -  `changed` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
2021-12-19 12:43:41,085: DEBUG -  `del` tinyint(1) NOT NULL DEFAULT '0',
2021-12-19 12:43:41,085: DEBUG -  `name` varchar(128) NOT NULL DEFAULT '',
2021-12-19 12:43:41,085: DEBUG -  `email` text NOT NULL,
2021-12-19 12:43:41,085: DEBUG -  `firstname` varchar(128) NOT NULL DEFAULT '',
2021-12-19 12:43:41,085: DEBUG -  `surname` varchar(128) NOT NULL DEFAULT '',
2021-12-19 12:43:41,086: DEBUG -  `vcard` longtext NULL,
2021-12-19 12:43:41,086: DEBUG -  `words` text NULL,
2021-12-19 12:43:41,086: DEBUG -  `user_id` int(10) UNSIGNED NOT NULL,
2021-12-19 12:43:41,086: DEBUG -  PRIMARY KEY(`contact_id`),
2021-12-19 12:43:41,086: DEBUG -  CONSTRAINT `user_id_fk_collected_contacts` FOREIGN KEY (`user_id`)
2021-12-19 12:43:41,086: DEBUG -    REFERENCES `users`(`user_id`) ON DELETE CASCADE ON UPDATE CASCADE,
2021-12-19 12:43:41,086: DEBUG -  INDEX `user_collected_contacts_index` (`user_id`,`del`)
2021-12-19 12:43:41,086: DEBUG - ) /*!40000 ENGINE=INNODB */ /*!40101 CHARACTER SET utf8 COLLATE utf8_general_ci */)
2021-12-19 12:43:41,086: DEBUG - [FAILED]
2021-12-19 12:43:41,087: DEBUG - ERROR: [1050] Table 'collected_contacts' already exists

There is a topic here with the same problem Roundcube : issue with the last update - #12 by ppr

1 Like