La page de résultats de la recherche Thelia me renvoie 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, `requested_locale_i18n`.`TITLE` AS i18n_TITLE, `requested_locale_i18n`.`CHAPO` AS i18n_CHAPO, `requested_locale_i18n`.`DESCRIPTION` AS i18n_DESCRIPTION, `requested_locale_i18n`.`POSTSCRIPTUM` AS i18n_POSTSCRIPTUM, `requested_locale_i18n`.`META_TITLE` AS i18n_META_TITLE, `requested_locale_i18n`.`META_DESCRIPTION` AS i18n_META_DESCRIPTION, `requested_locale_i18n`.`META_KEYWORDS` 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) INNER JOIN `product_i18n` `requested_locale_i18n` ON (product.ID=requested_locale_i18n.ID AND `requested_locale_i18n`.LOCALE = :p2) WHERE CASE WHEN NOT ISNULL(`requested_locale_i18n`.ID) THEN `requested_locale_i18n`.`TITLE` ELSE `default_locale_i18n`.`TITLE` END LIKE :p3 AND product.VISIBLE=:p4 GROUP BY product.ID) propelmatch4cnt]
Je suis preneur de la moindre piste car je sèche complètement.
J'utilise Thelia 2.0.3