Support archive

Error Number: 1191 after form submission

Robert Hallatt 16 Jun 2016 18:17 question, complete

Hi Low,

I am attempting to set-up a search engine on my web site. For somne reason, I am getting the following error when I submit the search form:

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('registration') AS 'score' FROM ('exp_low_search_indexes') WHERE 'exp_low_search_indexes'.'site_id' IN ('1') AND MATCH(index_text) AGAINST('+registration' IN BOOLEAN MODE)

Filename: /data/sites/app/add-ons/low_search/filters/keywords/lsf.keywords.php

Line Number: 293

Is it my code or is it the DB that is the problem?

Thanks,

Rob

Replies

1. Low 17 Jun 2016 07:08

   Seems like the fulltext index hasn't been applied to the fields. It should have done that upon installation.
   
   Can you try and run this query?
   
   

   ALTER TABLE exp_low_search_indexes ADD FULLTEXT ('index_text')

2. Robert Hallatt 17 Jun 2016 14:38

   Thanks! It's now working as expected.