diff options
| -rw-r--r-- | buildmaster/mysql-issues.php | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/buildmaster/mysql-issues.php b/buildmaster/mysql-issues.php index 16dd986..0604167 100644 --- a/buildmaster/mysql-issues.php +++ b/buildmaster/mysql-issues.php @@ -9,6 +9,7 @@ require_once BASE . "/lib/mysql.php"; $result = mysql_run_query( "SELECT CONCAT(" . + "`r_a`.`name`,\"/\"," . "`repositories`.`name`,\"/\"," . "`binary_packages`.`pkgname`,\"-\"," . "IF(`binary_packages`.`epoch`=0,\"\",CONCAT(`binary_packages`.`epoch`,\":\"))," . @@ -24,6 +25,7 @@ require_once BASE . "/lib/mysql.php"; " JOIN `binary_packages_in_repositories` ON `binary_packages`.`id`=`binary_packages_in_repositories`.`package`" . " JOIN `repositories` ON `binary_packages_in_repositories`.`repository`=`repositories`.`id`" . " AND `repositories`.`is_on_master_mirror`" . + " JOIN `architectures` AS `r_a` ON `repositories`.`architecture`=`r_a`.`id`" . " JOIN `dependencies` ON `dependencies`.`dependent`=`binary_packages`.`id`" . " JOIN `dependency_types` ON `dependencies`.`dependency_type`=`dependency_types`.`id`" . " AND `dependency_types`.`relevant_for_binary_packages`" . @@ -60,6 +62,7 @@ require_once BASE . "/lib/mysql.php"; $result = mysql_run_query( "SELECT CONCAT(" . + "`r_a`.`name`,\"/\"," . "`repositories`.`name`,\"/\"," . "`binary_packages`.`pkgname`,\"-\"," . "IF(`binary_packages`.`epoch`=0,\"\",CONCAT(`binary_packages`.`epoch`,\":\"))," . @@ -74,6 +77,7 @@ require_once BASE . "/lib/mysql.php"; " JOIN `binary_packages_in_repositories` ON `binary_packages`.`id`=`binary_packages_in_repositories`.`package`" . " JOIN `repositories` ON `binary_packages_in_repositories`.`repository`=`repositories`.`id`" . " AND `repositories`.`is_on_master_mirror`" . + " JOIN `architectures` AS `r_a` ON `repositories`.`architecture`=`r_a`.`id`" . " JOIN `repository_stabilities` ON `repositories`.`stability`=`repository_stabilities`.`id`" . " JOIN `dependencies` ON `dependencies`.`dependent`=`binary_packages`.`id`" . " JOIN `dependency_types` ON `dependencies`.`dependency_type`=`dependency_types`.`id`" . |