Send patches - preferably formatted by git format-patch - to patches at archlinux32 dot org.
summaryrefslogtreecommitdiff
path: root/packages/pkginfo.php
diff options
context:
space:
mode:
Diffstat (limited to 'packages/pkginfo.php')
-rw-r--r--packages/pkginfo.php7
1 files changed, 4 insertions, 3 deletions
diff --git a/packages/pkginfo.php b/packages/pkginfo.php
index ad127e5..58d74c1 100644
--- a/packages/pkginfo.php
+++ b/packages/pkginfo.php
@@ -19,7 +19,7 @@ require_once BASE . "/lib/style.php";
$json_content = $json_content["package"];
$mysql_result = mysql_run_query(
- "SELECT DISTINCT " .
+ "SELECT " .
"`binary_packages`.`id`," .
"`binary_packages`.`pkgname`," .
"`package_sources`.`pkgbase`," .
@@ -36,7 +36,7 @@ require_once BASE . "/lib/style.php";
"`git_repositories`.`name` AS `git_repo`," .
"`package_sources`.`uses_upstream`," .
"`package_sources`.`uses_modification`," .
- "`binary_packages_in_repositories`.`last_moved`," .
+ "MAX(`binary_packages_in_repositories`.`last_moved`)," .
"`sr`.`name` AS `stable_repo`" .
" FROM `binary_packages`" .
" JOIN `architectures` ON `binary_packages`.`architecture`=`architectures`.`id`" .
@@ -56,7 +56,8 @@ require_once BASE . "/lib/style.php";
"SELECT 1" .
" FROM `repository_moves` AS `rm`" .
" WHERE `rm`.`from_repository`=`sr`.`id`" .
- ")"
+ ")" .
+ " GROUP BY `binary_packages`.`id`"
);
if ($mysql_result -> num_rows != 1)