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,
No I haven’t but I was using all updates first before check all pages and I’ve fixed the problem by runing the project as it without update any template or any plugin.
Please send us server and app login at [email protected] to check
Please login or Register to submit your answer