This repository was archived by the owner on Oct 5, 2021. It is now read-only.
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
Description
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'
Metadata
Metadata
Assignees
Labels
No labels