Getting "Error Code: 1191. Can't find FULLTEXT index matching the column list" when querying multiple columns with FULLTEXT indexes simultaneously

Using MySQL 8.0, InnoDB Engine. I can query the columns and return results using the fulltext index on individual columns such as this:

SELECT *
FROM all_prod
WHERE MATCH (job_summary) AGAINST ('marketing');

SELECT *
FROM all_prod
WHERE MATCH (sub_role) AGAINST ('marketing');

SELECT *
FROM all_prod
WHERE MATCH (region) AGAINST ('marketing');

SELECT *
FROM all_prod
WHERE MATCH (job_title) AGAINST ('marketing');

SELECT *
FROM all_prod
WHERE MATCH (industry) AGAINST ('marketing');

SELECT *
FROM all_prod
WHERE MATCH (industry2) AGAINST ('marketing');

SELECT *
FROM all_prod
WHERE MATCH (company_industry) AGAINST ('marketing');

However, when trying to run something like this:

SELECT *
FROM all_prod
WHERE MATCH (sub_role, region, job_title, job_summary, 
industry2, industry, company_industry) 
AGAINST ('+marketing' IN BOOLEAN MODE);

or

SELECT *
FROM all_prod
WHERE location_continent = 'Europe'
  AND mobile IS NOT NULL 
  AND emails IS NOT NULL 
  AND phone_numbers IS NOT NULL
  AND MATCH (job_summary, sub_role, region, job_title, 
   industry, industry2, company_industry) 
   AGAINST ('marketing');

I receive the error

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

Can someone explain what I'm doing wrong? Do I need to query each column individually and then combine the results afterwards? Eventually this will be part of a search functionality in PHP, I'm just testing the SQL first to make sure it will work as intended..

I have run a TABLE OPTIMIZE statement already, to rebuild the indexes and make sure there wasn't an issue there..

The arguments to MATCH() must be the same columns as those in your fulltext index definition, and in the same order.

It sounds like you have created seven individual fulltext indexes, one for each single column.

If you want to run a MATCH() against all of the columns at once, you would need to define one index with all seven columns like the following:

CREATE FULLTEXT INDEX all_prod_ft ON all_prod (
 sub_role, 
 region, 
 job_title, 
 job_summary, 
 industry2, 
 industry, 
 company_industry
);