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_collection = :db_condition_placeholder_0) )AND (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
(
[:db_condition_placeholder_0] => 8
[: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).