SQLSTATE[42000]: Syntax error or access violation: 1055

Laraship QuestionsCategory: TechnicalSQLSTATE[42000]: Syntax error or access violation: 1055
ralvarez asked 6 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
1 Answers
laraship Staff answered 6 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,