Problème d'UTF8

Support Installation
#1

Bonjour,
Je fais écho à bdesroches sur cette page Problème sur les fiches liées suite à la MAJ 4.6? - #32 par mrflosperso pour remonter le même problème que lui :
" Une erreur inattendue s’est produite. Veuillez contacter l’administrateur du site et lui communiquer l’erreur suivante :
COLLATION ‹ utf8mb4_unicode_ci › is not valid for CHARACTER SET ‹ utf8mb3 › in ./includes/services/DbService.php on line 98 "

Ce message s’affiche même sur la page GererSauvegarde ce qui fait que je ne peux pas restaurer la version précédente de YesWiki.

le wakka présente bien les deux lignes
‹ db_charset › => ‹ utf8mb4 ›,
‹ charset › => ‹ UTF-8 ›,

J’ai donc vérifié dans PhpMyAdmin, j’ai bien utf8mb4_unicode_ci dans les colonnes interclassement de chaque table

Je suis en PhP 8.3 chez PlanetHoster

Le wiki en question : https://inventaire.collectif-lesfolepis.org

on voit que sur les textes, l’encodage n’est pas le bon (présence de ? un peu partout), par exemple sur la page d’accueil

Merci !

#2

J’ai tenté une correction fix(bazar): remove hardcoded charset · YesWiki/yeswiki@052e766 · GitHub

Etes vous en mesure de faire un test en récupérant les 2 fichiers depuis le dépôt de code, ou en faisant une mise a jour du yeswiki en question en passant par la page GererMisesAjour, puis l’edition et changer {{update}} en {{update version="doryphore-dev"}} puis mise a jour du coeur de Yeswiki (prévoir un backup au cas où).

Bazarlist - query KO depuis passage en doryphore 4.6
#3

Bonjour,
Merci pour la réactivité, comme toujours !
J’ai bien mis les 2 fichiers mais ça ne solutionne pas le problème.
La seule différence c’est que maintenant le message d’erreur pointe sur la ligne 107 :

Une erreur inattendue s’est produite. Veuillez contacter l’administrateur du site et lui communiquer l’erreur suivante :
COLLATION ‹ utf8mb4_unicode_ci › is not valid for CHARACTER SET ‹ utf8mb3 › in ./includes/services/DbService.php on line 107

#4

arf… vraiment bizarre…
faudrait decommenter les lignes sous la ligne 107 de includes/services/DbService.php

  catch (Exception $e) {
            file_put_contents ("log.txt", $query, FILE_APPEND);
        }

et lancer une fois la page, et verifier ce qu’il a ecrit comme requete dans le fichier log.txt pour savoir ce qui le fait planter…

#5

Alors je ne sais pas si ça fait sens pour toi, mais décommenter ces deux lignes
}
catch (Exception $e) {
file_put_contents (« log.txt », $query, FILE_APPEND);
}
ça fait marcher le site
:crazy_face: :sunglasses: :tada:

1 « J'aime »
#6

Et j’ai bien fait la manip’ inverse et retour pour vérifier que c’est bien ces deux lignes qui font marcher le site

Mais il reste le problème d’affichage du texte avec les caractères spéciaux qui sont remplacés par des ?

#7

mais la requete doit avoir plantée… Ya quoi dans le log

#8

où est-ce que je trouve le log ?

#9

ca, a mon avis, t’as du relancer /dbutf8 et donc reconvertif une deuxieme fois en utf8mb4 une base qui était déja convertie, et ca a du casser tes accents et autres caracteres speciaux…

#10

un fichier log.txt à la racine du wiki

#11

le voilà

WITH RECURSIVE filteredPages AS ( SELECT p., JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) AS id_typeannonce, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_fiche ›)) AS id_fiche, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.nomwiki ›)) AS nomwiki FROM yw_pages p JOIN yw_triples t ON t.resource = p.tag AND t.value = ‹ fiche_bazar › AND t.property = ‹ http://outils-reseaux.org/_vocabulary/type › WHERE latest=‹ Y › AND p.comment_on = ‹  › AND JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) IN (‹ 1 ›,‹ 7 ›,‹ 5 ›,‹ 9 ›,‹ 10 ›,‹ 8 ›,‹ 11 ›,‹ 6 ›,‹ 4 ›)) SELECT DISTINCT f. FROM filteredPages f WHERE ((id_typeannonce IN (‹ 1 ›,‹ 5 ›,‹ 9 ›,‹ 10 ›,‹ 8 ›,‹ 11 ›,‹ 6 ›,‹ 4 ›) AND (FALSE)) OR (id_typeannonce IN (‹ 7 ›) AND (nomwiki COLLATE utf8mb4_unicode_ci = ‹ WikFolepis ›)))WITH RECURSIVE filteredPages AS ( SELECT p., JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) AS id_typeannonce, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_fiche ›)) AS id_fiche, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.nomwiki ›)) AS nomwiki FROM yw_pages p JOIN yw_triples t ON t.resource = p.tag AND t.value = ‹ fiche_bazar › AND t.property = ‹ http://outils-reseaux.org/_vocabulary/type › WHERE latest=‹ Y › AND p.comment_on = ‹  › AND JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) IN (‹ 1 ›,‹ 7 ›,‹ 5 ›,‹ 9 ›,‹ 10 ›,‹ 8 ›,‹ 11 ›,‹ 6 ›,‹ 4 ›)) SELECT DISTINCT f. FROM filteredPages f WHERE ((id_typeannonce IN (‹ 1 ›,‹ 5 ›,‹ 9 ›,‹ 10 ›,‹ 8 ›,‹ 11 ›,‹ 6 ›,‹ 4 ›) AND (FALSE)) OR (id_typeannonce IN (‹ 7 ›) AND (nomwiki COLLATE utf8mb4_unicode_ci = ‹ WikFolepis ›)))WITH RECURSIVE filteredPages AS ( SELECT p., JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) AS id_typeannonce, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_fiche ›)) AS id_fiche, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.nomwiki ›)) AS nomwiki FROM yw_pages p JOIN yw_triples t ON t.resource = p.tag AND t.value = ‹ fiche_bazar › AND t.property = ‹ http://outils-reseaux.org/_vocabulary/type › WHERE latest=‹ Y › AND p.comment_on = ‹  › AND JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) IN (‹ 1 ›,‹ 7 ›,‹ 5 ›,‹ 9 ›,‹ 10 ›,‹ 8 ›,‹ 11 ›,‹ 6 ›,‹ 4 ›)) SELECT DISTINCT f. FROM filteredPages f WHERE ((id_typeannonce IN (‹ 1 ›,‹ 5 ›,‹ 9 ›,‹ 10 ›,‹ 8 ›,‹ 11 ›,‹ 6 ›,‹ 4 ›) AND (FALSE)) OR (id_typeannonce IN (‹ 7 ›) AND (nomwiki COLLATE utf8mb4_unicode_ci = ‹ WikFolepis ›)))WITH RECURSIVE filteredPages AS ( SELECT p., JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) AS id_typeannonce, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_fiche ›)) AS id_fiche, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.nomwiki ›)) AS nomwiki FROM yw_pages p JOIN yw_triples t ON t.resource = p.tag AND t.value = ‹ fiche_bazar › AND t.property = ‹ http://outils-reseaux.org/_vocabulary/type › WHERE latest=‹ Y › AND p.comment_on = ‹  › AND JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) IN (‹ 1 ›,‹ 7 ›,‹ 5 ›,‹ 9 ›,‹ 10 ›,‹ 8 ›,‹ 11 ›,‹ 6 ›,‹ 4 ›)) SELECT DISTINCT f. FROM filteredPages f WHERE ((id_typeannonce IN (‹ 1 ›,‹ 5 ›,‹ 9 ›,‹ 10 ›,‹ 8 ›,‹ 11 ›,‹ 6 ›,‹ 4 ›) AND (FALSE)) OR (id_typeannonce IN (‹ 7 ›) AND (nomwiki COLLATE utf8mb4_unicode_ci = ‹ WikFolepis ›)))WITH RECURSIVE filteredPages AS ( SELECT p., JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) AS id_typeannonce, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_fiche ›)) AS id_fiche, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.nomwiki ›)) AS nomwiki FROM yw_pages p JOIN yw_triples t ON t.resource = p.tag AND t.value = ‹ fiche_bazar › AND t.property = ‹ http://outils-reseaux.org/_vocabulary/type › WHERE latest=‹ Y › AND p.comment_on = ‹  › AND JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) IN (‹ 1 ›,‹ 7 ›,‹ 5 ›,‹ 9 ›,‹ 10 ›,‹ 8 ›,‹ 11 ›,‹ 6 ›,‹ 4 ›)) SELECT DISTINCT f. FROM filteredPages f WHERE ((id_typeannonce IN (‹ 1 ›,‹ 5 ›,‹ 9 ›,‹ 10 ›,‹ 8 ›,‹ 11 ›,‹ 6 ›,‹ 4 ›) AND (FALSE)) OR (id_typeannonce IN (‹ 7 ›) AND (nomwiki COLLATE utf8mb4_unicode_ci = ‹ WikFolepis ›)))WITH RECURSIVE filteredPages AS ( SELECT p., JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) AS id_typeannonce, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_fiche ›)) AS id_fiche, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.nomwiki ›)) AS nomwiki FROM yw_pages p JOIN yw_triples t ON t.resource = p.tag AND t.value = ‹ fiche_bazar › AND t.property = ‹ http://outils-reseaux.org/_vocabulary/type › WHERE latest=‹ Y › AND p.comment_on = ‹  › AND JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) IN (‹ 1 ›,‹ 7 ›,‹ 5 ›,‹ 9 ›,‹ 10 ›,‹ 8 ›,‹ 11 ›,‹ 6 ›,‹ 4 ›)) SELECT DISTINCT f. FROM filteredPages f WHERE ((id_typeannonce IN (‹ 1 ›,‹ 5 ›,‹ 9 ›,‹ 10 ›,‹ 8 ›,‹ 11 ›,‹ 6 ›,‹ 4 ›) AND (FALSE)) OR (id_typeannonce IN (‹ 7 ›) AND (nomwiki COLLATE utf8mb4_unicode_ci = ‹ WikFolepis ›)))WITH RECURSIVE filteredPages AS ( SELECT p., JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) AS id_typeannonce, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_fiche ›)) AS id_fiche, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.nomwiki ›)) AS nomwiki FROM yw_pages p JOIN yw_triples t ON t.resource = p.tag AND t.value = ‹ fiche_bazar › AND t.property = ‹ http://outils-reseaux.org/_vocabulary/type › WHERE latest=‹ Y › AND p.comment_on = ‹  › AND JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) IN (‹ 6 ›,‹ 5 ›,‹ 9 ›,‹ 8 ›,‹ 7 ›,‹ 1 ›,‹ 10 ›,‹ 11 ›,‹ 4 ›)) SELECT DISTINCT f. FROM filteredPages f WHERE ((id_typeannonce IN (‹ 6 ›,‹ 5 ›,‹ 9 ›,‹ 8 ›,‹ 1 ›,‹ 10 ›,‹ 11 ›,‹ 4 ›) AND (FALSE)) OR (id_typeannonce IN (‹ 7 ›) AND (nomwiki COLLATE utf8mb4_unicode_ci = ‹ WikFolepis ›)))WITH RECURSIVE filteredPages AS ( SELECT p., JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) AS id_typeannonce, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_fiche ›)) AS id_fiche, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.imagebf_image ›)) AS imagebf_image FROM yw_pages p JOIN yw_triples t ON t.resource = p.tag AND t.value = ‹ fiche_bazar › AND t.property = ‹ http://outils-reseaux.org/_vocabulary/type › WHERE latest=‹ Y › AND p.comment_on = ‹  › AND JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) IN (‹ 6 ›)) SELECT DISTINCT f. FROM filteredPages f WHERE ((imagebf_image COLLATE utf8mb4_unicode_ci != ‹ . ›))WITH RECURSIVE filteredPages AS ( SELECT p., JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) AS id_typeannonce, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_fiche ›)) AS id_fiche, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.nomwiki ›)) AS nomwiki FROM yw_pages p JOIN yw_triples t ON t.resource = p.tag AND t.value = ‹ fiche_bazar › AND t.property = ‹ http://outils-reseaux.org/_vocabulary/type › WHERE latest=‹ Y › AND p.comment_on = ‹  › AND JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) IN (‹ 6 ›,‹ 1 ›,‹ 7 ›,‹ 5 ›,‹ 9 ›,‹ 10 ›,‹ 8 ›,‹ 11 ›,‹ 4 ›)) SELECT DISTINCT f. FROM filteredPages f WHERE ((id_typeannonce IN (‹ 6 ›,‹ 1 ›,‹ 5 ›,‹ 9 ›,‹ 10 ›,‹ 8 ›,‹ 11 ›,‹ 4 ›) AND (FALSE)) OR (id_typeannonce IN (‹ 7 ›) AND (nomwiki COLLATE utf8mb4_unicode_ci = ‹ WikFolepis ›)))WITH RECURSIVE filteredPages AS ( SELECT p., JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) AS id_typeannonce, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_fiche ›)) AS id_fiche, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.nomwiki ›)) AS nomwiki FROM yw_pages p JOIN yw_triples t ON t.resource = p.tag AND t.value = ‹ fiche_bazar › AND t.property = ‹ http://outils-reseaux.org/_vocabulary/type › WHERE latest=‹ Y › AND p.comment_on = ‹  › AND JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) IN (‹ 6 ›,‹ 1 ›,‹ 7 ›,‹ 5 ›,‹ 9 ›,‹ 10 ›,‹ 8 ›,‹ 11 ›,‹ 4 ›)) SELECT DISTINCT f. FROM filteredPages f WHERE ((id_typeannonce IN (‹ 6 ›,‹ 1 ›,‹ 5 ›,‹ 9 ›,‹ 10 ›,‹ 8 ›,‹ 11 ›,‹ 4 ›) AND (FALSE)) OR (id_typeannonce IN (‹ 7 ›) AND (nomwiki COLLATE utf8mb4_unicode_ci = ‹ WikFolepis ›)))WITH RECURSIVE filteredPages AS ( SELECT p., JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) AS id_typeannonce, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_fiche ›)) AS id_fiche, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.nomwiki ›)) AS nomwiki FROM yw_pages p JOIN yw_triples t ON t.resource = p.tag AND t.value = ‹ fiche_bazar › AND t.property = ‹ http://outils-reseaux.org/_vocabulary/type › WHERE latest=‹ Y › AND p.comment_on = ‹  › AND JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) IN (‹ 6 ›,‹ 1 ›,‹ 7 ›,‹ 5 ›,‹ 9 ›,‹ 10 ›,‹ 8 ›,‹ 11 ›,‹ 4 ›)) SELECT DISTINCT f. FROM filteredPages f WHERE ((id_typeannonce IN (‹ 6 ›,‹ 1 ›,‹ 5 ›,‹ 9 ›,‹ 10 ›,‹ 8 ›,‹ 11 ›,‹ 4 ›) AND (FALSE)) OR (id_typeannonce IN (‹ 7 ›) AND (nomwiki COLLATE utf8mb4_unicode_ci = ‹ WikFolepis ›)))WITH RECURSIVE filteredPages AS ( SELECT p., JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) AS id_typeannonce, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_fiche ›)) AS id_fiche, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.imagebf_image ›)) AS imagebf_image FROM yw_pages p JOIN yw_triples t ON t.resource = p.tag AND t.value = ‹ fiche_bazar › AND t.property = ‹ http://outils-reseaux.org/_vocabulary/type › WHERE latest=‹ Y › AND p.comment_on = ‹  › AND JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) IN (‹ 6 ›)) SELECT DISTINCT f. FROM filteredPages f WHERE ((imagebf_image COLLATE utf8mb4_unicode_ci != ‹ . ›))WITH RECURSIVE filteredPages AS ( SELECT p., JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) AS id_typeannonce, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_fiche ›)) AS id_fiche, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.nomwiki ›)) AS nomwiki FROM yw_pages p JOIN yw_triples t ON t.resource = p.tag AND t.value = ‹ fiche_bazar › AND t.property = ‹ http://outils-reseaux.org/_vocabulary/type › WHERE latest=‹ Y › AND p.comment_on = ‹  › AND JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) IN (‹ 6 ›,‹ 1 ›,‹ 7 ›,‹ 5 ›,‹ 9 ›,‹ 10 ›,‹ 8 ›,‹ 11 ›,‹ 4 ›)) SELECT DISTINCT f. FROM filteredPages f WHERE ((id_typeannonce IN (‹ 6 ›,‹ 1 ›,‹ 5 ›,‹ 9 ›,‹ 10 ›,‹ 8 ›,‹ 11 ›,‹ 4 ›) AND (FALSE)) OR (id_typeannonce IN (‹ 7 ›) AND (nomwiki COLLATE utf8mb4_unicode_ci = ‹ WikFolepis ›)))WITH RECURSIVE filteredPages AS ( SELECT p., JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) AS id_typeannonce, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_fiche ›)) AS id_fiche, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.nomwiki ›)) AS nomwiki FROM yw_pages p JOIN yw_triples t ON t.resource = p.tag AND t.value = ‹ fiche_bazar › AND t.property = ‹ http://outils-reseaux.org/_vocabulary/type › WHERE latest=‹ Y › AND p.comment_on = ‹  › AND JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) IN (‹ 6 ›,‹ 1 ›,‹ 7 ›,‹ 5 ›,‹ 9 ›,‹ 10 ›,‹ 8 ›,‹ 11 ›,‹ 4 ›)) SELECT DISTINCT f. FROM filteredPages f WHERE ((id_typeannonce IN (‹ 6 ›,‹ 1 ›,‹ 5 ›,‹ 9 ›,‹ 10 ›,‹ 8 ›,‹ 11 ›,‹ 4 ›) AND (FALSE)) OR (id_typeannonce IN (‹ 7 ›) AND (nomwiki COLLATE utf8mb4_unicode_ci = ‹ WikFolepis ›)))WITH RECURSIVE filteredPages AS ( SELECT p., JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) AS id_typeannonce, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_fiche ›)) AS id_fiche, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.nomwiki ›)) AS nomwiki FROM yw_pages p JOIN yw_triples t ON t.resource = p.tag AND t.value = ‹ fiche_bazar › AND t.property = ‹ http://outils-reseaux.org/_vocabulary/type › WHERE latest=‹ Y › AND p.comment_on = ‹  › AND JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) IN (‹ 6 ›,‹ 1 ›,‹ 7 ›,‹ 5 ›,‹ 9 ›,‹ 10 ›,‹ 8 ›,‹ 11 ›,‹ 4 ›)) SELECT DISTINCT f. FROM filteredPages f WHERE ((id_typeannonce IN (‹ 6 ›,‹ 1 ›,‹ 5 ›,‹ 9 ›,‹ 10 ›,‹ 8 ›,‹ 11 ›,‹ 4 ›) AND (FALSE)) OR (id_typeannonce IN (‹ 7 ›) AND (nomwiki COLLATE utf8mb4_unicode_ci = ‹ WikFolepis ›)))WITH RECURSIVE filteredPages AS ( SELECT p., JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) AS id_typeannonce, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_fiche ›)) AS id_fiche, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.imagebf_image ›)) AS imagebf_image FROM yw_pages p JOIN yw_triples t ON t.resource = p.tag AND t.value = ‹ fiche_bazar › AND t.property = ‹ http://outils-reseaux.org/_vocabulary/type › WHERE latest=‹ Y › AND p.comment_on = ‹  › AND JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) IN (‹ 6 ›)) SELECT DISTINCT f. FROM filteredPages f WHERE ((imagebf_image COLLATE utf8mb4_unicode_ci != ‹ . ›))WITH RECURSIVE filteredPages AS ( SELECT p., JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) AS id_typeannonce, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_fiche ›)) AS id_fiche, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.nomwiki ›)) AS nomwiki FROM yw_pages p JOIN yw_triples t ON t.resource = p.tag AND t.value = ‹ fiche_bazar › AND t.property = ‹ http://outils-reseaux.org/_vocabulary/type › WHERE latest=‹ Y › AND p.comment_on = ‹  › AND JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) IN (‹ 6 ›,‹ 1 ›,‹ 7 ›,‹ 5 ›,‹ 9 ›,‹ 10 ›,‹ 8 ›,‹ 11 ›,‹ 4 ›)) SELECT DISTINCT f. FROM filteredPages f WHERE ((id_typeannonce IN (‹ 6 ›,‹ 1 ›,‹ 5 ›,‹ 9 ›,‹ 10 ›,‹ 8 ›,‹ 11 ›,‹ 4 ›) AND (FALSE)) OR (id_typeannonce IN (‹ 7 ›) AND (nomwiki COLLATE utf8mb4_unicode_ci = ‹ WikFolepis ›)))WITH RECURSIVE filteredPages AS ( SELECT p., JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) AS id_typeannonce, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_fiche ›)) AS id_fiche, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.nomwiki ›)) AS nomwiki FROM yw_pages p JOIN yw_triples t ON t.resource = p.tag AND t.value = ‹ fiche_bazar › AND t.property = ‹ http://outils-reseaux.org/_vocabulary/type › WHERE latest=‹ Y › AND p.comment_on = ‹  › AND JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) IN (‹ 6 ›,‹ 1 ›,‹ 7 ›,‹ 5 ›,‹ 9 ›,‹ 10 ›,‹ 8 ›,‹ 11 ›,‹ 4 ›)) SELECT DISTINCT f. FROM filteredPages f WHERE ((id_typeannonce IN (‹ 6 ›,‹ 1 ›,‹ 5 ›,‹ 9 ›,‹ 10 ›,‹ 8 ›,‹ 11 ›,‹ 4 ›) AND (FALSE)) OR (id_typeannonce IN (‹ 7 ›) AND (nomwiki COLLATE utf8mb4_unicode_ci = ‹ WikFolepis ›)))WITH RECURSIVE filteredPages AS ( SELECT p., JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) AS id_typeannonce, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_fiche ›)) AS id_fiche, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.nomwiki ›)) AS nomwiki FROM yw_pages p JOIN yw_triples t ON t.resource = p.tag AND t.value = ‹ fiche_bazar › AND t.property = ‹ http://outils-reseaux.org/_vocabulary/type › WHERE latest=‹ Y › AND p.comment_on = ‹  › AND JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) IN (‹ 6 ›,‹ 1 ›,‹ 7 ›,‹ 5 ›,‹ 9 ›,‹ 10 ›,‹ 8 ›,‹ 11 ›,‹ 4 ›)) SELECT DISTINCT f. FROM filteredPages f WHERE ((id_typeannonce IN (‹ 6 ›,‹ 1 ›,‹ 5 ›,‹ 9 ›,‹ 10 ›,‹ 8 ›,‹ 11 ›,‹ 4 ›) AND (FALSE)) OR (id_typeannonce IN (‹ 7 ›) AND (nomwiki COLLATE utf8mb4_unicode_ci = ‹ WikFolepis ›)))WITH RECURSIVE filteredPages AS ( SELECT p., JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) AS id_typeannonce, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_fiche ›)) AS id_fiche, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.nomwiki ›)) AS nomwiki FROM yw_pages p JOIN yw_triples t ON t.resource = p.tag AND t.value = ‹ fiche_bazar › AND t.property = ‹ http://outils-reseaux.org/_vocabulary/type › WHERE latest=‹ Y › AND p.comment_on = ‹  › AND JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) IN (‹ 7 ›,‹ 1 ›,‹ 5 ›,‹ 9 ›,‹ 10 ›,‹ 8 ›,‹ 11 ›,‹ 6 ›,‹ 4 ›)) SELECT DISTINCT f. FROM filteredPages f WHERE ((id_typeannonce IN (‹ 7 ›) AND (nomwiki COLLATE utf8mb4_unicode_ci = ‹ WikFolepis ›)) OR (id_typeannonce IN (‹ 1 ›,‹ 5 ›,‹ 9 ›,‹ 10 ›,‹ 8 ›,‹ 11 ›,‹ 6 ›,‹ 4 ›) AND (FALSE)))WITH RECURSIVE filteredPages AS ( SELECT p., JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) AS id_typeannonce, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_fiche ›)) AS id_fiche, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.nomwiki ›)) AS nomwiki FROM yw_pages p JOIN yw_triples t ON t.resource = p.tag AND t.value = ‹ fiche_bazar › AND t.property = ‹ http://outils-reseaux.org/_vocabulary/type › WHERE latest=‹ Y › AND p.comment_on = ‹  › AND JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) IN (‹ 7 ›,‹ 1 ›,‹ 5 ›,‹ 9 ›,‹ 10 ›,‹ 8 ›,‹ 11 ›,‹ 6 ›,‹ 4 ›)) SELECT DISTINCT f. FROM filteredPages f WHERE ((id_typeannonce IN (‹ 7 ›) AND (nomwiki COLLATE utf8mb4_unicode_ci = ‹ WikFolepis ›)) OR (id_typeannonce IN (‹ 1 ›,‹ 5 ›,‹ 9 ›,‹ 10 ›,‹ 8 ›,‹ 11 ›,‹ 6 ›,‹ 4 ›) AND (FALSE)))WITH RECURSIVE filteredPages AS ( SELECT p., JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) AS id_typeannonce, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_fiche ›)) AS id_fiche, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.nomwiki ›)) AS nomwiki FROM yw_pages p JOIN yw_triples t ON t.resource = p.tag AND t.value = ‹ fiche_bazar › AND t.property = ‹ http://outils-reseaux.org/_vocabulary/type › WHERE latest=‹ Y › AND p.comment_on = ‹  › AND JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) IN (‹ 7 ›,‹ 1 ›,‹ 5 ›,‹ 9 ›,‹ 10 ›,‹ 8 ›,‹ 11 ›,‹ 6 ›,‹ 4 ›)) SELECT DISTINCT f. FROM filteredPages f WHERE ((id_typeannonce IN (‹ 7 ›) AND (nomwiki COLLATE utf8mb4_unicode_ci = ‹ WikFolepis ›)) OR (id_typeannonce IN (‹ 1 ›,‹ 5 ›,‹ 9 ›,‹ 10 ›,‹ 8 ›,‹ 11 ›,‹ 6 ›,‹ 4 ›) AND (FALSE)))WITH RECURSIVE filteredPages AS ( SELECT p., JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) AS id_typeannonce, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_fiche ›)) AS id_fiche, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.imagebf_image ›)) AS imagebf_image FROM yw_pages p JOIN yw_triples t ON t.resource = p.tag AND t.value = ‹ fiche_bazar › AND t.property = ‹ http://outils-reseaux.org/_vocabulary/type › WHERE latest=‹ Y › AND p.comment_on = ‹  › AND JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) IN (‹ 6 ›)) SELECT DISTINCT f. FROM filteredPages f WHERE ((imagebf_image COLLATE utf8mb4_unicode_ci != ‹ . ›))WITH RECURSIVE filteredPages AS ( SELECT p., JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) AS id_typeannonce, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_fiche ›)) AS id_fiche, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.nomwiki ›)) AS nomwiki FROM yw_pages p JOIN yw_triples t ON t.resource = p.tag AND t.value = ‹ fiche_bazar › AND t.property = ‹ http://outils-reseaux.org/_vocabulary/type › WHERE latest=‹ Y › AND p.comment_on = ‹  › AND JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) IN (‹ 6 ›,‹ 1 ›,‹ 7 ›,‹ 5 ›,‹ 9 ›,‹ 10 ›,‹ 8 ›,‹ 11 ›,‹ 4 ›)) SELECT DISTINCT f. FROM filteredPages f WHERE ((id_typeannonce IN (‹ 6 ›,‹ 1 ›,‹ 5 ›,‹ 9 ›,‹ 10 ›,‹ 8 ›,‹ 11 ›,‹ 4 ›) AND (FALSE)) OR (id_typeannonce IN (‹ 7 ›) AND (nomwiki COLLATE utf8mb4_unicode_ci = ‹ WikFolepis ›)))WITH RECURSIVE filteredPages AS ( SELECT p., JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) AS id_typeannonce, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_fiche ›)) AS id_fiche, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.nomwiki ›)) AS nomwiki FROM yw_pages p JOIN yw_triples t ON t.resource = p.tag AND t.value = ‹ fiche_bazar › AND t.property = ‹ http://outils-reseaux.org/_vocabulary/type › WHERE latest=‹ Y › AND p.comment_on = ‹  › AND JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) IN (‹ 6 ›,‹ 1 ›,‹ 7 ›,‹ 5 ›,‹ 9 ›,‹ 10 ›,‹ 8 ›,‹ 11 ›,‹ 4 ›)) SELECT DISTINCT f. FROM filteredPages f WHERE ((id_typeannonce IN (‹ 6 ›,‹ 1 ›,‹ 5 ›,‹ 9 ›,‹ 10 ›,‹ 8 ›,‹ 11 ›,‹ 4 ›) AND (FALSE)) OR (id_typeannonce IN (‹ 7 ›) AND (nomwiki COLLATE utf8mb4_unicode_ci = ‹ WikFolepis ›)))WITH RECURSIVE filteredPages AS ( SELECT p., JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) AS id_typeannonce, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_fiche ›)) AS id_fiche, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.nomwiki ›)) AS nomwiki FROM yw_pages p JOIN yw_triples t ON t.resource = p.tag AND t.value = ‹ fiche_bazar › AND t.property = ‹ http://outils-reseaux.org/_vocabulary/type › WHERE latest=‹ Y › AND p.comment_on = ‹  › AND JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) IN (‹ 6 ›,‹ 1 ›,‹ 7 ›,‹ 5 ›,‹ 9 ›,‹ 10 ›,‹ 8 ›,‹ 11 ›,‹ 4 ›)) SELECT DISTINCT f. FROM filteredPages f WHERE ((id_typeannonce IN (‹ 6 ›,‹ 1 ›,‹ 5 ›,‹ 9 ›,‹ 10 ›,‹ 8 ›,‹ 11 ›,‹ 4 ›) AND (FALSE)) OR (id_typeannonce IN (‹ 7 ›) AND (nomwiki COLLATE utf8mb4_unicode_ci = ‹ WikFolepis ›)))WITH RECURSIVE filteredPages AS ( SELECT p., JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) AS id_typeannonce, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_fiche ›)) AS id_fiche, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.nomwiki ›)) AS nomwiki FROM yw_pages p JOIN yw_triples t ON t.resource = p.tag AND t.value = ‹ fiche_bazar › AND t.property = ‹ http://outils-reseaux.org/_vocabulary/type › WHERE latest=‹ Y › AND p.comment_on = ‹  › AND JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) IN (‹ 1 ›,‹ 7 ›,‹ 5 ›,‹ 9 ›,‹ 10 ›,‹ 8 ›,‹ 11 ›,‹ 6 ›,‹ 4 ›)) SELECT DISTINCT f. FROM filteredPages f WHERE ((id_typeannonce IN (‹ 1 ›,‹ 5 ›,‹ 9 ›,‹ 10 ›,‹ 8 ›,‹ 11 ›,‹ 6 ›,‹ 4 ›) AND (FALSE)) OR (id_typeannonce IN (‹ 7 ›) AND (nomwiki COLLATE utf8mb4_unicode_ci = ‹ WikFolepis ›)))WITH RECURSIVE filteredPages AS ( SELECT p., JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) AS id_typeannonce, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_fiche ›)) AS id_fiche, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.nomwiki ›)) AS nomwiki FROM yw_pages p JOIN yw_triples t ON t.resource = p.tag AND t.value = ‹ fiche_bazar › AND t.property = ‹ http://outils-reseaux.org/_vocabulary/type › WHERE latest=‹ Y › AND p.comment_on = ‹  › AND JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) IN (‹ 1 ›,‹ 7 ›,‹ 5 ›,‹ 9 ›,‹ 10 ›,‹ 8 ›,‹ 11 ›,‹ 6 ›,‹ 4 ›)) SELECT DISTINCT f. FROM filteredPages f WHERE ((id_typeannonce IN (‹ 1 ›,‹ 5 ›,‹ 9 ›,‹ 10 ›,‹ 8 ›,‹ 11 ›,‹ 6 ›,‹ 4 ›) AND (FALSE)) OR (id_typeannonce IN (‹ 7 ›) AND (nomwiki COLLATE utf8mb4_unicode_ci = ‹ WikFolepis ›)))WITH RECURSIVE filteredPages AS ( SELECT p., JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) AS id_typeannonce, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_fiche ›)) AS id_fiche, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.nomwiki ›)) AS nomwiki FROM yw_pages p JOIN yw_triples t ON t.resource = p.tag AND t.value = ‹ fiche_bazar › AND t.property = ‹ http://outils-reseaux.org/_vocabulary/type › WHERE latest=‹ Y › AND p.comment_on = ‹  › AND JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) IN (‹ 1 ›,‹ 7 ›,‹ 5 ›,‹ 9 ›,‹ 10 ›,‹ 8 ›,‹ 11 ›,‹ 6 ›,‹ 4 ›)) SELECT DISTINCT f. FROM filteredPages f WHERE ((id_typeannonce IN (‹ 1 ›,‹ 5 ›,‹ 9 ›,‹ 10 ›,‹ 8 ›,‹ 11 ›,‹ 6 ›,‹ 4 ›) AND (FALSE)) OR (id_typeannonce IN (‹ 7 ›) AND (nomwiki COLLATE utf8mb4_unicode_ci = ‹ WikFolepis ›)))WITH RECURSIVE filteredPages AS ( SELECT p., JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) AS id_typeannonce, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_fiche ›)) AS id_fiche, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.nomwiki ›)) AS nomwiki FROM yw_pages p JOIN yw_triples t ON t.resource = p.tag AND t.value = ‹ fiche_bazar › AND t.property = ‹ http://outils-reseaux.org/_vocabulary/type › WHERE latest=‹ Y › AND p.comment_on = ‹  › AND JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) IN (‹ 1 ›,‹ 7 ›,‹ 5 ›,‹ 9 ›,‹ 10 ›,‹ 8 ›,‹ 11 ›,‹ 6 ›,‹ 4 ›)) SELECT DISTINCT f. FROM filteredPages f WHERE ((id_typeannonce IN (‹ 1 ›,‹ 5 ›,‹ 9 ›,‹ 10 ›,‹ 8 ›,‹ 11 ›,‹ 6 ›,‹ 4 ›) AND (FALSE)) OR (id_typeannonce IN (‹ 7 ›) AND (nomwiki COLLATE utf8mb4_unicode_ci = ‹ WikFolepis ›)))WITH RECURSIVE filteredPages AS ( SELECT p., JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) AS id_typeannonce, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_fiche ›)) AS id_fiche, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.nomwiki ›)) AS nomwiki FROM yw_pages p JOIN yw_triples t ON t.resource = p.tag AND t.value = ‹ fiche_bazar › AND t.property = ‹ http://outils-reseaux.org/_vocabulary/type › WHERE latest=‹ Y › AND p.comment_on = ‹  › AND JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) IN (‹ 1 ›,‹ 7 ›,‹ 5 ›,‹ 9 ›,‹ 10 ›,‹ 8 ›,‹ 11 ›,‹ 6 ›,‹ 4 ›)) SELECT DISTINCT f. FROM filteredPages f WHERE ((id_typeannonce IN (‹ 1 ›,‹ 5 ›,‹ 9 ›,‹ 10 ›,‹ 8 ›,‹ 11 ›,‹ 6 ›,‹ 4 ›) AND (FALSE)) OR (id_typeannonce IN (‹ 7 ›) AND (nomwiki COLLATE utf8mb4_unicode_ci = ‹ WikFolepis ›)))

#12

est-ce que tu veux que je le vide et que je relance la requête ?

#13

Mais quand même ça a permis d’afficher les pages d’administration correctement

#14

En vidant et rechargeant la page, voici ce qu’affiche le log.txt
WITH RECURSIVE filteredPages AS ( SELECT p., JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) AS id_typeannonce, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_fiche ›)) AS id_fiche, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.imagebf_image ›)) AS imagebf_image FROM yw_pages p JOIN yw_triples t ON t.resource = p.tag AND t.value = ‹ fiche_bazar › AND t.property = ‹ http://outils-reseaux.org/_vocabulary/type › WHERE latest=‹ Y › AND p.comment_on = ‹  › AND JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) IN (‹ 6 ›)) SELECT DISTINCT f. FROM filteredPages f WHERE ((imagebf_image COLLATE utf8mb4_unicode_ci != ‹ . ›))WITH RECURSIVE filteredPages AS ( SELECT p., JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) AS id_typeannonce, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_fiche ›)) AS id_fiche, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.nomwiki ›)) AS nomwiki FROM yw_pages p JOIN yw_triples t ON t.resource = p.tag AND t.value = ‹ fiche_bazar › AND t.property = ‹ http://outils-reseaux.org/_vocabulary/type › WHERE latest=‹ Y › AND p.comment_on = ‹  › AND JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) IN (‹ 6 ›,‹ 1 ›,‹ 7 ›,‹ 5 ›,‹ 9 ›,‹ 10 ›,‹ 8 ›,‹ 11 ›,‹ 4 ›)) SELECT DISTINCT f. FROM filteredPages f WHERE ((id_typeannonce IN (‹ 6 ›,‹ 1 ›,‹ 5 ›,‹ 9 ›,‹ 10 ›,‹ 8 ›,‹ 11 ›,‹ 4 ›) AND (FALSE)) OR (id_typeannonce IN (‹ 7 ›) AND (nomwiki COLLATE utf8mb4_unicode_ci = ‹ WikFolepis ›)))WITH RECURSIVE filteredPages AS ( SELECT p., JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) AS id_typeannonce, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_fiche ›)) AS id_fiche, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.nomwiki ›)) AS nomwiki FROM yw_pages p JOIN yw_triples t ON t.resource = p.tag AND t.value = ‹ fiche_bazar › AND t.property = ‹ http://outils-reseaux.org/_vocabulary/type › WHERE latest=‹ Y › AND p.comment_on = ‹  › AND JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) IN (‹ 6 ›,‹ 1 ›,‹ 7 ›,‹ 5 ›,‹ 9 ›,‹ 10 ›,‹ 8 ›,‹ 11 ›,‹ 4 ›)) SELECT DISTINCT f. FROM filteredPages f WHERE ((id_typeannonce IN (‹ 6 ›,‹ 1 ›,‹ 5 ›,‹ 9 ›,‹ 10 ›,‹ 8 ›,‹ 11 ›,‹ 4 ›) AND (FALSE)) OR (id_typeannonce IN (‹ 7 ›) AND (nomwiki COLLATE utf8mb4_unicode_ci = ‹ WikFolepis ›)))WITH RECURSIVE filteredPages AS ( SELECT p., JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) AS id_typeannonce, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_fiche ›)) AS id_fiche, JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.nomwiki ›)) AS nomwiki FROM yw_pages p JOIN yw_triples t ON t.resource = p.tag AND t.value = ‹ fiche_bazar › AND t.property = ‹ http://outils-reseaux.org/_vocabulary/type › WHERE latest=‹ Y › AND p.comment_on = ‹  › AND JSON_UNQUOTE(JSON_EXTRACT(body, ‹ $.id_typeannonce ›)) IN (‹ 6 ›,‹ 1 ›,‹ 7 ›,‹ 5 ›,‹ 9 ›,‹ 10 ›,‹ 8 ›,‹ 11 ›,‹ 4 ›)) SELECT DISTINCT f. FROM filteredPages f WHERE ((id_typeannonce IN (‹ 6 ›,‹ 1 ›,‹ 5 ›,‹ 9 ›,‹ 10 ›,‹ 8 ›,‹ 11 ›,‹ 4 ›) AND (FALSE)) OR (id_typeannonce IN (‹ 7 ›) AND (nomwiki COLLATE utf8mb4_unicode_ci = ‹ WikFolepis ›)))

#15

(désolé pour le flood)

une autre erreur que je rencontre, c’est que quand j’édite une page, je ne peux pas la sauver, je tombe sur le message
Forbidden
You don’t have permission to access this resource.

#16

Bonsoir, je reviens vers vous. J’ai bien suivi les conseils : maj en version dev puis décommenté les lignes indiquées et la recherche fonctionne maintenant !
Reste à voir si ça n’a rien cassé par ailleurs… mais ça a l’air prometteur !