phpBB.de

Code: Alles auswählen

Allgemeiner Fehler
SQL ERROR [ mysql4 ]

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

SQL

SELECT f.forum_id, f.forum_name, t.topic_id, t.topic_title, u.user_id, u.username, u.user_colour, t.topic_replies FROM (phpbb_5topics t) LEFT JOIN phpbb_5users u ON (u.user_id = t.topic_poster) LEFT JOIN phpbb_5forums f ON (f.forum_id = t.forum_id) WHERE MATCH (t.topic_title) AGAINST ('axyxy<' ) >= 0.5 AND t.topic_status <> 2 AND t.topic_id <> 14 GROUP BY t.topic_id ORDER BY rand() LIMIT 5

BACKTRACE

Code: Alles auswählen

ALTER TABLE phpbb_5topics ADD FULLTEXT topic_title (topic_title);