I get the following error in 2.1.0 r1702 while searching

More
11 years 10 months ago #38891 by boniaditya
can you tell me what is wrong with my database

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 ') AND c.published = 1 AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_' at line 1 SQL=SELECT i.id, i.title AS title, i.sectionid, i.created, i.id AS fc_item_id, ie.search_index 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 jos_content AS i JOIN jos_categories AS c ON c.id = i.catid JOIN jos_flexicontent_items_ext AS ie ON ie.item_id = i.id JOIN jos_flexicontent_types AS ty ON ie.type_id = ty.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) AND c.access IN (0,1,1) AND i.access IN (0,1,1) AND i.id IN ( SELECT item_id FROM jos_flexicontent_items_ext WHERE MATCH (search_index) AGAINST ('+gandhi*' IN BOOLEAN MODE) ) GROUP BY i.id ORDER BY i.title ASC LIMIT 0, 50

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

More
11 years 10 months ago #38893 by ggppdk
Hello,
Previous version did not include in search "Published, in progress" and (if parameter enabled) archived items

but fix has a bug:

please edit file:
plugins/search/flexiadvsearch/flexiadvsearch.php
and replace line:
Code:
. ' AND i.state IN (1,-5,'. ($search_archived ? (FLEXI_J16GE ? 2:-1) :'' ) .') '
with
Code:
. ' AND i.state IN (1,-5'. ($search_archived ? ','.(FLEXI_J16GE ? 2:-1) :'' ) .') '


-- 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.

Moderators: vistamediajoomlacornerggppdk
Time to create page: 0.294 seconds
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
Save