Error

The website encountered an unexpected error. Please try again later.

Error message

PDOException: SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'db519978856.t.field_product_commerce_price_amount_decimal_asc' which is not in SELECT list; this is incompatible with DISTINCT: SELECT DISTINCT t.item_id AS item_id, :score AS score FROM {search_api_db_product_display} t WHERE ( (t.field_product_commerce_price_amount_decimal_asc IS NOT NULL ) ) ORDER BY t.field_product_commerce_price_amount_decimal_asc ASC LIMIT 1 OFFSET 0; Array ( [:score] => 1000 ) in SearchApiDbService->search() (line 1106 of /homepages/43/d240597226/htdocs/site/EDUCTIKA/kickstart/profiles/commerce_kickstart/modules/contrib/search_api_db/service.inc).