Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Syntax error or access violation #79

Open
satwindersatty opened this issue Mar 2, 2017 · 0 comments
Open

Syntax error or access violation #79

satwindersatty opened this issue Mar 2, 2017 · 0 comments

Comments

@satwindersatty
Copy link

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

Thank you in advance.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant