Start page
num_rows > 10000)
print " Found >10000 serious issues.
\n";
else
print " Found " . $result -> num_rows . " serious issues.
\n";
while ( $row = $result -> fetch_assoc() ) {
if ($row["is_to_be_deleted"]==1)
print " (marked as to-be-deleted) ";
else
print " ";
print $row["pkgfile"] . " depends on " . htmlspecialchars($row["install_target"]) . " which is not provided by any package";
if (isset($row["subst_repository"]))
print " - but can be replaced by the one in " . $row["subst_repository"];
elseif (isset($row["subst_buildlist"]))
print " - but is already rescheduled";
print ".
";
print "\n";
unset($row);
}
$result = mysql_run_query(
"SELECT CONCAT(" .
"`r_a`.`name`,\"/\"," .
"`repositories`.`name`,\"/\"," .
"`binary_packages`.`pkgname`,\"-\"," .
"IF(`binary_packages`.`epoch`=0,\"\",CONCAT(`binary_packages`.`epoch`,\":\"))," .
"`binary_packages`.`pkgver`,\"-\"," .
"`binary_packages`.`pkgrel`,\".\"," .
"`binary_packages`.`sub_pkgrel`,\"-\"," .
"`architectures`.`name`) AS `pkgfile`," .
"`install_targets`.`name` AS `install_target`," .
"`repository_stabilities`.`name` AS `stability`," .
"IF(`binary_packages_in_repositories`.`is_to_be_deleted`,1,0) AS `is_to_be_deleted`" .
" FROM `binary_packages`" .
mysql_join_binary_packages_binary_packages_in_repositories() .
mysql_join_binary_packages_in_repositories_repositories() .
" AND `repositories`.`is_on_master_mirror`" .
mysql_join_repositories_architectures('','r_a') .
mysql_join_repositories_repository_stabilities() .
mysql_join_binary_packages_dependencies() .
mysql_join_dependencies_dependency_types() .
" AND `dependency_types`.`relevant_for_binary_packages`" .
mysql_join_dependencies_install_targets() .
mysql_join_binary_packages_architectures() .
" WHERE EXISTS (" .
"SELECT 1 FROM `install_target_providers`" .
mysql_join_install_target_providers_binary_packages_in_repositories('','prov_bpir') .
mysql_join_binary_packages_in_repositories_repositories('prov_bpir','prov_r') .
" JOIN `architecture_compatibilities` ON `architecture_compatibilities`.`built_for`=`prov_r`.`architecture`" .
" AND `architecture_compatibilities`.`fully_compatible`" .
" WHERE `install_target_providers`.`install_target` = `dependencies`.`depending_on`" .
" AND `architecture_compatibilities`.`runs_on`=`repositories`.`architecture`" .
")" .
" AND NOT EXISTS (" .
"SELECT 1 FROM `install_target_providers`" .
mysql_join_install_target_providers_binary_packages('','prov_bp') .
mysql_join_binary_packages_binary_packages_in_repositories('prov_bp','prov_bpir') .
mysql_join_binary_packages_in_repositories_repositories('prov_bpir','prov_r') .
" JOIN `repository_stability_relations` ON `prov_r`.`stability`=`repository_stability_relations`.`more_stable`" .
" WHERE `install_target_providers`.`install_target` = `dependencies`.`depending_on`" .
" AND `repositories`.`stability`=`repository_stability_relations`.`less_stable`" .
" AND `repositories`.`architecture`=`prov_r`.`architecture`" .
" AND NOT EXISTS (" .
"SELECT 1 FROM `binary_packages` AS `sup_bp`" .
mysql_join_binary_packages_binary_packages_in_repositories('sup_bp','sup_bpir') .
mysql_join_binary_packages_in_repositories_repositories('sup_bpir','sup_r') .
" JOIN `repository_stability_relations` AS `sup_rra` ON `sup_r`.`stability`=`sup_rra`.`more_stable`" .
" JOIN `repository_stability_relations` AS `sup_rrb` ON `sup_r`.`stability`=`sup_rrb`.`less_stable`" .
" WHERE `sup_bp`.`pkgname` = `prov_bp`.`pkgname`" .
" AND `sup_bp`.`architecture` = `prov_bp`.`architecture`" .
" AND `sup_bp`.`id` != `prov_bp`.`id`" .
" AND `repositories`.`stability`=`sup_rra`.`less_stable`" .
" AND `prov_r`.`stability`=`sup_rrb`.`more_stable`" .
" AND `prov_r`.`architecture`=`sup_r`.`architecture`" .
")" .
")" .
$ignore .
" ORDER BY `binary_packages_in_repositories`.`is_to_be_deleted`,`binary_packages`.`pkgname`,`install_targets`.`name`" .
$limit
);
if ($result -> num_rows > 10000)
print " Found >10000 stability issues.
\n";
else
print " Found " . $result -> num_rows . " stability issues.
\n";
while ( $row = $result -> fetch_assoc() ) {
if ($row["is_to_be_deleted"]==1)
print " (marked as to-be-deleted) ";
else
print " ";
print $row["pkgfile"] . " depends on " . htmlspecialchars($row["install_target"]) . " which is not provided by any package installable from enabled " . $row["stability"] . " repositories.
";
print "\n";
unset($row);
}
ob_end_flush();
?>