Reporter: phil[at]barby.net
[Submitted to the original trac issue database at 11.41pm, Friday, 24th April 2009]

The stats at http://www.openstreetmap.org/stats/data_stats.html appear to be broken, in the "Top Users Editing over the past..." section the following error is displayed:

Exception: PGError: ERROR: column "count_all" does not exist LINE 1: ... - '1 DAY'::INTERVAL) GROUP BY user_id ORDER BY count_all ... ^ : SELECT COUNT(*) AS count_all, user_id AS user_id FROM (SELECT DISTINCT "nodes".id FROM "nodes" LEFT OUTER JOIN "changesets" ON "changesets".id = "nodes".changeset_id WHERE (timestamp > NOW() - '1 DAY'::INTERVAL) GROUP BY user_id ORDER BY count_all DESC ) count_all_subquery
/var/lib/gems/1.8/gems/activerecord-2.1.2/lib/active_record/connection_adapters/abstract_adapter.rb:147:in log' /var/lib/gems/1.8/gems/activerecord-2.1.2/lib/active_record/connection_adapters/postgresql_adapter.rb:484:in execute'
/var/lib/gems/1.8/gems/activerecord-2.1.2/lib/active_record/connection_adapters/postgresql_adapter.rb:929:in select_raw' /var/lib/gems/1.8/gems/activerecord-2.1.2/lib/active_record/connection_adapters/postgresql_adapter.rb:916:in select'
/var/lib/gems/1.8/gems/activerecord-2.1.2/lib/active_record/connection_adapters/abstract/database_statements.rb:7:in select_all_without_query_cache' /var/lib/gems/1.8/gems/activerecord-2.1.2/lib/active_record/connection_adapters/abstract/query_cache.rb:61:in select_all'
/var/lib/gems/1.8/gems/activerecord-2.1.2/lib/active_record/calculations.rb:237:in execute_grouped_calculation' /var/lib/gems/1.8/gems/activerecord-2.1.2/lib/active_record/calculations.rb:124:in calculate'
/var/lib/gems/1.8/gems/activerecord-2.1.2/lib/active_record/calculations.rb:122:in catch' /var/lib/gems/1.8/gems/activerecord-2.1.2/lib/active_record/calculations.rb:122:in calculate'
/var/lib/gems/1.8/gems/activerecord-2.1.2/lib/active_record/calculations.rb:48:in `count'
/home/rails/script/statistics:74