added other category

git-svn-id: svn://svn.r-forge.r-project.org/svnroot/cran2deb@268 edb9625f-4e0d-4859-8d74-9fd3b1da38cb

diff --git a/trunk/exec/diagnose b/trunk/exec/diagnose
index cd1e89693eb9f6985c6727581246d117db0d734b..b69692990168b74fdebd9977b019d51f9442daa8 100755 (executable)
--- a/trunk/exec/diagnose
+++ b/trunk/exec/diagnose
@@ -2,7 +2,8 @@
 last='natural join (select system,package,max(id) as id from builds where package not in (select package from blacklist_packages) group by package,system)'
 
 echo blacklist:
-sqlite3 -header -column /var/cache/cran2deb/cran2deb.db "select count(*) as total_blacklist,sum(nonfree) as num_nonfree, sum(obsolete) as num_obsolete, sum(broken_dependency) as num_broke_depend, sum(unsatisfied_dependency) as num_unsat_depend, sum(breaks_cran2deb) as num_break_cran2deb from blacklist_packages;"
+#sqlite3 -header -column /var/cache/cran2deb/cran2deb.db "select count(*) as total_blacklist,sum(nonfree) as num_nonfree, sum(obsolete) as num_obsolete, sum(broken_dependency) as num_broke_depend, sum(unsatisfied_dependency) as num_unsat_depend, sum(breaks_cran2deb) as num_break_cran2deb, sum(other) as num_other from blacklist_packages;"
+sqlite3 -header -column /var/cache/cran2deb/cran2deb.db "select count(*) as total,sum(nonfree) as nonfree, sum(obsolete) as obsolete, sum(broken_dependency) as broke_depend, sum(unsatisfied_dependency) as unsat_depend, sum(breaks_cran2deb) as break_cran2deb, sum(other) as other from blacklist_packages;"
 
 echo bad licenses:
 sqlite3 /var/cache/cran2deb/cran2deb.db "select system,count(package),group_concat(package) from builds $last where success = 0 and log like '%No acceptable license:%' group by system;"