From 74f3e8a6a57d7fe1b930571778259f03c251cc74 Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Sat, 14 Apr 2018 12:59:40 +0200 Subject: packages/pkginfo.php: fix "GROUP BY" --- packages/pkginfo.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'packages') diff --git a/packages/pkginfo.php b/packages/pkginfo.php index 688de8e..22b50dd 100644 --- a/packages/pkginfo.php +++ b/packages/pkginfo.php @@ -99,7 +99,7 @@ " AND `repository_stability_relations`.`less_stable`=" . $mysql_content["repo_stability"] . ") ON `install_target_providers`.`install_target`=`dependencies`.`depending_on`" . " WHERE `dependencies`.`dependent`=" . $mysql_content["id"] . - " GROUP BY `install_targets`.`id`" . + " GROUP BY `install_targets`.`id`,`dependency_types`.`id`" . " ORDER BY FIELD (`dependency_types`.`name`,\"run\",\"make\",\"check\",\"link\"), `install_targets`.`name`" )) die_500("Query failed: " . $mysql->error); @@ -157,7 +157,7 @@ " JOIN `repository_stability_relations` ON `repository_stability_relations`.`less_stable`=`repositories`.`stability`" . " AND `repository_stability_relations`.`more_stable`=" . $mysql_content["repo_stability"] . " WHERE `install_target_providers`.`package`=" . $mysql_content["id"] . - " GROUP BY `binary_packages`.`id`" . + " GROUP BY `binary_packages`.`id`,`dependency_types`.`id`" . " ORDER BY FIELD (`dependency_types`.`name`,\"run\",\"make\",\"check\",\"link\"), `install_targets`.`name`" )) die_500("Query failed: " . $mysql->error); -- cgit v1.2.3