Back to JKShop Support

Sevenface
Sevenface

When I view the category page (clicked on breadcrumb on the product detail page) I get this error:

SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #36 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'traumgarten_ag.jiri_jkshop_products_categories.category_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by (SQL: select * from `jiri_jkshop_products` inner join `jiri_jkshop_products_categories` on `id` = `jiri_jkshop_products_categories`.`product_id` where `active` = 1 and `category_id` in (1) and `visibility` = 1 group by `jiri_jkshop_products`.`id` order by `title` asc)

Last updated

Jiri Kubak
Jiri Kubak

Sevenface said:

When I view the category page (clicked on breadcrumb on the product detail page) I get this error:

Hi,

this will be fixed today in a new version.

Jiri

Sevenface
Sevenface

Thank you very much! Love that support!

1-3 of 3