Announcement
Rejoignez la communauté sur le Discord Thelia : https://discord.gg/YgwpYEE3y3
(02-09-2014 10:02:17)
(03-09-2014 08:08:20)
si je mets ces parametres
{assign var="amount" value="{count type="product" feature_values="1:(rouge)"}"}j'ai l'erreur suivante
PropelException: Unable to execute COUNT statement [SELECT COUNT(*) FROM (SELECT product.ID, product.TAX_RULE_ID, product.REF, product.VISIBLE, product.POSITION, product.TEMPLATE_ID, product.BRAND_ID, product.CREATED_AT, product.UPDATED_AT, product.VERSION, product.VERSION_CREATED_AT, product.VERSION_CREATED_BY, ROUND(CASE WHEN `pse`.PROMO=1 THEN `price`.PROMO_PRICE ELSE `price`.PRICE END, 2) AS real_price, `price`.PRICE AS price, `price`.PROMO_PRICE AS promo_price, NOT ISNULL(`requested_locale_i18n`.`ID`) AS IS_TRANSLATED, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`TITLE` ELSE `default_locale_i18n`.`TITLE` END AS i18n_TITLE, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`CHAPO` ELSE `default_locale_i18n`.`CHAPO` END AS i18n_CHAPO, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`DESCRIPTION` ELSE `default_locale_i18n`.`DESCRIPTION` END AS i18n_DESCRIPTION, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`POSTSCRIPTUM` ELSE `default_locale_i18n`.`POSTSCRIPTUM` END AS i18n_POSTSCRIPTUM, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`META_TITLE` ELSE `default_locale_i18n`.`META_TITLE` END AS i18n_META_TITLE, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`META_DESCRIPTION` ELSE `default_locale_i18n`.`META_DESCRIPTION` END AS i18n_META_DESCRIPTION, CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`META_KEYWORDS` ELSE `default_locale_i18n`.`META_KEYWORDS` END AS i18n_META_KEYWORDS, `pse`.ID AS pse_id, `pse`.NEWNESS AS is_new, `pse`.PROMO AS is_promo, `pse`.QUANTITY AS quantity, `pse`.WEIGHT AS weight, `pse`.EAN_CODE AS ean_code, COUNT(`pse_count`.ID) AS pse_count FROM `product`
INNER JOIN `product_sale_elements` `pse` ON (product.ID=pse.PRODUCT_ID AND `pse`.IS_DEFAULT=1)
INNER JOIN `product_sale_elements` `pse_count` ON (product.ID=pse_count.PRODUCT_ID)
LEFT JOIN `product_price` `price` ON (pse.ID=price.PRODUCT_SALE_ELEMENTS_ID AND `price`.`currency_id` = :p1)
LEFT JOIN `product_i18n` `default_locale_i18n` ON (product.ID=default_locale_i18n.ID AND `default_locale_i18n`.LOCALE = :p2)
LEFT JOIN `product_i18n` `requested_locale_i18n` ON (product.ID=requested_locale_i18n.ID AND `requested_locale_i18n`.LOCALE = :p3)
LEFT JOIN `feature_product` `fv_1_rouge` ON ((product.ID=fv_1_rouge.PRODUCT_ID AND `fv_1_rouge`.FEATURE_ID = :p4) AND `fv_1_rouge`.BY_DEFAULT = :p5) WHERE ((NOT ISNULL(`requested_locale_i18n`.ID) OR NOT ISNULL(`default_locale_i18n`.ID)) AND ((NOT ISNULL(`fv_1_rouge`.ID)))) AND product.VISIBLE=:p6 GROUP BY product.ID) propelmatch4cnt]j'ai un seul produit qui a une feature = rouge
voici la table feature_product
je ne comprends pas mon erreur
(03-09-2014 09:00:16)
(03-09-2014 11:14:56)
(02-10-2014 10:49:04)
(02-10-2014 11:09:13)
(02-10-2014 12:19:30)
oups
je viens de regarder mon script, j'avais bien fini par trouver apparemment, a force de faire de tout........ et peut etre un peu d'alzheimer 
voici ma boucle:
{$featureResultSearch=""}
{loop name="features" type="feature"}
{$featureResult=""}
{loop name="feature-availability" type="feature-availability" feature="$ID"}
{if {$TITLE|lower}=={$keysearch|lower}}
{$featureResult = $ID}
{/if}
{/loop}
{if $featureResult != ""}
{$featureResultSearch = "{$ID}:{$featureResult}"}
{/if}
{/loop}
......
{loop type="product" name="product_list" feature_availability=$featureResultSearch limit=$limit page=$product_page order=$product_order}
..............
{/loop}