The opend bugs are ok, but the closed bug column is much to high.
Looking into the code stats/stats.py, the code for getting the closed bug nummer only looks at the date, not at the type field of the bug:
cursor.execute("""SELECT COUNT(*) as closedbugs FROM bugs WHERE last_changed < DATE_FORMAT(DATE_SUB(CURDATE(), INTERVAL """+"%d"%interval+""" MONTH), "%Y-%m-01") AND last_changed >= DATE_FORMAT(DATE_SUB(CURDATE(), INTERVAL """+"%d"%(interval+1)+""" MONTH), "%Y-%m-01");""")
The code I've used for my closed bug stats:
curs.execute("SELECT YEAR(last_changed)+MONTH(last_changed)/12,count(distinct id) FROM bugs WHERE type <> 0 GROUP BY YEAR(last_changed)+ MONTH(last_changed)/12;")
the stats at http://openstreetbugs.schokokeks.org/stats/ didn't match with my own stats at http://www.h-renrew.de/h/osm/osmchecks/09_osb_phaseout/.
The opend bugs are ok, but the closed bug column is much to high.
Looking into the code stats/stats.py, the code for getting the closed bug nummer only looks at the date, not at the type field of the bug:
The code I've used for my closed bug stats:
Regards Werner