Opened 10 years ago

Closed 10 years ago

#1748 closed defect (fixed)

Stats are broken

Reported by: phil@… Owned by: Tom Hughes
Priority: major Milestone:
Component: website Version:
Keywords: data_stats.html Cc:

Description

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

Change History (1)

comment:1 Changed 10 years ago by Shaun McDonald

Resolution: fixed
Status: newclosed
Note: See TracTickets for help on using tickets.