Support archive

FULLTEXT errors after moving server

paul.bellamy 15 Dec 2016 16:30 problem, rejected

We just moved to a dedicated server and now we're getting this error whenever someone executes a search (here I did a search for 'belfast'):

Error Number: 1191

Can't find FULLTEXT index matching the column list

SELECT exp_low_search_indexes.entry_id, exp_low_search_indexes.collection_id, MATCH(exp_low_search_indexes.index_text) AGAINST('belfast') AS 'score' FROM ('exp_low_search_indexes') WHERE 'exp_low_search_indexes'.'site_id' IN ('1') AND MATCH(index_text) AGAINST('+belfast' IN BOOLEAN MODE)

Filename: third_party/low_search/filters/keywords/lsf.keywords.php

Line Number: 293

I've updated to v4.4.4 (this is an EE 2.7.3 site)

Replies

1. Low 16 Dec 2016 08:00

   Can you try and run this query:
   
   

   ALTER TABLE 'exp_low_search_indexes' ADD FULLTEXT ('index_text');

   
   
   ...does that help?

2. paul.bellamy 16 Dec 2016 13:54

   Thanks Low - I ran a search and got no results, then I re-indexed all my collections and now I get the same error again. Really weird.

3. Low 16 Dec 2016 14:10

   Did you migrate the DB as well? Could be that it is an INNODB, which doesn't support FULLTEXT in its earlier versions.
   
   Try running this query before the previous one I mentioned:
   
   

   ALTER TABLE 'exp_low_search_indexes' ENGINE = MYISAM;

   
   
   ...and then run the other ALTER TABLE query again. If that doesn't help, I'd ask your host about it.

4. paul.bellamy 16 Dec 2016 14:49

   Thanks Low. That didn't work either so I'm batting it back to the hosts, as it worked before we migrated! I'll let you know what they come back with in case it's useful.

5. Paul Cripps 11 Feb 2019 21:46

   Can I ask if this was resolved Paul?