Group by error

[atillay]

Hello,
I'm using your bundle on Symfony 6.2 with PHP 8.2 and PostgreSQL 14.1.
I've got a group by error on the ranky/media/filters endpoint.
Did I miss something ? Before it was working because I was using MySQL with disabled ONLY_FULL_GROUP_BY

The query that fails :

SELECT EXTRACT(YEAR FROM r0_.created_at) AS sclr_0, EXTRACT(MONTH FROM r0_.created_at) AS sclr_1, count(r0_.id) AS sclr_2 
FROM ranky_media r0_ GROUP BY sclr_0, sclr_1 ORDER BY r0_.created_at ASC;

And the error :

An exception occurred while executing a query: SQLSTATE[42803]: Grouping error: 7 ERROR: column "r0_.created_at" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: ... ranky_media r0_ GROUP BY sclr_0, sclr_1 ORDER BY r0_.create...

[chiqui3d]

I apologize for the inconvenience. I use MariaDB and SQLite for testing, and they did not report this error. I will fix it tomorrow. The issue is with the orderBy clause and the createdAt field. As the error message indicates, I am using this field but I have not specified it either in an aggregation function or in the GroupBy clause

[chiqui3d]

I close the issue, since it should be fixed.