Forum

bonsoir
voici le  message d'erreur qaund on fait une recherche
Fatal error: Call to undefined method Sql::Query_insert() in /homepages/34/d296337196/htdocs/phpboost/phpboost/kernel/framework/content/search.class.php on line 144
 
merci
Pat
 
voici le complement d'erreur
 
reur fatale : invalid while request

(SELECT
2 AS id_search,
a.id AS id_content,
a.title AS title,
( 2 * MATCH(a.title) AGAINST('faqs') + MATCH(a.contents) AGAINST('faqs') ) / 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('faqs') OR MATCH(a.contents) AGAINST('faqs'))
ORDER BY relevance DESC LIMIT 0, 10) UNION (SELECT 3 AS `id_search`,
q.id AS `id_content`,
q.word AS `title`,
( MATCH(q.description) AGAINST('faqs') + MATCH(q.word) AGAINST('faqs') ) / 2 * 1 AS `relevance`,
CONCAT('../dictionary/dictionary.php?l=',q.word) AS `link`
FROM phpboost_dictionary q
WHERE ( MATCH(q.word) AGAINST('faqs')
OR MATCH(q.description) AGAINST('faqs') )) UNION (SELECT 4 AS id_search,
f.id AS id_content,
f.question AS title,
( 2 * MATCH(f.question) AGAINST('faqs') + MATCH(f.answer) AGAINST('faqs') ) / 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('faqs') OR MATCH(f.answer) AGAINST('faqs') ) AND f.idcat IN (1,2) ORDER BY relevance DESC LIMIT 0, 100) UNION (SELECT 5 AS `id_search`,
msg.id AS `id_content`,
t.title AS `title`,
MATCH(t.title) AGAINST('faqs') * 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('faqs')

GROUP BY t.id
ORDER BY relevance DESC LIMIT 0, 50) UNION (SELECT 6 AS id_search,
f.id AS id_content,
f.name AS title,
( 2 * MATCH(f.name) AGAINST('faqs') + MATCH(f.contents) AGAINST('faqs') ) / 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('faqs') OR MATCH(f.contents) AGAINST('faqs') ) AND f.idcat IN (3,5) ORDER BY relevance DESC LIMIT 0, 100) UNION (SELECT 7 AS id_search,
n.id AS id_content,
n.title AS title,
( 2 * MATCH(n.title) AGAINST('faqs') + (MATCH(n.contents) AGAINST('faqs') + MATCH(n.extend_contents) AGAINST('faqs')) / 2 ) / 3 * 1 AS relevance, CONCAT('../news/news.php?id=',n.id) AS link
FROM phpboost_news n
WHERE ( MATCH(n.title) AGAINST('faqs') OR MATCH(n.contents) AGAINST('faqs') OR MATCH(n.extend_contents) AGAINST('faqs') )
AND visible = 1 AND ('1258413123' > start AND ( end = 0 OR '1258413123' < end ) )
ORDER BY relevance DESC LIMIT 0, 100) UNION (SELECT 9 AS `id_search`,
q.id AS `id_content`,
q.author AS `title`,
( MATCH(q.contents) AGAINST('faqs') + MATCH(q.author) AGAINST('faqs') ) / 2 * 1 AS `relevance`,
CONCAT('../quotes/quotes.php?id=',q.id) AS `link`
FROM phpboost_quotes q
WHERE ( MATCH(q.author) AGAINST('faqs')
OR MATCH(q.contents) AGAINST('faqs') )) UNION (SELECT 10 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 '%faqs%')
OR ( q.contents LIKE '%faqs%')) UNION (SELECT 11 AS `id_search`,
`id` AS `id_content`,
`title` AS `title`,
((MATCH(title) AGAINST('faqs') )* 1) AS `relevance`,
CONCAT('../wiki/wiki.php?title=',encoded_title) AS `link`
FROM phpboost_wiki_articles
WHERE MATCH(title) AGAINST('faqs'))

Illegal mix of collations for operation 'UNION'


Ligne 337 : search.class.php
<strong></strong>

Édité par patgame Le 17/11/2009 à 00h15

Sujet déplacé dans la catégorie recherche.



regarde ceci où tu as déjà posté et où tu as déjà eu la solution : http://www.phpboost.com/forum/topic-7006-2+bug-du-module-search.php#m70924