phpBB.de

Code: Alles auswählen

Allgemeiner Fehler
SQL ERROR [ mysqli ]

Can't find FULLTEXT index matching the column list [1191]

SQL

SELECT f.forum_id, f.forum_name, t.*, MATCH (t.topic_title) AGAINST ('tucks details november dezember 2016') AS score, tt.mark_time, ft.mark_time as f_mark_time FROM (phpbb_1953topics t) LEFT JOIN phpbb_1953forums f ON (f.forum_id = t.forum_id) LEFT JOIN phpbb_1953topics_track tt ON (tt.topic_id = t.topic_id AND tt.user_id = 2) LEFT JOIN phpbb_1953forums_track ft ON (ft.forum_id = f.forum_id AND ft.user_id = 2) WHERE MATCH (t.topic_title) AGAINST ('tucks details november dezember 2016') >= 0.5 AND t.topic_status <> 2 AND t.topic_approved = 1 AND t.topic_time > (UNIX_TIMESTAMP() - 31536000) AND t.topic_id <> 32163 AND f.forum_id NOT IN ('9', '16', '89', '90', '24', '48', '109', '5', '66', '6', '47', '26', '32', '87', '88', '11', '12', '58', '38', '39', '40', '41', '42', '43', '36', '72', '51', '54', '55', '99', '59', '61', '76', '45', '50') LIMIT 5