[SOLVED] Search 1064 - You have an error in your SQL syntax;

More
10 years 3 weeks ago - 10 years 3 weeks ago #49974 by agata
I encountered the following error when using the search on flexicontent.
Code:
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 ') JOIN spiral_categories AS c ON c.id = i.catid JOIN spiral_flexicontent_items_e' at line 1 SQL=SELECT i.id, i.title AS title, i.created, i.id AS fc_item_id, i.access, ie.type_id, i.language, GROUP_CONCAT(ai.search_index ORDER BY f.ordering ASC SEPARATOR ' ') AS text, CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END as slug, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as categoryslug, CONCAT_WS( " / ", 'Content', c.title, i.title ) AS section, c.access as category_access, ty.access as type_access, 1 AS has_access FROM spiral_content AS i JOIN spiral_flexicontent_advsearch_index as ai ON ai.item_id = i.id AND ai.field_id IN () JOIN spiral_categories AS c ON c.id = i.catid JOIN spiral_flexicontent_items_ext AS ie ON ie.item_id = i.id JOIN spiral_flexicontent_types AS ty ON ie.type_id = ty.id JOIN spiral_flexicontent_fields as f ON f.id=ai.field_id WHERE 1 AND i.state IN (1,-5) AND c.published = 1 AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= UTC_TIMESTAMP() ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= UTC_TIMESTAMP() ) AND ty.access IN (0,1,1,5) AND c.access IN (0,1,1,5) AND i.access IN (0,1,1,5) AND ie.type_id IN (1) AND i.id IN ( SELECT item_id FROM spiral_flexicontent_advsearch_index AS ts WHERE MATCH (ts.search_index) AGAINST ('+ss850*' IN BOOLEAN MODE) AND field_id IN ()) GROUP BY i.id ORDER BY i.created DESC, i.title LIMIT 0, 50

I had the flexi advanced search plugin published (all other search and smart search plugins were unpublished), the fields were configured correctly, the site was indexed and there was a menu item created for the search page.

Turned out the missing bit was Searchable Types in the configuration of the search menu item (Options tab). After selecting the type (in my case "Project") I wanted to be searched through, the problem was resolved.
Attachments:
Last edit: 10 years 3 weeks ago by agata.

Please Log in or Create an account to join the conversation.

More
10 years 3 weeks ago #49976 by ggppdk
Hello

can you post you post a picture of configuration that produced this error,

instead of error it is better to print a message about what needs to be configured


-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...

Please Log in or Create an account to join the conversation.

More
10 years 3 weeks ago #49978 by agata
I added a screenshot above

Please Log in or Create an account to join the conversation.

Moderators: vistamediajoomlacornerggppdk
Time to create page: 1.181 seconds
Save
Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Essential
These cookies are needed to make the website work correctly. You can not disable them.
Display
Accept
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline