ralvarez asked 5 years ago
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
laraship Staff answered 5 years ago
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,
ralvarez
replied 5 years ago 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.
larashipPlease send us server and app login at [email protected] to check
Please login or Register to submit your answer
