Closed (duplicate)
Project:
Fuzzy Search
Version:
7.x-1.x-dev
Component:
Code
Priority:
Major
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
28 Aug 2012 at 22:41 UTC
Updated:
13 Nov 2012 at 01:29 UTC
I created a view that uses the fuzzy search index. All I am searching for is the word "do". This is the error that comes up. This part of the query is constructed on includes/service.inc:944
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 ') GROUP BY t.word_id, t.item_id HAVING (SUM(t.completeness) >= '40') UNION ALL' at line 1
Comments
Comment #1
awolfey commentedI'm pretty sure this is covered in #1315622: SQLSTATE[42S22] in 2 variations