[Load jQuery once] Tab ne s'affichent pas

More
11 years 1 month ago #40738 by ggppdk
Hello

translation is wrong, switch your backend language with english to confim this

about parameters please read popup description,

Value Comparison
-- important (used) when filter is displayed as (appears as) range

Values combination
-- used when filter is displayed as (appears as) checkboxes or tag-like selection
... these all multiple values to be selected


-- 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
11 years 1 month ago #40758 by stel68
Hello

I'm not far of the success...
Actually when I switch the backend in english, value filters can be combined. I selected "all", and... I have a SQL error message in my frontend when I do a search.

here is the message :
getData(): SQL QUERY ERROR:
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 'ANDvalue='wifi') ) GROUP BY i.id ORDER BY rel.catid, rel.ordering ASC, i.title ' at line 1 SQL=SELECT SQL_CALC_FOUND_ROWS i.id FROM bl9ye_content AS i JOIN bl9ye_flexicontent_items_ext AS ie ON ie.item_id = i.id JOIN bl9ye_flexicontent_types AS ty ON ie.type_id = ty.id JOIN bl9ye_flexicontent_cats_item_relations AS rel ON rel.itemid = i.id JOIN bl9ye_categories AS c ON c.id = i.catid LEFT JOIN bl9ye_users AS u ON u.id = i.created_by WHERE 1 AND rel.catid IN ('8') AND ( i.state IN (1, -5) OR ( i.created_by = 0 AND i.created_by != 0 ) ) AND ( ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= UTC_TIMESTAMP() ) OR ( i.created_by = 0 AND i.created_by != 0 ) ) AND ( ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= UTC_TIMESTAMP() ) OR ( i.created_by = 0 AND i.created_by != 0 ) ) AND ( ie.language LIKE 'fr%' OR ie.language="*" ) 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 DISTINCT item_id FROM bl9ye_flexicontent_fields_item_relations as rel WHERE rel.field_id = 34 AND (value='1') ) AND i.id IN (SELECT DISTINCT item_id FROM bl9ye_flexicontent_fields_item_relations as rel WHERE rel.field_id = 15 AND (value='Ain') ) AND i.id IN (SELECT DISTINCT item_id FROM bl9ye_flexicontent_fields_item_relations as rel WHERE rel.field_id = 28 AND (value='piscine_exterieure'ANDvalue='wifi') ) GROUP BY i.id ORDER BY rel.catid, rel.ordering ASC, i.title LIMIT 0, 10
getAlphaindex(): SQL QUERY ERROR:
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 'ANDvalue='wifi') ) ORDER BY alpha ASC' at line 1 SQL=SELECT DISTINCT LOWER(SUBSTRING(i.title FROM 1 FOR 1)) AS alpha FROM bl9ye_content AS i JOIN bl9ye_flexicontent_items_ext AS ie ON ie.item_id = i.id JOIN bl9ye_flexicontent_types AS ty ON ie.type_id = ty.id JOIN bl9ye_flexicontent_cats_item_relations AS rel ON rel.itemid = i.id JOIN bl9ye_categories AS c ON c.id = i.catid LEFT JOIN bl9ye_users AS u ON u.id = i.created_by WHERE 1 AND rel.catid IN ('8') AND ( i.state IN (1, -5) OR ( i.created_by = 0 AND i.created_by != 0 ) ) AND ( ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= UTC_TIMESTAMP() ) OR ( i.created_by = 0 AND i.created_by != 0 ) ) AND ( ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= UTC_TIMESTAMP() ) OR ( i.created_by = 0 AND i.created_by != 0 ) ) AND ( ie.language LIKE 'fr%' OR ie.language="*" ) 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 DISTINCT item_id FROM bl9ye_flexicontent_fields_item_relations as rel WHERE rel.field_id = 34 AND (value='1') ) AND i.id IN (SELECT DISTINCT item_id FROM bl9ye_flexicontent_fields_item_relations as rel WHERE rel.field_id = 15 AND (value='Ain') ) AND i.id IN (SELECT DISTINCT item_id FROM bl9ye_flexicontent_fields_item_relations as rel WHERE rel.field_id = 28 AND (value='piscine_exterieure'ANDvalue='wifi') ) ORDER BY alpha ASC


For me it is just chinese... :)
my field is a checkbox

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

More
11 years 1 month ago #40764 by ggppdk
Hello

this is a bug when enabling (for a field filter):
value combination to require "ALL" instead of "ANY" value

-- to apply a quick fix , edit file:
components/com_flexicontent/classes/flexicontent.fields.php

find line:
Code:
$comb_op = $filter_values_combination ? 'AND' : ' OR ';
and replace with
Code:
$comb_op = $filter_values_combination ? ' AND ' : ' OR ';


-- 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
11 years 1 month ago #40771 by stel68
Hello !

Ok that's good now : the search is loading, but no result appears (I have the message : no result found (...).
However, I tested with a value combinaison I'm sure an item exists...
www.facilidogs.fr/index.php/campings?filter_34 []=1&filter_15[]=Ain&filter_28[3]=wifi&filter_28[4]=aire_jeux

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

More
11 years 1 month ago #40776 by ggppdk
Hello

yes,
indeed i looked at it,
and its not implemented properly,

please disable this setting "value combination" (it is a new feature) we will try to fix in next release


-- 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
11 years 1 month ago #40795 by stel68
OK,
thanks for your help
I'll wait the next release ;)

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

Moderators: vistamediajoomlacornerggppdk
Time to create page: 0.420 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