You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
This repository has been archived by the owner on Jul 24, 2021. It is now read-only.
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
The text was updated successfully, but these errors were encountered:
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
The text was updated successfully, but these errors were encountered: