Piwigo.org

thomorph · 2013-07-07 23:01:04

Salut,

Je viens de mettre a jour ma galerie ainsi que mes plugins, dont register FluxBB
Cependant j'obtient maintenant

Code:

Warning:  [mysql error 1054] Unknown column 'PwdSynch' in 'field list'

SELECT PwdSynch
FROM piwigo_Register_FluxBB_id
WHERE id_user_pwg=19
; in /mnt/113/sdb/a/4/achr68/piwigo/include/dblayer/functions_mysql.inc.php on line 795


Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/113/sdb/a/4/achr68/piwigo/include/dblayer/functions_mysql.inc.php on line 154



Warning:  [mysql error 1054] Unknown column 'PwdSynch' in 'field list'

SELECT PwdSynch
FROM piwigo_Register_FluxBB_id
WHERE id_user_pwg=19
; in /mnt/113/sdb/a/4/achr68/piwigo/include/dblayer/functions_mysql.inc.php on line 795


Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/113/sdb/a/4/achr68/piwigo/include/dblayer/functions_mysql.inc.php on line 154



Warning:  [mysql error 1054] Unknown column 'PwdSynch' in 'field list'

SELECT PwdSynch
FROM piwigo_Register_FluxBB_id
WHERE id_user_pwg=7
; in /mnt/113/sdb/a/4/achr68/piwigo/include/dblayer/functions_mysql.inc.php on line 795


Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/113/sdb/a/4/achr68/piwigo/include/dblayer/functions_mysql.inc.php on line 154



Warning:  [mysql error 1054] Unknown column 'PwdSynch' in 'field list'

SELECT PwdSynch
FROM piwigo_Register_FluxBB_id
WHERE id_user_pwg=7
; in /mnt/113/sdb/a/4/achr68/piwigo/include/dblayer/functions_mysql.inc.php on line 795


Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/113/sdb/a/4/achr68/piwigo/include/dblayer/functions_mysql.inc.php on line 154



Warning:  [mysql error 1054] Unknown column 'PwdSynch' in 'field list'

SELECT PwdSynch
FROM piwigo_Register_FluxBB_id
WHERE id_user_pwg=15
; in /mnt/113/sdb/a/4/achr68/piwigo/include/dblayer/functions_mysql.inc.php on line 795


Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/113/sdb/a/4/achr68/piwigo/include/dblayer/functions_mysql.inc.php on line 154



Warning:  [mysql error 1054] Unknown column 'PwdSynch' in 'field list'

SELECT PwdSynch
FROM piwigo_Register_FluxBB_id
WHERE id_user_pwg=15
; in /mnt/113/sdb/a/4/achr68/piwigo/include/dblayer/functions_mysql.inc.php on line 795


Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/113/sdb/a/4/achr68/piwigo/include/dblayer/functions_mysql.inc.php on line 154



Warning:  [mysql error 1054] Unknown column 'PwdSynch' in 'field list'

SELECT PwdSynch
FROM piwigo_Register_FluxBB_id
WHERE id_user_pwg=6
; in /mnt/113/sdb/a/4/achr68/piwigo/include/dblayer/functions_mysql.inc.php on line 795


Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/113/sdb/a/4/achr68/piwigo/include/dblayer/functions_mysql.inc.php on line 154



Warning:  [mysql error 1054] Unknown column 'PwdSynch' in 'field list'

SELECT PwdSynch
FROM piwigo_Register_FluxBB_id
WHERE id_user_pwg=6
; in /mnt/113/sdb/a/4/achr68/piwigo/include/dblayer/functions_mysql.inc.php on line 795


Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/113/sdb/a/4/achr68/piwigo/include/dblayer/functions_mysql.inc.php on line 154



Warning:  [mysql error 1054] Unknown column 'PwdSynch' in 'field list'

SELECT PwdSynch
FROM piwigo_Register_FluxBB_id
WHERE id_user_pwg=12
; in /mnt/113/sdb/a/4/achr68/piwigo/include/dblayer/functions_mysql.inc.php on line 795


Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/113/sdb/a/4/achr68/piwigo/include/dblayer/functions_mysql.inc.php on line 154



Warning:  [mysql error 1054] Unknown column 'PwdSynch' in 'field list'

SELECT PwdSynch
FROM piwigo_Register_FluxBB_id
WHERE id_user_pwg=12
; in /mnt/113/sdb/a/4/achr68/piwigo/include/dblayer/functions_mysql.inc.php on line 795


Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/113/sdb/a/4/achr68/piwigo/include/dblayer/functions_mysql.inc.php on line 154



Warning:  [mysql error 1054] Unknown column 'PwdSynch' in 'field list'

SELECT PwdSynch
FROM piwigo_Register_FluxBB_id
WHERE id_user_pwg=16
; in /mnt/113/sdb/a/4/achr68/piwigo/include/dblayer/functions_mysql.inc.php on line 795


Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/113/sdb/a/4/achr68/piwigo/include/dblayer/functions_mysql.inc.php on line 154



Warning:  [mysql error 1054] Unknown column 'PwdSynch' in 'field list'

SELECT PwdSynch
FROM piwigo_Register_FluxBB_id
WHERE id_user_pwg=16
; in /mnt/113/sdb/a/4/achr68/piwigo/include/dblayer/functions_mysql.inc.php on line 795


Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/113/sdb/a/4/achr68/piwigo/include/dblayer/functions_mysql.inc.php on line 154



Warning:  [mysql error 1054] Unknown column 'PwdSynch' in 'field list'

SELECT PwdSynch
FROM piwigo_Register_FluxBB_id
WHERE id_user_pwg=17
; in /mnt/113/sdb/a/4/achr68/piwigo/include/dblayer/functions_mysql.inc.php on line 795


Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/113/sdb/a/4/achr68/piwigo/include/dblayer/functions_mysql.inc.php on line 154



Warning:  [mysql error 1054] Unknown column 'PwdSynch' in 'field list'

SELECT PwdSynch
FROM piwigo_Register_FluxBB_id
WHERE id_user_pwg=17
; in /mnt/113/sdb/a/4/achr68/piwigo/include/dblayer/functions_mysql.inc.php on line 795


Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/113/sdb/a/4/achr68/piwigo/include/dblayer/functions_mysql.inc.php on line 154



Warning:  [mysql error 1054] Unknown column 'PwdSynch' in 'field list'

SELECT PwdSynch
FROM piwigo_Register_FluxBB_id
WHERE id_user_pwg=11
; in /mnt/113/sdb/a/4/achr68/piwigo/include/dblayer/functions_mysql.inc.php on line 795


Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/113/sdb/a/4/achr68/piwigo/include/dblayer/functions_mysql.inc.php on line 154



Warning:  [mysql error 1054] Unknown column 'PwdSynch' in 'field list'

SELECT PwdSynch
FROM piwigo_Register_FluxBB_id
WHERE id_user_pwg=11
; in /mnt/113/sdb/a/4/achr68/piwigo/include/dblayer/functions_mysql.inc.php on line 795


Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/113/sdb/a/4/achr68/piwigo/include/dblayer/functions_mysql.inc.php on line 154



Warning:  [mysql error 1054] Unknown column 'PwdSynch' in 'field list'

SELECT PwdSynch
FROM piwigo_Register_FluxBB_id
WHERE id_user_pwg=3
; in /mnt/113/sdb/a/4/achr68/piwigo/include/dblayer/functions_mysql.inc.php on line 795


Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/113/sdb/a/4/achr68/piwigo/include/dblayer/functions_mysql.inc.php on line 154



Warning:  [mysql error 1054] Unknown column 'PwdSynch' in 'field list'

SELECT PwdSynch
FROM piwigo_Register_FluxBB_id
WHERE id_user_pwg=3
; in /mnt/113/sdb/a/4/achr68/piwigo/include/dblayer/functions_mysql.inc.php on line 795


Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/113/sdb/a/4/achr68/piwigo/include/dblayer/functions_mysql.inc.php on line 154



Warning:  [mysql error 1054] Unknown column 'PwdSynch' in 'field list'

SELECT PwdSynch
FROM piwigo_Register_FluxBB_id
WHERE id_user_pwg=9
; in /mnt/113/sdb/a/4/achr68/piwigo/include/dblayer/functions_mysql.inc.php on line 795


Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/113/sdb/a/4/achr68/piwigo/include/dblayer/functions_mysql.inc.php on line 154



Warning:  [mysql error 1054] Unknown column 'PwdSynch' in 'field list'

SELECT PwdSynch
FROM piwigo_Register_FluxBB_id
WHERE id_user_pwg=9
; in /mnt/113/sdb/a/4/achr68/piwigo/include/dblayer/functions_mysql.inc.php on line 795


Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/113/sdb/a/4/achr68/piwigo/include/dblayer/functions_mysql.inc.php on line 154



Warning:  [mysql error 1054] Unknown column 'PwdSynch' in 'field list'

SELECT PwdSynch
FROM piwigo_Register_FluxBB_id
WHERE id_user_pwg=8
; in /mnt/113/sdb/a/4/achr68/piwigo/include/dblayer/functions_mysql.inc.php on line 795


Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/113/sdb/a/4/achr68/piwigo/include/dblayer/functions_mysql.inc.php on line 154



Warning:  [mysql error 1054] Unknown column 'PwdSynch' in 'field list'

SELECT PwdSynch
FROM piwigo_Register_FluxBB_id
WHERE id_user_pwg=8
; in /mnt/113/sdb/a/4/achr68/piwigo/include/dblayer/functions_mysql.inc.php on line 795


Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/113/sdb/a/4/achr68/piwigo/include/dblayer/functions_mysql.inc.php on line 154



Warning:  [mysql error 1054] Unknown column 'PwdSynch' in 'field list'

SELECT PwdSynch
FROM piwigo_Register_FluxBB_id
WHERE id_user_pwg=18
; in /mnt/113/sdb/a/4/achr68/piwigo/include/dblayer/functions_mysql.inc.php on line 795


Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/113/sdb/a/4/achr68/piwigo/include/dblayer/functions_mysql.inc.php on line 154



Warning:  [mysql error 1054] Unknown column 'PwdSynch' in 'field list'

SELECT PwdSynch
FROM piwigo_Register_FluxBB_id
WHERE id_user_pwg=18
; in /mnt/113/sdb/a/4/achr68/piwigo/include/dblayer/functions_mysql.inc.php on line 795


Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/113/sdb/a/4/achr68/piwigo/include/dblayer/functions_mysql.inc.php on line 154



Warning:  [mysql error 1054] Unknown column 'PwdSynch' in 'field list'

SELECT PwdSynch
FROM piwigo_Register_FluxBB_id
WHERE id_user_pwg=20
; in /mnt/113/sdb/a/4/achr68/piwigo/include/dblayer/functions_mysql.inc.php on line 795


Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/113/sdb/a/4/achr68/piwigo/include/dblayer/functions_mysql.inc.php on line 154



Warning:  [mysql error 1054] Unknown column 'PwdSynch' in 'field list'

SELECT PwdSynch
FROM piwigo_Register_FluxBB_id
WHERE id_user_pwg=20
; in /mnt/113/sdb/a/4/achr68/piwigo/include/dblayer/functions_mysql.inc.php on line 795


Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/113/sdb/a/4/achr68/piwigo/include/dblayer/functions_mysql.inc.php on line 154



Warning:  [mysql error 1054] Unknown column 'PwdSynch' in 'field list'

SELECT PwdSynch
FROM piwigo_Register_FluxBB_id
WHERE id_user_pwg=5
; in /mnt/113/sdb/a/4/achr68/piwigo/include/dblayer/functions_mysql.inc.php on line 795


Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/113/sdb/a/4/achr68/piwigo/include/dblayer/functions_mysql.inc.php on line 154



Warning:  [mysql error 1054] Unknown column 'PwdSynch' in 'field list'

SELECT PwdSynch
FROM piwigo_Register_FluxBB_id
WHERE id_user_pwg=5
; in /mnt/113/sdb/a/4/achr68/piwigo/include/dblayer/functions_mysql.inc.php on line 795


Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/113/sdb/a/4/achr68/piwigo/include/dblayer/functions_mysql.inc.php on line 154



Warning:  [mysql error 1054] Unknown column 'PwdSynch' in 'field list'

SELECT PwdSynch
FROM piwigo_Register_FluxBB_id
WHERE id_user_pwg=1
; in /mnt/113/sdb/a/4/achr68/piwigo/include/dblayer/functions_mysql.inc.php on line 795


Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/113/sdb/a/4/achr68/piwigo/include/dblayer/functions_mysql.inc.php on line 154



Warning:  [mysql error 1054] Unknown column 'PwdSynch' in 'field list'

SELECT PwdSynch
FROM piwigo_Register_FluxBB_id
WHERE id_user_pwg=1
; in /mnt/113/sdb/a/4/achr68/piwigo/include/dblayer/functions_mysql.inc.php on line 795


Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/113/sdb/a/4/achr68/piwigo/include/dblayer/functions_mysql.inc.php on line 154



Warning:  [mysql error 1054] Unknown column 'PwdSynch' in 'field list'

SELECT PwdSynch
FROM piwigo_Register_FluxBB_id
WHERE id_user_pwg=14
; in /mnt/113/sdb/a/4/achr68/piwigo/include/dblayer/functions_mysql.inc.php on line 795


Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/113/sdb/a/4/achr68/piwigo/include/dblayer/functions_mysql.inc.php on line 154



Warning:  [mysql error 1054] Unknown column 'PwdSynch' in 'field list'

SELECT PwdSynch
FROM piwigo_Register_FluxBB_id
WHERE id_user_pwg=14
; in /mnt/113/sdb/a/4/achr68/piwigo/include/dblayer/functions_mysql.inc.php on line 795

en faisant un audit.

Une idée du problème?

Merci

thomorph · 2013-07-07 23:27:18

Code:

Warning:  [mysql error 1054] Unknown column 'PwdSynch' in 'field list'

SELECT PwdSynch
FROM piwigo_Register_FluxBB_id
WHERE id_user_pwg=1
; in /mnt/113/sdb/a/4/achr68/piwigo/include/dblayer/functions_mysql.inc.php on line 795


Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/113/sdb/a/4/achr68/piwigo/include/dblayer/functions_mysql.inc.php on line 154

Warning: Cannot modify header information - headers already sent by (output started at /mnt/113/sdb/a/4/achr68/piwigo/include/dblayer/functions_mysql.inc.php:794) in /mnt/113/sdb/a/4/achr68/piwigo/include/page_header.php on line 101

Message d'erreur après un login sur ma galerie

ddtddt · 2013-07-08 07:21:31

Bonjour,

As tu désactivé et réactivé le plugin ?

les mise à jour auto le fond et cela permet de déclencher les mise à jour de base de données dans le plugin.

thomorph · 2013-07-08 10:17:41

même résultat.
Et j'obtient la liste de mes comptes en rouge avec mauvaise synchronisation
Et ok pour le reste...

Et dans la partie profil plus j'ai : " Veuillez modifier votre mot de passe pour synchronisation avec l'accès au forum. Vous pourrez alors vous connecter au forum avec le même compte que pour la galerie. "

Dernière modification par thomorph (2013-07-08 10:18:45)

Eric · 2013-07-08 12:49:18

Bonjour,

Depuis la version 2.5.4 de Register_FluxBB, il y a une fonction de synchronisation des mots de passe entre FluxBB et Piwigo. De fait, si on réinitialise l'installation du plugin, il considère que tous les mots de passe de comptes ne sont plus synchronisés. D'où les informations en rouge lors de l'audit et l'incitation de modifier le mot de passe pour chaque utilisateur déjà inscrit.

Pour le problème "Warning: [mysql error 1054] Unknown column 'PwdSynch' in 'field list'", est-ce toujours d'actualité après la réinitialisation du plugin ? Je pense que c'est une mauvaise mise à jour qui a généré ce message.

thomorph · 2013-07-08 14:30:48

Ouai j'ai toujoursle warning.
Mais donc pour la mauvaise synchro je fais quoi?

Eric · 2013-07-08 18:01:50

Pour la synchro des mots de passe, c'est indiqué : " Veuillez modifier votre mot de passe pour synchronisation avec l'accès au forum. Vous pourrez alors vous connecter au forum avec le même compte que pour la galerie. "

Mais ne fais rien pour l'instant à cause du warning. C'est anormal. Il semblerait que le plugin se soit mal mis à jour. J'aimerai un lien vers ta galerie liée à ton forum avec un accès webmaster, stp (par MP). Je regarderai ce qui cloche.

thomorph · 2013-07-08 18:37:44

Envoyé en PM

Eric · 2013-07-08 18:55:28

Ok... Vraiment bizarre. On dirait que le plugin s'est correctement mis à jour sauf la base de données.

Pour régler le problème des warnings, connectes-toi à ta base de données via PhpMyAdmin et lance la requête SQL suivante en remplaçant [prefixePiwigo] par ton préfixe des tables de ta galerie (par défaut, ce devrait être "piwigo") :

Code:

ALTER TABLE [prefixePiwigo]_register_fluxbb_id ADD PwdSynch VARCHAR(3) NULL DEFAULT NULL;

J'attends ton retour l'exécution de cette requête.

thomorph · 2013-07-08 20:02:16

"#1146 - Table 'achr68.piwigo_register_fluxbb_id' doesn't exist"

:-(

Eric · 2013-07-08 21:00:33

Voila, c'est réparé.
Il a fallu réinitialiser complètement le plugin. A croire que la base de données ne s'était pas du tout installée. Première fois que je vois çà...

thomorph · 2013-07-09 11:17:41

les warning ont disparu.
Je me suis connecté, il m'a demandé un nouveau pass, j'ai gardé l'ancien (fait de même avec un 2e compte et pas de problèmes) car mes utilisateurs moins y a de changements mieux ils se portent.

Je voulais savoir maintenant dans audit il trouve des liaisons a réparer, je peux faire synchronisation même si les utilisateurs ont pas encore rentré de nouveaux mdp?

Eric · 2013-07-09 17:41:27

Pas de synchro totale car cela réinitialiserait tous les comptes dans ton forum FluxBB. Si tu as des liaisons à réparer dans l'audit, traites-les individuellement (icones en face de chaque lignes concernées).

Mais c'est tout de même étrange car je n'ai pas vu de problème de synchro hier, sauf pour les mots de passe. Là, il n'y a pas de synchro manuelle possible via l'interface d'admin du plugin. Il faut que chaque utilisateur concerné modifie son mot de passe lorsque demandé lors de sa prochaine connexion.

Ceci est dû au fait que FluxBB n'utilise pas le même système de chiffrement des mots de passe que Piwigo. Et impossible de décrypter un mot de passe Piwigo pour le réencrypter dans le format attendu par FluxBB. D'où la nécessité de ressaisir un nouveau mot de passe (ou le même) pour caler tout cela.

thomorph · 2013-07-09 20:41:01

donc concernant les liaisons a problèmes, je dois attendre que les membres se connectes pour réparer individuellement la liaison ou je peux quand même le faire?

Merci pour ton aide

Eric · 2013-07-09 22:46:31

Quel est l'intitulé des problèmes de synchro ?
Encore une fois, s'il ne s'agit que de la synchro sur les mots de passe, tu ne peux rien corriger par toi-même. Seuls les utilisateurs le peuvent.

Piwigo.org

Annonce

#1 2013-07-07 23:01:04

[Résolu] Erreur Register FluxBB

Code:

#2 2013-07-07 23:27:18

Re: [Résolu] Erreur Register FluxBB

Code:

#3 2013-07-08 07:21:31

Re: [Résolu] Erreur Register FluxBB

#4 2013-07-08 10:17:41

Re: [Résolu] Erreur Register FluxBB

#5 2013-07-08 12:49:18

Re: [Résolu] Erreur Register FluxBB

#6 2013-07-08 14:30:48

Re: [Résolu] Erreur Register FluxBB

#7 2013-07-08 18:01:50

Re: [Résolu] Erreur Register FluxBB

#8 2013-07-08 18:37:44

Re: [Résolu] Erreur Register FluxBB

#9 2013-07-08 18:55:28

Re: [Résolu] Erreur Register FluxBB

Code:

#10 2013-07-08 20:02:16

Re: [Résolu] Erreur Register FluxBB

#11 2013-07-08 21:00:33

Re: [Résolu] Erreur Register FluxBB

#12 2013-07-09 11:17:41

Re: [Résolu] Erreur Register FluxBB

#13 2013-07-09 17:41:27

Re: [Résolu] Erreur Register FluxBB

#14 2013-07-09 20:41:01

Re: [Résolu] Erreur Register FluxBB

#15 2013-07-09 22:46:31

Re: [Résolu] Erreur Register FluxBB

Pied de page des forums