MySQL full-text index

Question

I am trying to set up a FULLTEXT index in an existing db table (e.g. 50k records) with the following command:

ALTER TABLE  `record_attributes` ADD FULLTEXT  `FULLTEXT` (`content_text` ,`content_varchar`)

The problem is that when I try to execute MATCH AGAINST in this table, it gives me this error:

#1191 - Can't find FULLTEXT index matching the column list

I searched on google and did not find anything that I could do wrong. Do I need to add an index to tables without any records?

Greetings

Answer 1

If you search on 1 column, the full-text index on 2 columns does not match.