Forum

Erreur fatale : invalid while request
 
(SELECT
12 AS id_search,
a.id AS id_content,
a.title AS title,
( 2 * MATCH(a.title) AGAINST('gf') + MATCH(a.contents) AGAINST('gf') ) / 3 * 8 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('gf') OR MATCH(a.contents) AGAINST('gf'))
ORDER BY relevance DESC LIMIT 0, 10) UNION (SELECT 13 AS id_search,
d.id AS id_content,
d.title AS title,
( 3 * MATCH(d.title) AGAINST('gf') + 2 * MATCH(d.short_contents) AGAINST('gf') + MATCH(d.contents) AGAINST('gf') ) / 6 * 7 AS relevance, CONCAT('../download/download.php?id=',d.id) AS link
FROM phpboost_download d
WHERE ( MATCH(d.title) AGAINST('gf') OR MATCH(d.short_contents) AGAINST('gf') OR MATCH(d.contents) AGAINST('gf') ) AND d.idcat IN (2) ORDER BY relevance DESC LIMIT 0, 100) UNION (SELECT 14 AS id_search,
f.id AS id_content,
f.question AS title,
( 2 * MATCH(f.question) AGAINST('gf') + MATCH(f.answer) AGAINST('gf') ) / 3 * 6 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('gf') OR MATCH(f.answer) AGAINST('gf') ) AND f.idcat IN (2,3) ORDER BY relevance DESC LIMIT 0, 100) UNION (SELECT 15 AS id_search,
f.id AS id_content,
f.name AS title,
( 2 * MATCH(f.name) AGAINST('gf') + MATCH(f.contents) AGAINST('gf') ) / 3 * 5 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('gf') OR MATCH(f.contents) AGAINST('gf') ) AND f.idcat IN (3) ORDER BY relevance DESC LIMIT 0, 100) UNION (SELECT 16 AS id_search,
n.id AS id_content,
n.title AS title,
( 2 * MATCH(n.title) AGAINST('gf') + (MATCH(n.contents) AGAINST('gf') + MATCH(n.extend_contents) AGAINST('gf')) / 2 ) / 3 * 4 AS relevance, CONCAT('../news/news.php?id=',n.id) AS link
FROM phpboost_news n
WHERE ( MATCH(n.title) AGAINST('gf') OR MATCH(n.contents) AGAINST('gf') OR MATCH(n.extend_contents) AGAINST('gf') )
AND visible = 1 AND ('1356116358' > start AND ( end = 0 OR '1356116358' < end ) )
ORDER BY relevance DESC LIMIT 0, 100) UNION (SELECT
18 AS id_search,
a.id AS id_content,
a.title AS titre,
( 2 * MATCH(a.title) AGAINST('gf') + MATCH(a.contents) AGAINST('gf') ) / 3 * 2 AS relevance, CONCAT(CONCAT(CONCAT('../produit/produit.php?id=',a.id),'&cat='),a.idcat) AS link
FROM phpboost_produit a
LEFT JOIN phpboost_produit_cats ac ON ac.id = a.idcat
WHERE
 
a.visible = 1 AND ((ac.visible = 1 AND ac.auth LIKE '%s:3:"r-1";i:1;%') OR a.idcat = 0)
 
AND (MATCH(a.title) AGAINST('gf') OR MATCH(a.contents) AGAINST('gf'))
ORDER BY relevance DESC LIMIT 0, 10) UNION (SELECT 19 AS `id_search`,
`id` AS `id_content`,
`title` AS `title`,
((MATCH(title) AGAINST('gf') )* 1) AS `relevance`,
CONCAT('../wiki/wiki.php?title=',encoded_title) AS `link`
FROM phpboost_wiki_articles
WHERE MATCH(title) AGAINST('gf'))
 
Illegal mix of collations for operation 'UNION'
 
 
Ligne 338 : search.class.php