Certains menus de l'interface administrateur inaccessibles depuis la mise à jour

Bonjour,
Vieux Laptop HP qui fonctionne avec yunohost 4.2.8.1 (stable)
Roundcube / Custom webapp / Dollibarr / piwigo / Concrete5 / redirect
J’ai accès à mon serveur En SSH | Par la webadmin | En direct avec un clavier/écran |
Je n’ai pas effectué de modifications particulières.

Bonjour,
J’ai effectué ce matin une mise à jour vers 4.2.8.1 et les menus de l’interface admin
-utilisateurs
-domaines
-services
-dans le menu outils /migration/parefeu/parametres de l’administration web/arreter redemarrer
-diagnostic
sont inaccessibles
Par “inaccessibles” je veux dire qu’on peut cliquer sur ces menus mais que rien ne se passe.

J’ai fait un reboot en utilisant SSH et ça n’a pas reglé le problème
J’ai aussi essayé de migrer parceque mon dernier problème de mise à jour venait de là :
admin@pigeonsrapides:~$ sudo yunohost tools migrations run
Info : Aucune migration à lancer
tous les services sont accessibles -même de l’extérieur (testé depuis un autre accès internet)-.
J’ai lancé un diagnostic avec ssh qui propose de faire “sudo apt install --allow-downgrades libssl1.1=1.1.1d-0+deb10u7”
le résultat est “Les paquets suivants seront mis à une VERSION INFÉRIEURE :
libssl1.1”
Je comprends vaguement dans le journal suivant que mon problème vient de PHP et Sury mais je n’ai aucune idée de ce que sont ces deux trucs là.

Le menu “mise à jour” me propose de mettre à jour les applications et j’ai le message d’erreur suivant -je le copie colle parceque la fonction de partage n’est pas accessible non plus-

Les applications suivantes seront mises à jour : concrete5, roundcube, redirect

Mise à jour de concrete5...

Loading installation settings...

Checking version...

Backing up the app before upgrading (may take a while)...

Ensuring downward compatibility...

Making sure dedicated system user exists...

Upgrading source files...

Upgrading NGINX web server configuration...

Upgrading dependencies...

W: An error occurred during the signature verification. The repository is not updated and the previous index files will be used. GPG error: https://packages.sury.org/php buster InRelease: The following signatures were invalid: EXPKEYSIG B188E2B695BD4743 DEB.SURY.ORG Automatic Signing Key

W: Failed to fetch https://packages.sury.org/php/dists/buster/InRelease The following signatures were invalid: EXPKEYSIG B188E2B695BD4743 DEB.SURY.ORG Automatic Signing Key

W: Some index files failed to download. They have been ignored, or old ones used instead.

Upgrading PHP-FPM configuration...

W: An error occurred during the signature verification. The repository is not updated and the previous index files will be used. GPG error: https://packages.sury.org/php buster InRelease: The following signatures were invalid: EXPKEYSIG B188E2B695BD4743 DEB.SURY.ORG Automatic Signing Key

W: Failed to fetch https://packages.sury.org/php/dists/buster/InRelease The following signatures were invalid: EXPKEYSIG B188E2B695BD4743 DEB.SURY.ORG Automatic Signing Key

W: Some index files failed to download. They have been ignored, or old ones used instead.

Upgrading Composer...

Upgrading Concrete5...

In AbstractMySQLDriver.php line 53:

[Doctrine\DBAL\Exception\TableNotFoundException]

An exception occurred while executing 'SELECT * FROM TreeFileFolderNodes WH

ERE treeNodeID = ?' with params ["7"]:

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'concrete5.TreeFi

leFolderNodes' doesn't exist

Exception trace:

at /var/www/concrete5/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:53

Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException() at /var/www/concrete5/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:128

Doctrine\DBAL\DBALException::driverExceptionDuringQuery() at /var/www/concrete5/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:855

Doctrine\DBAL\Connection->executeQuery() at /var/www/concrete5/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:510

Doctrine\DBAL\Connection->fetchAssoc() at /var/www/concrete5/concrete/src/Tree/Node/Type/FileFolder.php:124

Concrete\Core\Tree\Node\Type\FileFolder->loadDetails() at /var/www/concrete5/concrete/src/Tree/Node/Node.php:681

Concrete\Core\Tree\Node\Node::getByID() at /var/www/concrete5/concrete/src/Tree/Tree.php:110

Concrete\Core\Tree\Tree->getRootTreeNodeObject() at /var/www/concrete5/concrete/src/File/Filesystem.php:85

Concrete\Core\File\Filesystem->getRootFolder() at /var/www/concrete5/concrete/src/Updater/Migrations/Migrations/Version20170613000000.php:20

Concrete\Core\Updater\Migrations\Migrations\Version20170613000000->upgradeDatabase() at /var/www/concrete5/concrete/src/Updater/Migrations/AbstractMigration.php:84

Concrete\Core\Updater\Migrations\AbstractMigration->postUp() at /var/www/concrete5/concrete/vendor/doctrine/migrations/lib/Doctrine/DBAL/Migrations/Version.php:297

Doctrine\DBAL\Migrations\Version->execute() at /var/www/concrete5/concrete/src/Updater/Update.php:220

Concrete\Core\Updater\Update::updateToCurrentVersion() at /var/www/concrete5/concrete/src/Console/Command/UpdateCommand.php:92

Concrete\Core\Console\Command\UpdateCommand->Concrete\Core\Console\Command\{closure}() at /var/www/concrete5/concrete/src/System/Mutex/SemaphoreMutex.php:139

Concrete\Core\System\Mutex\SemaphoreMutex->execute() at /var/www/concrete5/concrete/src/Console/Command/UpdateCommand.php:93

Concrete\Core\Console\Command\UpdateCommand->execute() at /var/www/concrete5/concrete/vendor/symfony/console/Command/Command.php:255

Symfony\Component\Console\Command\Command->run() at /var/www/concrete5/concrete/src/Console/Command.php:186

Concrete\Core\Console\Command->run() at /var/www/concrete5/concrete/vendor/symfony/console/Application.php:963

Symfony\Component\Console\Application->doRunCommand() at /var/www/concrete5/concrete/vendor/symfony/console/Application.php:254

Symfony\Component\Console\Application->doRun() at /var/www/concrete5/concrete/vendor/symfony/console/Application.php:147

Symfony\Component\Console\Application->run() at /var/www/concrete5/concrete/src/Foundation/Runtime/Run/CLIRunner.php:70

Concrete\Core\Foundation\Runtime\Run\CLIRunner->run() at /var/www/concrete5/concrete/src/Foundation/Runtime/DefaultRuntime.php:102

Concrete\Core\Foundation\Runtime\DefaultRuntime->run() at /var/www/concrete5/concrete/dispatcher.php:45

require() at /var/www/concrete5/concrete/bin/concrete5:85

In PDOStatement.php line 107:

[Doctrine\DBAL\Driver\PDOException (42S02)]

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'concrete5.TreeFi

leFolderNodes' doesn't exist

Exception trace:

at /var/www/concrete5/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:107

Doctrine\DBAL\Driver\PDOStatement->execute() at /var/www/concrete5/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:849

Doctrine\DBAL\Connection->executeQuery() at /var/www/concrete5/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:510

Doctrine\DBAL\Connection->fetchAssoc() at /var/www/concrete5/concrete/src/Tree/Node/Type/FileFolder.php:124

Concrete\Core\Tree\Node\Type\FileFolder->loadDetails() at /var/www/concrete5/concrete/src/Tree/Node/Node.php:681

Concrete\Core\Tree\Node\Node::getByID() at /var/www/concrete5/concrete/src/Tree/Tree.php:110

Concrete\Core\Tree\Tree->getRootTreeNodeObject() at /var/www/concrete5/concrete/src/File/Filesystem.php:85

Concrete\Core\File\Filesystem->getRootFolder() at /var/www/concrete5/concrete/src/Updater/Migrations/Migrations/Version20170613000000.php:20

Concrete\Core\Updater\Migrations\Migrations\Version20170613000000->upgradeDatabase() at /var/www/concrete5/concrete/src/Updater/Migrations/AbstractMigration.php:84

Concrete\Core\Updater\Migrations\AbstractMigration->postUp() at /var/www/concrete5/concrete/vendor/doctrine/migrations/lib/Doctrine/DBAL/Migrations/Version.php:297

Doctrine\DBAL\Migrations\Version->execute() at /var/www/concrete5/concrete/src/Updater/Update.php:220

Concrete\Core\Updater\Update::updateToCurrentVersion() at /var/www/concrete5/concrete/src/Console/Command/UpdateCommand.php:92

Concrete\Core\Console\Command\UpdateCommand->Concrete\Core\Console\Command\{closure}() at /var/www/concrete5/concrete/src/System/Mutex/SemaphoreMutex.php:139

Concrete\Core\System\Mutex\SemaphoreMutex->execute() at /var/www/concrete5/concrete/src/Console/Command/UpdateCommand.php:93

Concrete\Core\Console\Command\UpdateCommand->execute() at /var/www/concrete5/concrete/vendor/symfony/console/Command/Command.php:255

Symfony\Component\Console\Command\Command->run() at /var/www/concrete5/concrete/src/Console/Command.php:186

Concrete\Core\Console\Command->run() at /var/www/concrete5/concrete/vendor/symfony/console/Application.php:963

Symfony\Component\Console\Application->doRunCommand() at /var/www/concrete5/concrete/vendor/symfony/console/Application.php:254

Symfony\Component\Console\Application->doRun() at /var/www/concrete5/concrete/vendor/symfony/console/Application.php:147

Symfony\Component\Console\Application->run() at /var/www/concrete5/concrete/src/Foundation/Runtime/Run/CLIRunner.php:70

Concrete\Core\Foundation\Runtime\Run\CLIRunner->run() at /var/www/concrete5/concrete/src/Foundation/Runtime/DefaultRuntime.php:102

Concrete\Core\Foundation\Runtime\DefaultRuntime->run() at /var/www/concrete5/concrete/dispatcher.php:45

require() at /var/www/concrete5/concrete/bin/concrete5:85

In PDOStatement.php line 105:

[PDOException (42S02)]

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'concrete5.TreeFi

leFolderNodes' doesn't exist

Exception trace:

at /var/www/concrete5/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:105

PDOStatement->execute() at /var/www/concrete5/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:105

Doctrine\DBAL\Driver\PDOStatement->execute() at /var/www/concrete5/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:849

Doctrine\DBAL\Connection->executeQuery() at /var/www/concrete5/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:510

Doctrine\DBAL\Connection->fetchAssoc() at /var/www/concrete5/concrete/src/Tree/Node/Type/FileFolder.php:124

Concrete\Core\Tree\Node\Type\FileFolder->loadDetails() at /var/www/concrete5/concrete/src/Tree/Node/Node.php:681

Concrete\Core\Tree\Node\Node::getByID() at /var/www/concrete5/concrete/src/Tree/Tree.php:110

Concrete\Core\Tree\Tree->getRootTreeNodeObject() at /var/www/concrete5/concrete/src/File/Filesystem.php:85

Concrete\Core\File\Filesystem->getRootFolder() at /var/www/concrete5/concrete/src/Updater/Migrations/Migrations/Version20170613000000.php:20

Concrete\Core\Updater\Migrations\Migrations\Version20170613000000->upgradeDatabase() at /var/www/concrete5/concrete/src/Updater/Migrations/AbstractMigration.php:84

Concrete\Core\Updater\Migrations\AbstractMigration->postUp() at /var/www/concrete5/concrete/vendor/doctrine/migrations/lib/Doctrine/DBAL/Migrations/Version.php:297

Doctrine\DBAL\Migrations\Version->execute() at /var/www/concrete5/concrete/src/Updater/Update.php:220

Concrete\Core\Updater\Update::updateToCurrentVersion() at /var/www/concrete5/concrete/src/Console/Command/UpdateCommand.php:92

Concrete\Core\Console\Command\UpdateCommand->Concrete\Core\Console\Command\{closure}() at /var/www/concrete5/concrete/src/System/Mutex/SemaphoreMutex.php:139

Concrete\Core\System\Mutex\SemaphoreMutex->execute() at /var/www/concrete5/concrete/src/Console/Command/UpdateCommand.php:93

Concrete\Core\Console\Command\UpdateCommand->execute() at /var/www/concrete5/concrete/vendor/symfony/console/Command/Command.php:255

Symfony\Component\Console\Command\Command->run() at /var/www/concrete5/concrete/src/Console/Command.php:186

Concrete\Core\Console\Command->run() at /var/www/concrete5/concrete/vendor/symfony/console/Application.php:963

Symfony\Component\Console\Application->doRunCommand() at /var/www/concrete5/concrete/vendor/symfony/console/Application.php:254

Symfony\Component\Console\Application->doRun() at /var/www/concrete5/concrete/vendor/symfony/console/Application.php:147

Symfony\Component\Console\Application->run() at /var/www/concrete5/concrete/src/Foundation/Runtime/Run/CLIRunner.php:70

Concrete\Core\Foundation\Runtime\Run\CLIRunner->run() at /var/www/concrete5/concrete/src/Foundation/Runtime/DefaultRuntime.php:102

Concrete\Core\Foundation\Runtime\DefaultRuntime->run() at /var/www/concrete5/concrete/dispatcher.php:45

require() at /var/www/concrete5/concrete/bin/concrete5:85

c5:update [--env ENV] [--allow-as-root] [--rerun] [-a|--after AFTER] [-s|--since SINCE]

[Error] Upgrade failed.

/etc/kernel/postrm.d/initramfs-tools:

update-initramfs: Deleting /boot/initrd.img-4.19.0-14-686

/etc/kernel/postrm.d/zz-update-grub:

Generating grub configuration file ...

Found linux image: /boot/vmlinuz-4.19.0-17-686

Found initrd image: /boot/initrd.img-4.19.0-17-686

Found linux image: /boot/vmlinuz-4.19.0-16-686

Found initrd image: /boot/initrd.img-4.19.0-16-686

done

sh: 0: getcwd() failed: No such file or directory

sh: 0: getcwd() failed: No such file or directory

sh: 0: getcwd() failed: No such file or directory

sh: 0: getcwd() failed: No such file or directory

Cette action a laissé des paquets non configurés par dpkg/apt (les gestionnaires de paquets du système) … Vous pouvez essayer de résoudre ce problème en vous connectant via SSH et en exécutant `sudo apt install --fix-broken` et/ou `sudo dpkg --configure -a`.

sh: 0: getcwd() failed: No such file or directory

sh: 0: getcwd() failed: No such file or directory

sh: 0: getcwd() failed: No such file or directory

sh: 0: getcwd() failed: No such file or directory

sh: 0: getcwd() failed: No such file or directory

sh: 0: getcwd() failed: No such file or directory

sh: 0: getcwd() failed: No such file or directory

sh: 0: getcwd() failed: No such file or directory

sh: 0: getcwd() failed: No such file or directory

sh: 0: getcwd() failed: No such file or directory

sh: 0: getcwd() failed: No such file or directory

sh: 0: getcwd() failed: No such file or directory

sh: 0: getcwd() failed: No such file or directory

sh: 0: getcwd() failed: No such file or directory

sh: 0: getcwd() failed: No such file or directory

sh: 0: getcwd() failed: No such file or directory

sh: 0: getcwd() failed: No such file or directory

30721 W: An error occurred during the signature verification. The repository is not updated and the previous index files will be used. GPG error: https://packages.sury.org/php buster InRelease: The following signatures were invalid: EXPKEYSIG B188E2B695BD4743 DEB.SURY.ORG Automatic Signing Key

30724 W: Failed to fetch https://packages.sury.org/php/dists/buster/InRelease The following signatures were invalid: EXPKEYSIG B188E2B695BD4743 DEB.SURY.ORG Automatic Signing Key

30726 W: Some index files failed to download. They have been ignored, or old ones used instead.

45831 W: An error occurred during the signature verification. The repository is not updated and the previous index files will be used. GPG error: https://packages.sury.org/php buster InRelease: The following signatures were invalid: EXPKEYSIG B188E2B695BD4743 DEB.SURY.ORG Automatic Signing Key

45832 W: Failed to fetch https://packages.sury.org/php/dists/buster/InRelease The following signatures were invalid: EXPKEYSIG B188E2B695BD4743 DEB.SURY.ORG Automatic Signing Key

45832 W: Some index files failed to download. They have been ignored, or old ones used instead.

sh: 0: getcwd() failed: No such file or directory

sh: 0: getcwd() failed: No such file or directory

sh: 0: getcwd() failed: No such file or directory

The app was restored to the way it was before the failed upgrade.

Impossible de mettre à jour concrete5 : Une erreur s’est produite durant l’exécution du script de mise à niveau de l’application

**L’opération 'Mettre à jour l’application 'concrete5'' a échoué ! Pour obtenir de l’aide, merci de partager le journal de l’opération en [cliquant ici](https://192.168.1.49/yunohost/admin/#/tools/logs/20210831-104414-app_upgrade-concrete5)**

L’application concrete5 n’a pas été mise à jour et par conséquence les applications suivantes n’ont pas été mises à jour : concrete5, roundcube, redirect

unable to upgrade apps: **L’opération 'Mettre à jour l’application 'concrete5'' a échoué ! Pour obtenir de l’aide, merci de partager le journal de l’opération en [cliquant ici](https://192.168.1.49/yunohost/admin/#/tools/logs/20210831-104414-app_upgrade-concrete5)**

merci pour votre aide

je copie/colle un journal

Voir probablement la deuxieme partie de : Recurring issues during system updates these days, and how to fix them

1 Like

tituspijean comment fais-tu ce truc avec les barres sur les côtés ?

donc j’ai passé les commandes indiquées :

sudo apt del 95BD4743;
wget -nv -O - https://packages.sury.org/php/apt.gpg | sudo apt add -

et relancé une mise à jour,
Il a mis à jour un tas de paquets php.
mais les clicks sur les sections dans l’interface admin citées plus hauts sont toujours inopérants.

BEAUCOUP PLUS PREOCCUPANT je crois :
Maintenant dans le diagnostic en ligne de commande j’obtiens :

Le service yunohost-api est dead :-(
Le service yunohost-firewall est failed :-(

Comme indiqué j’ai passé les commandes :
sudo yunohost service restart yunohost-api
sudo yunohost service restart yunohost-firewall

en relançant le diagnostic j’ai denouveau les deux même messages.

update 19h53

j’ai fait :

apt install yunohost-admin

Ca n’a rien changé
20h00

sudo apt install -f 

ne me donne que des 0
20h10
Voici le diagnostic complet
https://paste.yunohost.org/imutupaquh.sql

Il faut utiliser une triplette d’accents graves avant et après les logs: ```

```
Ceci est un log
```

devient

Ceci est un log

La zone de texte est automatiquement limitée en hauteur pour éviter des pages et des pages de texte illisible. :wink:

Et histoire d’être pédant jusqu’au bout, c’est expliqué dans le canevas quand tu crées un nouveau sujet dans la catégorie Support. :innocent:

2 Likes

@pigeon_1 : est-ce qu’il est résolu ton problème ? Si oui comment ? J’ai exactement le même soucis, mais les 2 manips dans le message d’Aleks ne donnent rien.

Tomdereub,
Oui le problème est résolu mais je n’ai pas compris pourquoi -je ne suis pas bon en informatique-.
voila ce que j’ai fait :
-mettre un sudo devant la deuxième commande du message d’Aleks.
-j’ai fait toutes les commandes que tu peux trouver en bas de mon message (elles ne risquent rien.)
-après la dernière commande j’ai redémarré le serveur et constaté que rien de ce que j’avais fait n’avait reglé le problème et je suis allé me coucher.
-Quand je me suis remis dessus 20h00 après le problème était reglé.

Je n’ai fait aucun rite vaudou

Ok, je vais attendre 20h alors. Merci !

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.