[PHP-WEBMASTER] [web-bugs] master: Group by needs to specifically reference a column name, not a variable.

Thu, 21 Oct 2021 02:19:54 -0700 

Author: Danack (Danack)
Committer: Nikita Popov (nikic)
Date: 2021-10-21T11:19:46+02:00

Commit: 
https://github.com/php/web-bugs/commit/49be135fd809a72746539cea56d9221d01c860ad
Raw diff: 
https://github.com/php/web-bugs/commit/49be135fd809a72746539cea56d9221d01c860ad.diff

Group by needs to specifically reference a column name, not a variable.

Changed paths:
  M  src/Repository/BugRepository.php


Diff:

diff --git a/src/Repository/BugRepository.php b/src/Repository/BugRepository.php
index 8bb871fb..dadbb997 100644
--- a/src/Repository/BugRepository.php
+++ b/src/Repository/BugRepository.php
@@ -45,7 +45,7 @@ public function findOneById(int $id): array
                 FROM bugdb b
                 LEFT JOIN bugdb_votes ON b.id = bug
                 WHERE b.id = ?
-                GROUP BY bug
+                GROUP BY b.id
         ';
 
         $statement = $this->dbh->prepare($sql);

-- 
PHP Webmaster List Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to