Skip to content
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
@dollschasingmen

Description

@dollschasingmen

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

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions