Roundcube : issue with the last update

[astrowalker2013]

Issue with the last update of roundcube

I put the error in this paste.

2021-11-29 07:35:07,472: DEBUG - Running database initialization script for automatic_addressbook
2021-11-29 07:35:07,475: DEBUG - Creating database schema... ERROR: [1050] Table 'collected_contacts' already exists (SQL Query: CREATE TABLE `collected_contacts` (
2021-11-29 07:35:07,476: DEBUG -  `contact_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
2021-11-29 07:35:07,476: DEBUG -  `changed` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
2021-11-29 07:35:07,476: DEBUG -  `del` tinyint(1) NOT NULL DEFAULT '0',

https://paste.yunohost.org/raw/gisarasomi

[anon78416416]

I have the same issue. Upgrade failed.
https://paste.yunohost.org/raw/esedemokid

[thierry56]

Idem, I’ve the same update error with the last roundcube package

[ppr]

Bonjour,

Un autre log si ça peut aider ou confirmer le problème :
https://paste.yunohost.org/raw/sadigenozi
VPS sur base Debian 64 dernière version stable de YunoHost 4.3.4.1 | 1.5.0~ynh2 to 1.5.1~ynh1.

ppr

[ericg]

automatic_addressbook plugin seems to be the culprit here:

2021-11-30 12:49:59,451: DEBUG - Running database initialization script for automatic_addressbook
2021-11-30 12:49:59,453: DEBUG - Creating database schema... ERROR: [1050] Table 'collected_contacts' already exists (SQL Query: CREATE TABLE `collected_contacts` (

Available for testing, I made a branch where we are not updating automatic_addressbook (there is no upgrade available for it anyway…)

GitHub - YunoHost-Apps/roundcube_ynh at automatic_addressbook

[ppr]

Bonjour,

J’ai procédé à la mise à niveau ainsi, malheureusement sans succès :

sudo yunohost app upgrade roundcube -u https://github.com/YunoHost-Apps/roundcube_ynh/tree/automatic_addressbook --debug

Le log est ici :
https://paste.yunohost.org/raw/ilesuhesus

Edit : une “fresh install” se fait sans problème à partir de la branche “master”.

ppr

[rungeard]

I’ve got similar issue → https://paste.yunohost.org/raw/gomusikuho

[pascalv]

same pb here, i cannot upgrade Roundcube latest version.

[nounix]

same pb for me → https://paste.yunohost.org/raw/osavewates

[Mamie]

The update failed since a few days, and worked today for me.
Note : this time I updated many tools in the same time instead of just roundcube.

[ericg]

A completely untested workaround could be to add in the SQL plugin file →

/var/www/roundcube/plugins/automatic_addressbook/SQL/mysql.initial.sql

In the first line, add IF NOT EXIST like so →

CREATE TABLE IF NOT EXIST 'collected_contacts' (

and try to make the upgrade again…

[ppr]

Good evening,

I’ve try the tricks but it doesn’t work
https://paste.yunohost.org/raw/otoxamonim

I tried again after switching back.

[Error] Upgrade failed.
E: Unable to locate package roundcube-ynh-deps
https://paste.yunohost.org/raw/oferilocoy

I don’t know but naively maybe a problem about php version and dependencies (7.3 | 7.4) or related with the plugins versions ?

Thank you for the time (your time) spent to try to solve the problem.

ppr