Hello! I have a problem with upgrade to 1.0.3.
After upgrade my dashboarding, queries, visualization… doesn’t work.
When I get there are pages in browser I have a 500 errors. In api_error.log and celery_errors.log clear.
I found errors only in postgresql log:

redash@redash ERROR: column queries_1.version does not exist at character 566
2017-06-27 21:27:26.126 CEST [1375] redash@redash STATEMENT: SELECT visualizations.updated_at AS visualizations_updated_at, visualizations.created_at AS visualizations_created_at, visualizations.id AS visualizations_id, visualizations.type AS visualizations_type, visualizations.query_id AS visualizations_query_id, visualizations.name AS visualizations_name, visualizations.description AS visualizations_description, visualizations.options AS visualizations_options, queries_1.query AS queries_1_query, queries_1.updated_at AS queries_1_updated_at, queries_1.created_at AS queries_1_created_at, queries_1.id AS queries_1_id, queries_1.version AS queries_1_version, queries_1.org_id AS queries_1_org_id, queries_1.data_source_id AS queries_1_data_source_id, queries_1.latest_query_data_id AS queries_1_latest_query_data_id, queries_1.name AS queries_1_name, queries_1.description AS queries_1_description, queries_1.query_hash AS queries_1_query_hash, queries_1.api_key AS queries_1_api_key, queries_1.user_id AS queries_1_user_id, queries_1.last_modified_by_id AS queries_1_last_modified_by_id, queries_1.is_archived AS queries_1_is_archived, queries_1.is_draft AS queries_1_is_draft, queries_1.schedule AS queries_1_schedule, queries_1.schedule_failures AS queries_1_schedule_failures, queries_1.options AS queries_1_options
FROM visualizations LEFT OUTER JOIN queries AS queries_1 ON queries_1.id = visualizations.query_id
LIMIT 20
2017-06-27 21:27:45.737 CEST [1314] redash@redash ERROR: column queries.version does not exist at character 150
2017-06-27 21:27:45.737 CEST [1314] redash@redash STATEMENT: SELECT queries.query AS queries_query, queries.updated_at AS queries_updated_at, queries.created_at AS queries_created_at, queries.id AS queries_id, queries.version AS queries_version, queries.org_id AS queries_org_id, queries.data_source_id AS queries_data_source_id, queries.latest_query_data_id AS queries_latest_query_data_id, queries.name AS queries_name, queries.description AS queries_description, queries.query_hash AS queries_query_hash, queries.api_key AS queries_api_key, queries.user_id AS queries_user_id, queries.last_modified_by_id AS queries_last_modified_by_id, queries.is_archived AS queries_is_archived, queries.is_draft AS queries_is_draft, queries.schedule AS queries_schedule, queries.schedule_failures AS queries_schedule_failures, queries.options AS queries_options, query_results_1.id AS query_results_1_id, query_results_1.retrieved_at AS query_results_1_retrieved_at
FROM queries LEFT OUTER JOIN query_results AS query_results_1 ON query_results_1.id = queries.latest_query_data_id
WHERE queries.schedule IS NOT NULL ORDER BY queries.id

Please help me with this problems.
Thanks!

1 Like