Écrire Une Réponse

almg: 2010-05-19 12:04:55

J'ai supprimé les 2 tables...relancé l'upgrade et super tout fonctionne à nouveau...du coup il fait beau dehors.
Le site des pérégrinations de ma fille en Australie est de nouveau visible...
Merci énormément pour ton aide et ton suivi...
Bonne journée
Alain

plg: 2010-05-19 11:50:22

OK almg (VDigital, la colonne upgrade.id est un varchar, ça explique qu'on n'ait pas 79 en premier).

Bon alors, je pense que tu as fait une install de 2.1.0RCx a un moment donné sur cette base, un truc dans ce genre, en tout cas il y a une table piwigo_themes qui traîne là alors qu'elle ne devrait pas.

1) supprimes la table piwigo_themes
2) supprimes la table piwigo_languages

Relances http://did.marielle.oz.free.fr/piwigo/upgrade.php

almg: 2010-05-19 11:43:54

La requête de Vdigital donne ceci :

id applied description
9 2010-01-11 00:29:38 upgrade included in installation
8 2010-01-11 00:29:38 upgrade included in installation
79 2010-01-11 00:29:38 upgrade included in installation
78 2010-01-11 00:29:38 upgrade included in installation
77 2010-01-11 00:29:38 upgrade included in installation
76 2010-01-11 00:29:38 upgrade included in installation
75 2010-01-11 00:29:38 upgrade included in installation
74 2010-01-11 00:29:38 upgrade included in installation
73 2010-01-11 00:29:38 upgrade included in installation
72 2010-01-11 00:29:38 upgrade included in installation
71 2010-01-11 00:29:38 upgrade included in installation
70 2010-01-11 00:29:38 upgrade included in installation
7 2010-01-11 00:29:38 upgrade included in installation
69 2010-01-11 00:29:38 upgrade included in installation
68 2010-01-11 00:29:38 upgrade included in installation
67 2010-01-11 00:29:38 upgrade included in installation
66 2010-01-11 00:29:38 upgrade included in installation
65 2010-01-11 00:29:38 upgrade included in installation
64 2010-01-11 00:29:38 upgrade included in installation
63 2010-01-11 00:29:38 upgrade included in installation

plg: 2010-05-19 11:39:56

OK, et la requête de VDigital ?

Code:

select * from piwigo_upgrade order by id desc limit 20;

almg: 2010-05-19 11:36:24

J'ai relancé la requete :

résultat :

id applied description
9 2010-01-11 00:29:38 upgrade included in installation
61 2010-01-11 00:29:38 upgrade included in installation
60 2010-01-11 00:29:38 upgrade included in installation
6 2010-01-11 00:29:38 upgrade included in installation
59 2010-01-11 00:29:38 upgrade included in installation
58 2010-01-11 00:29:38 upgrade included in installation
57 2010-01-11 00:29:38 upgrade included in installation
56 2010-01-11 00:29:38 upgrade included in installation
55 2010-01-11 00:29:38 upgrade included in installation
54 2010-01-11 00:29:38 upgrade included in installation
53 2010-01-11 00:29:38 upgrade included in installation
52 2010-01-11 00:29:38 upgrade included in installation
51 2010-01-11 00:29:38 upgrade included in installation
50 2010-01-11 00:29:38 upgrade included in installation
5 2010-01-11 00:29:38 upgrade included in installation
49 2010-01-11 00:29:38 upgrade included in installation
48 2010-01-11 00:29:38 upgrade included in installation
47 2010-01-11 00:29:38 upgrade included in installation
62 2010-01-11 00:29:38 upgrade included in installation
63 2010-01-11 00:29:38 upgrade included in installation

la table ressemble à ceci si ça peut t'aider

id version name
clear 3 clear
dark 1 dark
Sylvia 1 Sylvia

plg: 2010-05-19 10:49:17

almg a écrit:
Oui, j'ai bien la table piwigo themes

je ne comprends pas alors :-/ tu es sûr que tu as lancé la bonne requête sur ta base de données ?

almg: 2010-05-19 10:42:09

Oui, j'ai bien la table piwigo themes

bva25j: 2010-05-19 10:20:58

plg a écrit:
almg a écrit:
Bonsoir,
J'ai fait la mise à jour dans plusieurs site, tous sous Free, sans problème.
Mais dans celui ci : http://did.marielle.oz.free.fr/piwigo/
J'ai une pleine page de texte qui commence par

Warning: [mysql error 1054] Unknown column 'ui.theme' in 'on clause'

bref ça n'a pas fonctionné correctement ! Pourquoi ?

Bien cordialement
Alain

J'ai le même problème sur mon site www.belimage.be/piwigo

Je vais réinstaller la version 2,0,10

et refaire l'upgrade

Bien à vous

Benoît

VDigital: 2010-05-19 10:15:52

Migration d'une 2.0...RCx vers 2.1 ???

VDigital: 2010-05-19 10:14:16

Puis-je suggérer:

select * from piwigo_upgrade order by id desc limit 20;

plg: 2010-05-19 09:49:24

OK, donc il n'y a pas l'upgrade numéro 90. Ni l'upgrade 81. Donc l'upgrade.php n'a pas été appliqué. Or quand je vais sur upgrade.php, il me dit :

No upgrade required, the database structure is up to date

Peux-tu confirmer que tu as la table piwigo_themes ?

almg: 2010-05-19 09:39:35

Salut,
J'ai fais la requete, ça donne ceci :

id applied description
9 2010-01-11 00:29:38 upgrade included in installation
61 2010-01-11 00:29:38 upgrade included in installation
60 2010-01-11 00:29:38 upgrade included in installation
6 2010-01-11 00:29:38 upgrade included in installation
59 2010-01-11 00:29:38 upgrade included in installation
58 2010-01-11 00:29:38 upgrade included in installation
57 2010-01-11 00:29:38 upgrade included in installation
56 2010-01-11 00:29:38 upgrade included in installation
55 2010-01-11 00:29:38 upgrade included in installation
54 2010-01-11 00:29:38 upgrade included in installation
53 2010-01-11 00:29:38 upgrade included in installation
52 2010-01-11 00:29:38 upgrade included in installation
51 2010-01-11 00:29:38 upgrade included in installation
50 2010-01-11 00:29:38 upgrade included in installation
5 2010-01-11 00:29:38 upgrade included in installation
49 2010-01-11 00:29:38 upgrade included in installation
48 2010-01-11 00:29:38 upgrade included in installation
47 2010-01-11 00:29:38 upgrade included in installation
62 2010-01-11 00:29:38 upgrade included in installation
63 2010-01-11 00:29:38 upgrade included in installation

Fredphoto91: 2010-05-19 00:18:37

OK désolé, j'ouvre un autre topic

plg: 2010-05-19 00:16:39

Fredphoto91 quels éléments te font penser que tu as exactement le même problème que almg ? (parce que sinon, c'est bien d'ouvrir un autre topic, ça ne coûte pas plus cher ;-) et ça nous aide à organiser le support.

Dans ton cas, l'upgrade n'a manifestement pas été lancé, mais ouvres donc un autre topic, ce sera plus commode pour t'aider et le passer "résolu".

Fredphoto91: 2010-05-18 23:53:52

Dans mon cas, voila ce que me renvoie la requète

id applied description
9 2010-01-08 21:01:51 upgrade included in installation
61 2010-01-08 21:01:51 upgrade included in installation
60 2010-01-08 21:01:51 upgrade included in installation
6 2010-01-08 21:01:51 upgrade included in installation
59 2010-01-08 21:01:51 upgrade included in installation
58 2010-01-08 21:01:51 upgrade included in installation
57 2010-01-08 21:01:51 upgrade included in installation
56 2010-01-08 21:01:51 upgrade included in installation
55 2010-01-08 21:01:51 upgrade included in installation
54 2010-01-08 21:01:51 upgrade included in installation
53 2010-01-08 21:01:51 upgrade included in installation
52 2010-01-08 21:01:51 upgrade included in installation
51 2010-01-08 21:01:51 upgrade included in installation
50 2010-01-08 21:01:51 upgrade included in installation
5 2010-01-08 21:01:51 upgrade included in installation
49 2010-01-08 21:01:51 upgrade included in installation
48 2010-01-08 21:01:51 upgrade included in installation
47 2010-01-08 21:01:51 upgrade included in installation
62 2010-01-08 21:01:51 upgrade included in installation
63 2010-01-08 21:01:51 upgrade included in installation

Piwigo.org

Annonce

Écrire une réponse

Résumé de la discussion (messages les plus récents en premier)

Code:

almg a écrit:

plg a écrit:

almg a écrit:

Pied de page des forums