Skip to content
This repository was archived by the owner on Oct 5, 2021. It is now read-only.

Running results doesn't work in the demo #73

Open
dollschasingmen opened this issue Sep 13, 2017 · 0 comments
Open

Running results doesn't work in the demo #73

dollschasingmen opened this issue Sep 13, 2017 · 0 comments

Comments

@dollschasingmen
Copy link
Contributor

this is is because we are using SQLite3 in the demo:


Show analytics for
Live StatsLive LogsVolumes
2017-09-13 16:34:15 aleph-playground aleph-playground aleph 23:34:12 web.1    | ActiveRecord::StatementInvalid (SQLite3::SQLException: near "FROM": syntax error:       SELECT
2017-09-13 16:34:15 aleph-playground aleph-playground aleph 23:34:12 web.1    |         title query_title,
2017-09-13 16:34:15 aleph-playground aleph-playground aleph 23:34:12 web.1    |         compiled_body query_body,
2017-09-13 16:34:15 aleph-playground aleph-playground aleph 23:34:12 web.1    |         TO_CHAR(results.started_at, 'YYYY-MM-DD HH24:MI:SS') started_at,
2017-09-13 16:34:15 aleph-playground aleph-playground aleph 23:34:12 web.1    |         ROUND(EXTRACT(EPOCH FROM (now() - results.started_at)::INTERVAL)) duration_seconds,
2017-09-13 16:34:15 aleph-playground aleph-playground aleph 23:34:12 web.1    |         users.name author,
2017-09-13 16:34:15 aleph-playground aleph-playground aleph 23:34:12 web.1    |         users.role author_role,
2017-09-13 16:34:15 aleph-playground aleph-playground aleph 23:34:12 web.1    |         queries.id query_id,
2017-09-13 16:34:15 aleph-playground aleph-playground aleph 23:34:12 web.1    |         query_versions.id AS query_version_id,
2017-09-13 16:34:15 aleph-playground aleph-playground aleph 23:34:12 web.1    |         version
2017-09-13 16:34:15 aleph-playground aleph-playground aleph 23:34:12 web.1    |       FROM results
2017-09-13 16:34:15 aleph-playground aleph-playground aleph 23:34:12 web.1    |         LEFT OUTER JOIN query_versions ON query_versions.id = results.query_version_id
2017-09-13 16:34:15 aleph-playground aleph-playground aleph 23:34:12 web.1    |         LEFT OUTER JOIN queries ON query_versions.query_id = queries.id
2017-09-13 16:34:15 aleph-playground aleph-playground aleph 23:34:12 web.1    |         INNER JOIN users ON results.owner_id = users.id
2017-09-13 16:34:15 aleph-playground aleph-playground aleph 23:34:12 web.1    |       WHERE results.status = 'running'
2017-09-13 16:34:15 aleph-playground aleph-playground aleph 23:34:12 web.1    | ):
2017-09-13 16:34:15 aleph-playground aleph-playground aleph 23:34:12 web.1    |   app/controllers/admin/running_results_controller.rb:28:in `block (2 levels) in index'

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant