summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorErich Eckner <git@eckner.net>2018-04-14 12:59:40 +0200
committerErich Eckner <git@eckner.net>2018-04-14 12:59:40 +0200
commit74f3e8a6a57d7fe1b930571778259f03c251cc74 (patch)
tree0c3b56f2909da02a8f4da97bed660106d80ffb0d
parentcd1931b43937d02283c87e92eddeb04c477c3f9b (diff)
downloadarchweb32-74f3e8a6a57d7fe1b930571778259f03c251cc74.tar.xz
packages/pkginfo.php: fix "GROUP BY"
-rw-r--r--packages/pkginfo.php4
1 files changed, 2 insertions, 2 deletions
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);