We have ver 1.9.2.2. I have installed the extension but getting this error when we try to search
a:5:{i:0;s:691:"SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS query_id, s.product_id, MATCH (s.data_index) AGAINST ('' IN BOOLEAN MOD' at line 1, query was: INSERT INTO catalogsearch_result SELECT AS query_id, s.product_id, MATCH (s.data_index) AGAINST (:query IN BOOLEAN MODE) AS relevance FROM catalogsearch_fulltext AS s
INNER JOIN catalog_product_entity AS e ON e.entity_id = s.product_id WHERE (s.store_id = 1) AND (MATCH (s.data_index) AGAINST (:query IN BOOLEAN MODE)) ON DUPLICATE KEY UPDATE relevance = VALUES(relevance)";i:1;s:4827:"#0
We have ver 1.9.2.2. I have installed the extension but getting this error when we try to search
a:5:{i:0;s:691:"SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS
query_id,s.product_id, MATCH (s.data_index) AGAINST ('' IN BOOLEAN MOD' at line 1, query was: INSERT INTOcatalogsearch_resultSELECT ASquery_id,s.product_id, MATCH (s.data_index) AGAINST (:query IN BOOLEAN MODE) ASrelevanceFROMcatalogsearch_fulltextASsINNER JOINcatalog_product_entityASeON e.entity_id = s.product_id WHERE (s.store_id = 1) AND (MATCH (s.data_index) AGAINST (:query IN BOOLEAN MODE)) ON DUPLICATE KEY UPDATErelevance= VALUES(relevance)";i:1;s:4827:"#0Thank you in advance.