From f1a6d7ddc580b913ba35532b4c701bfd8e320a16 Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Thu, 31 May 2018 15:58:14 +0200 Subject: buildmaster/mysql-issues.php, buildmaster/status.php, buildmaster/to-delete.php: read `is_to_be_deleted` and `last_moves` from `binary_packages_in_repositories` --- buildmaster/status.php | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) (limited to 'buildmaster/status.php') diff --git a/buildmaster/status.php b/buildmaster/status.php index 46c2fc1..2b1bd11 100644 --- a/buildmaster/status.php +++ b/buildmaster/status.php @@ -24,10 +24,11 @@ if ($result -> num_rows > 0) { } $result = mysql_run_query( - "SELECT MAX(`binary_packages`.`last_moved`) AS `last_moved`" . + "SELECT MAX(`binary_packages_in_repositories`.`last_moved`) AS `last_moved`" . " FROM `binary_packages`" . + " JOIN `binary_packages_in_repositories` ON `binary_packages_in_repositories`.`package`=`binary_packages`.`id`" . " JOIN `build_assignments` ON `binary_packages`.`build_assignment`=`build_assignments`.`id`" . - " WHERE `binary_packages`.`last_moved`>`build_assignments`.`return_date`" + " WHERE `binary_packages_in_repositories`.`last_moved`>`build_assignments`.`return_date`" ); if ($result -> num_rows > 0) { -- cgit v1.2.3