Forum

2016-05-14 18:38:44
256
invalid query. (ERRNO 1214) The used table type doesn't support FULLTEXT indexes<hr />query: (SELECT 41 AS id_search,<br />f.id AS id_content,<br />f.question AS title,<br />( 2 * MATCH(f.question) AGAINST( 'Trainz') + MATCH(f.answer) AGAINST( 'Trainz')) / 3 * 3 AS relevance,<br />CONCAT('../faq/', id_category, '-', IF(id_category != 0, cat.rewrited_name, 'root'), '/#question', f.id) AS link<br />FROM phpboost_faq f<br />LEFT JOIN phpboost_faq_cats cat ON f.id_category = cat.id<br />WHERE ( MATCH(f.question) AGAINST( 'Trainz') OR MATCH(f.answer) AGAINST( 'Trainz') )<br />AND approved = 1<br />AND id_category IN (0, 3)<br />ORDER BY relevance DESC<br />LIMIT 100 OFFSET 0) UNION (SELECT 42 AS `id_search`,<br />MIN(msg.id) AS `id_content`,<br />t.title AS `title`,<br />MAX(( 2 * MATCH(t.title) AGAINST( 'Trainz') + MATCH(msg.contents) AGAINST( 'Trainz') ) / 3) * 4 AS `relevance`,<br />CONCAT('../forum/topic.php?id=', t.id, '#m', msg.id) AS `link`<br />FROM phpboost_forum_msg msg<br />JOIN phpboost_forum_topics t ON t.id = msg.idtopic<br />JOIN phpboost_forum_cats c ON c.id_parent != 0 AND c.id = t.idcat<br />WHERE ( MATCH(t.title) AGAINST( 'Trainz') OR MATCH(msg.contents) AGAINST( 'Trainz') ) AND msg.timestamp > '-1128756076'<br /> AND c.id IN (0,1,4,3,21,5,55,6,7,52,8,9,10,22,49,54,12,13,47)<br />GROUP BY t.id<br />ORDER BY relevance DESC<br />LIMIT 50) UNION (SELECT 43 AS id_search,<br />n.id AS id_content,<br />n.name AS title,<br />( 2 * MATCH(n.name) AGAINST( 'Trainz') + (MATCH(n.contents) AGAINST( 'Trainz') +<br />MATCH(n.short_contents) AGAINST( 'Trainz')) / 2 ) / 3 * 1 AS relevance,<br />CONCAT('../news/', id_category, '-', IF(id_category != 0, cat.rewrited_name, 'root'), '/', n.id, '-', n.rewrited_name) AS link<br />FROM phpboost_news n<br />LEFT JOIN phpboost_news_cats cat ON n.id_category = cat.id<br />WHERE ( MATCH(n.name) AGAINST( 'Trainz') OR MATCH(n.contents) AGAINST( 'Trainz') OR MATCH(n.short_contents) AGAINST( 'Trainz') )<br />AND id_category IN(0, 5, 6, 7, 9, 8, 1, 4)<br />AND (approbation_type = 1 OR (approbation_type = 2 AND start_date < '1463243924' AND (end_date > '1463243924' OR end_date = 0)))<br />ORDER BY relevance DESC<br />LIMIT 100 OFFSET 0) UNION (SELECT 45 AS id_search,<br />d.id AS id_content,<br />d.name AS title,<br />( 2 * MATCH(d.name) AGAINST( 'Trainz') + (MATCH(d.contents) AGAINST( 'Trainz') +<br />MATCH(d.short_contents) AGAINST( 'Trainz')) / 2 ) / 3 * 1 AS relevance,<br />CONCAT('../download/', id_category, '-', IF(id_category != 0, cat.rewrited_name, 'root'), '/', d.id, '-', d.rewrited_name) AS link<br />FROM phpboost_download d<br />LEFT JOIN phpboost_download_cats cat ON d.id_category = cat.id<br />WHERE ( MATCH(d.name) AGAINST( 'Trainz') OR MATCH(d.contents) AGAINST( 'Trainz') OR MATCH(d.short_contents) AGAINST( 'Trainz') )<br />AND id_category IN (0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15)<br />AND (approbation_type = 1 OR (approbation_type = 2 AND start_date < '1463243924' AND (end_date > '1463243924' OR end_date = 0)))<br />ORDER BY relevance DESC<br />LIMIT 100 OFFSET 0) UNION (SELECT 46 AS `id_search`,<br /> `id` AS `id_content`,<br /> `title` AS `title`,<br /> ((MATCH(title) AGAINST( 'Trainz') )* 5) AS `relevance`,<br /> CONCAT('../wiki/wiki.php?title=',encoded_title) AS `link`<br /> FROM phpboost_wiki_articles<br /> WHERE MATCH(title) AGAINST( 'Trainz'))
[0] /kernel/framework/io/db/driver/mysql/MySQLQuerier.class.php:48 - MySQLQuerier->execute(string, array)<br />[1] /kernel/framework/io/db/DBQuerier.class.php:50 - MySQLQuerier->select(string, array, int)<br />[2] /search/services/Search.class.php:325 - DBQuerier->select(string)<br />[3] /search/search.inc.php:53 - Search->insert_results(array)<br />[4] /search/search.inc.php:65 - execute_search(Search, array, array, array)<br />[5] /search/search.php:205 - get_search_results(string, array, array, array, array)<br />[URL] /search/search.php