Hello I bought the E-Commerce Template with an extended license and I can't set the default template because when I show the shop page i'm getting a sql error:
SQLSTATE[42000]: Syntax error or access violation: 1055
Illuminate Database QueryException (42000)
SQLSTATE[42000]: Syntax error or access violation: 1055 'celcommercedb.ecommerce_products.name' isn't in GROUP BY (SQL: select ecommerce_products
.* from ecommerce_products
inner join ecommerce_sku
on ecommerce_sku
.product_id
= ecommerce_products
.id
where ecommerce_products
.status
= active and ecommerce_sku
.status
= active group by ecommerce_sku
.product_id
, ecommerce_products
.id
limit 15 offset 0)
Attachments
Hello,
Have you made any changes to config/database.php ?
seems you have strict mode turned on
https://github.com/laravel/framework/issues/14997
go to folder > config/database.php > set 'strict' => false,
Please login or Register to submit your answer