SQL error browsing dashboards

obfuscurity / descartes

Introspective dashboard for Graphite

MIT License

502 stars 65 forks source link

SQL error browsing dashboards #108

Closed wittwerch closed 11 years ago

wittwerch commented 11 years ago

I'm currently using descartes with Ruby 2.0.0p0 and Postgres 9.0.7 on Debian. When I try to browse a dashboard, I get the following error.

11:09:27 web.1  | Sequel::DatabaseError - PG::Error: ERROR:  column "dashboards.uuid" must appear in the GROUP BY clause or be used in an aggregate function
11:09:27 web.1  | LINE 1: SELECT dashboards.*, COUNT(graph_dashboard_relations.*) AS g...
11:09:27 web.1  |                ^
11:09:27 web.1  | :

obfuscurity commented 11 years ago

The README mistakenly listed the PostgreSQL dependency as "9.x" when it really should've said "9.1" since we rely on 9.1's more forgiving GROUP BY. I'm taking a look at this today to see if I can fix the query to be compatible with 8.4 and 9.0.