Suggesters page not working

[xvilo]

Description

When you're on a package overview page, press the suggesters link and then it gives a 500. The following logs are produced:

[2024-07-24T14:03:28.498722+00:00] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: "An exception occurred while executing a query: SQLSTATE[42803]: Grouping error: 7 ERROR:  column "p.id" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: SELECT p.id, p.name, p.description, p.language, p.abandoned,...                ^" at ExceptionConverter.php line 87 {"exception":"[object] (Doctrine\\DBAL\\Exception\\DriverException(code: 7): An exception occurred while executing a query: SQLSTATE[42803]: Grouping error: 7 ERROR:  column \"p.id\" must appear in the GROUP BY clause or be used in an aggregate function\nLINE 1: SELECT p.id, p.name, p.description, p.language, p.abandoned,...\n               ^ at /app/vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php:87)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 7): SQLSTATE[42803]: Grouping error: 7 ERROR:  column \"p.id\" must appear in the GROUP BY clause or be used in an aggregate function\nLINE 1: SELECT p.id, p.name, p.description, p.language, p.abandoned,...\n               ^ at /app/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28)\n[previous exception] [object] (PDOException(code: 42803): SQLSTATE[42803]: Grouping error: 7 ERROR:  column \"p.id\" must appear in the GROUP BY clause or be used in an aggregate function\nLINE 1: SELECT p.id, p.name, p.description, p.language, p.abandoned,...\n               ^ at /app/vendor/doctrine/dbal/src/Driver/PDO/Statement.php:130)"} []

Can you reproduce the bug on the Packeton demo site?

No

Database

PostgreSQL

Screenshots

With debug:

How are you running Packeton?

• Inside Kubernetes
• PostgresSQL (15)
• Redis (redis:7.2.5-debian-12-r2)
• Caddy (latest) + FrankenPHP (latest) + PHP 8.3 (latest)