Can't find FULLTEXT index matching the column list
Hallo,
ich nutze das Forum/Helpdesk in Contao 2.9.1.
Wenn ich eine Suche ausführen möchte, bekomme ich folgende Fehlermeldung:
HTML-Code:
Fatal error: Uncaught exception Exception with message Query error:
Can't find FULLTEXT index matching the column list
( select `tck`.`id` as `tck_id`, `msg`.`id` as `msg_id`, `msg`.`reply` as `msg_reply`, `msg`.`poster` as `msg_poster`, `tck`.`subject` as `tck_subject`, `msg`.`message` as `msg_message`, `msg`.`atch1name` as `msg_atch1name`, `msg`.`atch2name` as `msg_atch2name`, `msg`.`atch3name` as `msg_atch3name`, `msg`.`atch4name` as `msg_atch4name`, `msg`.`atch5name` as `msg_atch5name`,
match (`tck`.`subject`) against ('test') as `tck_relevance`,
match (`msg`.`message`) against ('test') as `msg_relevance`
from `tl_helpdesk_tickets` as `tck` left join `tl_helpdesk_messages` as `msg`
on `tck`.`id`=`msg`.`pid` and `msg`.`published`='1'
where `tck`.`pid`='1' and `tck`.`published`='1' and ( (`msg`.`reply`='0' and match (`tck`.`subject`) against ('test')) or match (`msg`.`message`) against ('test') ))
thrown in /var/www/***.***.com/data/system/libraries/Database.php on line 642
Es scheinen also einige FULLTEXT-Indizes nicht gesetzt zu sein. Tritt der Fehler auch bei anderen auf? Wie müssen die denn genau gesetzt werden?
Vielen Dank und viele Grüße
Stefan
