summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorErich Eckner <git@eckner.net>2018-11-08 14:54:32 +0100
committerErich Eckner <git@eckner.net>2018-11-08 14:54:32 +0100
commit1a9e9dc143b73b29113c5d22c0812f25c43cd34a (patch)
treee6defc193b6a860832642d80cf15cf52b0c8c155
parent2d7c3c2008595ecad917f4b72743f7b263206484 (diff)
downloadwebsite-1a9e9dc143b73b29113c5d22c0812f25c43cd34a.tar.xz
buildmaster/mysql-issues.php: check for matching architecture for install_target_providers of serious issues
-rw-r--r--buildmaster/mysql-issues.php7
1 files changed, 6 insertions, 1 deletions
diff --git a/buildmaster/mysql-issues.php b/buildmaster/mysql-issues.php
index 7c388fc..b149cad 100644
--- a/buildmaster/mysql-issues.php
+++ b/buildmaster/mysql-issues.php
@@ -53,7 +53,12 @@ require_once BASE . "/lib/mysql.php";
" AND `subst_bp`.`architecture`=`binary_packages`.`architecture`" .
" WHERE NOT EXISTS (" .
"SELECT 1 FROM `install_target_providers`" .
- " WHERE `install_target_providers`.`install_target` = `dependencies`.`depending_on`" .
+ " JOIN `binary_packages_in_repositories` AS `i_bpir` ON `i_bpir`.`package`=`install_target_providers`.`package`" .
+ " JOIN `repositories` AS `i_r` ON `i_bpir`.`repository`=`i_r`.`id`" .
+ " JOIN `architecture_compatibilities` ON `architecture_compatibilities`.`fully_compatible`" .
+ " AND `architecture_compatibilities`.`built_for`=`i_r`.`architecture`" .
+ " WHERE `install_target_providers`.`install_target`=`dependencies`.`depending_on`" .
+ " AND `repositories`.`architecture`=`architecture_compatibilities`.`runs_on`" .
")" .
$ignore .
" ORDER BY " .