Can't find FULLTEXT index matching the column list

What is this error message trying to tell me?

Thanks!

select tID, date_format(date, ‘%m-%d-%Y’) as showDate, viewed, summary, MATCH (summary)
AGAINST (‘lemon’) AS score from testimonies where approved = ‘Yes’ and match (summary) against
(‘lemon’ in boolean mode) order by score desc limit 50;

Error Code: 1191. Can’t find FULLTEXT index matching the column list

it’s trying to tell you that you forgot to declare a fulltext index on the column(s) that you are trying to search in

ALTER TABLE testimonies
ADD FULLTEXT(summary)

:slight_smile: