Le 08/02/2016 17:46, Michal Čihař a écrit :
Hi
Dne 30.1.2016 v 18:49 Guy Durrieu napsal(a):
I never did anything manually on the phpadmin database.
Probably I prevously had installed the 4:4.5.0.2-1 version; all worked
fine until the last upgrade (4:4.5.4-1 yesterday); now debian only
proposes 4.4.2.12-2+deb8u1 as possible alternative.
Okay, it seems that phpmyadmin can do auto upgrade of the tables when
accessed with enough privileges. This seems to collide with dbconfig
upgrade we're using. I need to figure out best approach to handle this.
To workaround this for now, you can execute following query:
ALTER TABLE `pma__column_info`
DROP `input_transformation`,
DROP `input_transformation_options`;
And the upgrade should work.
Hi Michal,
Thanks for your help.
I tried the workaround you suggest.
After removing the above columns, the upgrade seems correctly done (no
error displayed):
---
aptitude safe-upgrade
Résolution des dépendances…
Les paquets suivants seront mis à jour :
phpmyadmin
1 paquets mis à jour, 0 nouvellement installés, 0 à enlever et 7 non mis
à jour.
Il est nécessaire de télécharger 0 o/4 018 ko d'archives. Après
dépaquetage, 563 ko seront utilisés.
Voulez-vous continuer ? [Y/n/?]
Lecture des fichiers de modifications (« changelog »)... Terminé
Préconfiguration des paquets...
(Lecture de la base de données... 364760 fichiers et répertoires déjà
installés.)
Préparation du dépaquetage de .../phpmyadmin_4%3a4.5.4-1_all.deb ...
Dépaquetage de phpmyadmin (4:4.5.4-1) sur (4:4.2.12-2+deb8u1) ...
Traitement des actions différées (« triggers ») pour hicolor-icon-theme
(0.13-1) ...
Traitement des actions différées (« triggers ») pour man-db (2.7.5-1) ...
Paramétrage de phpmyadmin (4:4.5.4-1) ...
Installation de la nouvelle version du fichier de configuration
/etc/phpmyadmin/apache.conf ...
Installation de la nouvelle version du fichier de configuration
/etc/phpmyadmin/config.inc.php ...
dbconfig-common: writing config to /etc/dbconfig-common/phpmyadmin.conf
creating database backup in
/var/cache/dbconfig-common/backups/phpmyadmin_4:4.2.12-2+deb8u1.2016-02-08-22.29.21.
applying upgrade sql for 4:4.2.12-2+deb8u1 -> 4:4.5.0.2-1.
dbconfig-common: flushing administrative password
apache2_invoke phpmyadmin: already enabled
---
(in french again, sorry).
However, phpmyadmin still doesn't work (empty screen with iceweasel,
error 500 displayed with chromium).
-- GD.
