canvas-lms icon indicating copy to clipboard operation
canvas-lms copied to clipboard

ERROR: column "custom_grade_status_id" does not exist

Open kenxt opened this issue 2 years ago • 0 comments

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_due_date", "submissions"."custom_grade_status_id", "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.

kenxt avatar Oct 29 '23 02:10 kenxt