we have a self-hosted canvas lms(stable/2023-08-30)，and install analytics(https://github.com/instructure/analytics) with cassandra, I can visit course analytics, but when I click people's name of some course, I get a error message: ERROR: column "custom_grade_status_id" does not exist
Steps to reproduce:
1.login canvas
2.visit course
3.click some user's name
PG::UndefinedColumn (ERROR: column "custom_grade_status_id" does not exist
LINE 1: ...workflow_state", "submissions"."cached_due_date", "custom_gr...
^):
Additional notes:
canvas lms execute following sql normally:
SQL (1.0ms) SELECT "submissions"."id", "submissions"."assignment_id", "submissions"."score", "submissions"."user_id", "submissions"."submission_type", "submissions"."submitted_at", "submissions"."grade", "submissions"."graded_at", "submissions"."grader_id", "submissions"."updated_at", "submissions"."workflow_state", "submissions"."cached_duedate", **"submissions"."custom_grade_statusid",** "submissions"."excused", "submissions"."late_policy_status", "submissions"."cached_quiz_lti", "submissions"."posted_at", "submissions"."seconds_late_override" FROM "public"."submissions" WHERE (submissions.workflow_state <> 'deleted') AND 1=0 AND "submissions"."user_id" = 2 [production:1 primary]
But the column named custom_grade_status_id does not exit.
I added the column to table submissions, everything is normal now.
Did I have the wrong installation steps or did I miss something， or it is a bug.
Summary:
we have a self-hosted canvas lms(stable/2023-08-30)，and install analytics(https://github.com/instructure/analytics) with cassandra, I can visit course analytics, but when I click people's name of some course, I get a error message: ERROR: column "custom_grade_status_id" does not exist
Steps to reproduce:
1.login canvas 2.visit course 3.click some user's name
Expected behavior:
post https://domain//api/graphql, and show me this user's information
Actual behavior:
PG::UndefinedColumn (ERROR: column "custom_grade_status_id" does not exist LINE 1: ...workflow_state", "submissions"."cached_due_date", "custom_gr... ^):
Additional notes:
canvas lms execute following sql normally: SQL (1.0ms) SELECT "submissions"."id", "submissions"."assignment_id", "submissions"."score", "submissions"."user_id", "submissions"."submission_type", "submissions"."submitted_at", "submissions"."grade", "submissions"."graded_at", "submissions"."grader_id", "submissions"."updated_at", "submissions"."workflow_state", "submissions"."cached_duedate", **"submissions"."custom_grade_statusid",** "submissions"."excused", "submissions"."late_policy_status", "submissions"."cached_quiz_lti", "submissions"."posted_at", "submissions"."seconds_late_override" FROM "public"."submissions" WHERE (submissions.workflow_state <> 'deleted') AND 1=0 AND "submissions"."user_id" = 2 [production:1 primary]
But the column named custom_grade_status_id does not exit. I added the column to table submissions, everything is normal now. Did I have the wrong installation steps or did I miss something， or it is a bug.