SQL Error after upgrade 4.0-beta2 > 5.0-alpha10

Created on 30 July 2015, about 9 years ago
Updated 10 August 2024, 29 days ago

Hello,

I have upgraded the Quiz module from version 4.0-beta2 to 5.0-alpha10. When i visit ../admin/quiz/reports/score-long-answer i get an error.

In my dblog it is saying the column `result_id` doesn't exists.

PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'a.result_id' in 'field list': SELECT a.result_id AS result_id, a.question_nid AS question_nid, a.question_vid AS question_vid, a.answer_feedback AS answer_feedback, a.answer_feedback_format AS answer_feedback_format, r.title AS title, qnr.time_end AS time_end, qnr.time_start AS time_start, qnr.uid AS uid FROM {quiz_long_answer_user_answers} a INNER JOIN {node_revision} r ON a.question_vid = r.vid INNER JOIN {quiz_node_results} qnr ON a.result_id = qnr.result_id INNER JOIN {node} n ON qnr.nid = n.nid WHERE (a.is_evaluated = :db_condition_placeholder_0) AND( (n.uid = :db_condition_placeholder_1) OR (qnr.uid = :db_condition_placeholder_2) ); Array ( [:db_condition_placeholder_0] => 0 [:db_condition_placeholder_1] => 1 [:db_condition_placeholder_2] => 1 ) in LongAnswerResponse::fetchAllUnscoredAnswers() (line 219 of C:\sites\psp\sites\all\modules\contrib\quiz\question_types\long_answer\long_answer.classes.inc).

Can someone please help me out, because this error is on a live site.

πŸ› Bug report
Status

Fixed

Version

5.0

Component

Code - Quiz core

Created by

Live updates comments and jobs are added and updated live.
  • Needs tests

    The change is currently missing an automated test that fails when run with the original code, and succeeds when the bug has been fixed.

Sign in to follow issues

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

Production build 0.71.5 2024