Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.

ensim's avatar
Level 1

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))

0 likes
2 replies

Please or to participate in this conversation.