Try changing to DB::raw()
Sql query works in PDO, doesnt in Laravel with DB
I have a query like that that runs well when i use PDO::MySQL: select max(wartosc) as wiatr, min(wartosc) as wiatr_min, avg(wartosc) as wiatr_avg, data_godzina_minuta from wiatr where created_at >= DATE_SUB(NOW(),INTERVAL 12 HOUR) GROUP BY SUBSTRING(data_godzina_minuta, 1, 14)
However when i run it with: \DB::Select(); i get following error Syntax error or access violation: 1055 'ensim_taras.wiatr.data_godzina_minuta' isn't in GROUP BY (SQL: select max(wartosc) as wiatr, min(wartosc) as wiatr_min, avg(wartosc) as wiatr_avg, data_godzina_minuta from wiatr where created_at >= DATE_SUB(NOW(),INTERVAL 12 HOUR) GROUP BY SUBSTRING(data_godzina_minuta, 1, 14))
Please or to participate in this conversation.