pb fonction recherche

pb fonction recherche [Réglé]

La fonction recherche génère une erreur Support Général

forum6691 Membre non connecté

Booster Mortier

Le 24/10/2009 à 20h24

Mon site est là: pneu passion med

Quand j'utilise la fonction recherche avec un simple mot clé ("test" par exemple), j'obtiens une belle page rouge avec un dump d'erreur suivant:

Erreur fatale : invalid while request

(SELECT

139 AS id_search,

a.id AS id_content,

a.title AS title,

( 2 * MATCH(a.title) AGAINST('test') + MATCH(a.contents) AGAINST('test') ) / 3 * 1 AS relevance, CONCAT(CONCAT(CONCAT('../articles/articles.php?id=',a.id),'&cat='),a.idcat) AS link

FROM phpboost_articles a

LEFT JOIN phpboost_articles_cats ac ON ac.id = a.idcat

WHERE

a.visible = 1 AND ((ac.aprob = 1 AND ac.auth LIKE '%s:3:"r-1";i:1;%') OR a.idcat = 0)

AND (MATCH(a.title) AGAINST('test') OR MATCH(a.contents) AGAINST('test'))

ORDER BY relevance DESC LIMIT 0, 10) UNION (SELECT 140 AS `id_search`,

q.id AS `id_content`,

q.word AS `title`,

( MATCH(q.description) AGAINST('test') + MATCH(q.word) AGAINST('test') ) / 2 * 1 AS `relevance`,

CONCAT('../dictionary/dictionary.php?l=',q.word) AS `link`

FROM phpboost_dictionary q

WHERE ( MATCH(q.word) AGAINST('test')

OR MATCH(q.description) AGAINST('test') )) UNION (SELECT 141 AS id_search,

d.id AS id_content,

d.title AS title,

( 3 * MATCH(d.title) AGAINST('test') + 2 * MATCH(d.short_contents) AGAINST('test') + MATCH(d.contents) AGAINST('test') ) / 6 * 1 AS relevance, CONCAT('../download/download.php?id=',d.id) AS link

FROM phpboost_download d

WHERE ( MATCH(d.title) AGAINST('test') OR MATCH(d.short_contents) AGAINST('test') OR MATCH(d.contents) AGAINST('test') ) AND d.idcat IN (1) ORDER BY relevance DESC LIMIT 0, 100) UNION (SELECT 142 AS id_search,

f.id AS id_content,

f.question AS title,

( 2 * MATCH(f.question) AGAINST('test') + MATCH(f.answer) AGAINST('test') ) / 3 * 1 AS relevance, CONCAT(CONCAT(CONCAT(CONCAT(CONCAT('../faq/faq.php?id=',f.idcat),'&question='),f.id),'#q'),f.id) AS link

FROM phpboost_faq f

WHERE ( MATCH(f.question) AGAINST('test') OR MATCH(f.answer) AGAINST('test') ) AND f.idcat IN (1,2) ORDER BY relevance DESC LIMIT 0, 100) UNION (SELECT 143 AS `id_search`,

msg.id AS `id_content`,

t.title AS `title`,

MATCH(t.title) AGAINST('test') * 1 AS `relevance`,

CONCAT(CONCAT(CONCAT(CONCAT('..','/forum/topic.php?id='),t.id),'#m'),msg.id) AS `link`

FROM phpboost_forum_msg msg

JOIN phpboost_forum_topics t ON t.id = msg.idtopic

JOIN phpboost_forum_cats c ON c.level != 0 AND c.aprob = 1 AND c.id = t.idcat

WHERE MATCH(t.title) AGAINST('test')

GROUP BY t.id

ORDER BY relevance DESC LIMIT 0, 50) UNION (SELECT 144 AS id_search,

f.id AS id_content,

f.name AS title,

( 2 * MATCH(f.name) AGAINST('test') + MATCH(f.contents) AGAINST('test') ) / 3 * 1 AS relevance, CONCAT(CONCAT(CONCAT('../media/media.php?id=',f.id),'&cat='),f.idcat) AS link

FROM phpboost_media f

WHERE ( MATCH(f.name) AGAINST('test') OR MATCH(f.contents) AGAINST('test') ) AND f.idcat IN (1,2,3,4,5) ORDER BY relevance DESC LIMIT 0, 100) UNION (SELECT 145 AS id_search,

n.id AS id_content,

n.title AS title,

( 2 * MATCH(n.title) AGAINST('test') + (MATCH(n.contents) AGAINST('test') + MATCH(n.extend_contents) AGAINST('test')) / 2 ) / 3 * 1 AS relevance, CONCAT('../news/news.php?id=',n.id) AS link

FROM phpboost_news n

WHERE ( MATCH(n.title) AGAINST('test') OR MATCH(n.contents) AGAINST('test') OR MATCH(n.extend_contents) AGAINST('test') )

AND visible = 1 AND ('1256408283' > start AND ( end = 0 OR '1256408283' < end ) )

ORDER BY relevance DESC LIMIT 0, 100) UNION (SELECT 147 AS `id_search`,

q.id AS `id_content`,

q.title AS `title`,

1 AS `relevance`,

CONCAT('../smallads/smallads.php?edit=',q.id) AS `link`

FROM phpboost_smallads q

WHERE ( q.title LIKE '%test%')

OR ( q.contents LIKE '%test%')) UNION (SELECT 148 AS `id_search`,

`id` AS `id_content`,

`title` AS `title`,

((MATCH(title) AGAINST('test') )* 1) AS `relevance`,

CONCAT('../wiki/wiki.php?title=',encoded_title) AS `link`

FROM phpboost_wiki_articles

WHERE MATCH(title) AGAINST('test'))

Illegal mix of collations for operation 'UNION'

Ligne 337 : search.class.php

Si je réessaye avec le même mot, une deuxième fois, l'écran de résultats de recherche apparait sans problème, mais avec aucune occurrence trouvée, alors qu'il y a bien ce mot dans le forum par exemple.

Testeur V5