SQLSTATE[42883]: Undefined function: 7 ERROR: function if(boolean, character varying, character varying) does not exist
LINE 21: , IF(ct.name IS NOT NULL, ct.name, e...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts. (Connection: pgsql, SQL: select "ec_product_categories"."id", "ec_product_categories"."name", "ec_product_categories"."order", "parent_id",
CONCAT(slugs.prefix,
CASE
WHEN slugs.prefix IS NOT NULL AND slugs.prefix != '' THEN '/'
ELSE ''
END,
slugs.key) as url
, "icon", "image", "icon_image",
CASE
WHEN st.key IS NOT NULL THEN CONCAT(st.prefix,
CASE
WHEN st.prefix IS NOT NULL AND st.prefix != '' THEN '/'
ELSE ''
END, st.key)
ELSE CONCAT(slugs.prefix,
CASE
WHEN slugs.prefix IS NOT NULL AND slugs.prefix != '' THEN '/'
ELSE ''
END, slugs.key)
END as url
, IF(ct.name IS NOT NULL, ct.name, ec_product_categories.name) as name from "ec_product_categories" left join "slugs" on "slugs"."reference_id" = "ec_product_categories"."id" and "slugs"."reference_type" = Botble\Ecommerce\Models\ProductCategory left join "slugs_translations" as "st" on "st"."slugs_id" = "slugs"."id" and "st"."lang_code" = en_AU left join "ec_product_categories_translations" as "ct" on "ec_product_categories_id" = "ec_product_categories"."id" and "ct"."lang_code" = en_AU where "status" = published order by "ec_product_categories"."order" asc) (View: platform/plugins/ecommerce/resources/views/themes/includes/filters.blade.php) (View: platform/plugins/ecommerce/resources/views/themes/includes/filters.blade.php) (View: platform/plugins/ecommerce/resources/views/themes/includes/filters.blade.php) (View: platform/plugins/ecommerce/resources/views/themes/includes/filters.blade.php)
Get 10% off on First Service
Subscribe our Newsletter
Your experience on this site will be improved by allowing cookies
Cookie Policy
