Problem with export Lens GroupBY

[litalboa]

I'm trying to export to excel and I'm getting an error:

my Lens code

public static function query(LensRequest $request, $query) { return $request->withOrdering($request->withFilters( $query->select(self::columns()) ->groupBy('products.variant_title') )); }

protected static function columns() { return [ 'products.variant_title', DB::raw('sum(products.variant_quantity) as quantity'), ]; }

please advise how to fix it. thanks :)

[patrickbrouwers]

Perhaps good to check these: https://mattstauffer.com/blog/strict-mode-and-other-mysql-customizations-in-laravel-5-2/ The query you pass has some issues in strict mode