page: after submitting a new question

Details: occurs on fresh install of quiz module HEAD on drupal 5.2.

This is a database schema error. There are a number of functions in multichoice which still refer to points in quiz_multichoice_answers table. I'm not sure if this is supposed to change to is_correct or not. But there is no points column in the quiz_multichoice_answers install schema in multichoice.install

I will leave this patch to you, because I'm guessing points changed to is_correct, but I'm not sure. An easy fix is to simply add the points column back into this table, but this is not necessarily the right way to do it.

Error message:
* user warning: Unknown column 'points' in 'field list' query: INSERT INTO quiz_multichoice_answers (answer_id, nid, vid, answer, feedback, points, result_option) VALUES (17, 14, 21, 'correct', '', 1, 0) in /home/westwest/public_html/dev/includes/database.mysql.inc on line 172.

CommentFileSizeAuthor
#1 points.patch2.43 KBwestwesterson

Comments

westwesterson’s picture

Status: Active » Reviewed & tested by the community
StatusFileSize
new2.43 KB

This patch changes points to is_correct in multichoice.module.

westwesterson’s picture

Priority: Normal » Critical

This patch should be applied to multichoice.module v 1.48, issue #177086 is still an issue after this patch, but this patch does not effect the other, and should be applied first.

westwesterson’s picture

Status: Reviewed & tested by the community » Closed (fixed)

  • Commit 7ae1a34 on 5.x-2.x, 6.x-2.x, 6.x-3.x, 6.x-4.x, 6.x-5.x, 6.x-6.x, 7.x-4.x, master, 7.x-5.x by kscheirer:
    issue #177350 by westwesterson This patch so far fixes issues: #177084 #...

  • Commit 7ae1a34 on 5.x-2.x, 6.x-2.x, 6.x-3.x, 6.x-4.x, 6.x-5.x, 6.x-6.x, 7.x-4.x, master, 7.x-5.x, quiz-pages by kscheirer:
    issue #177350 by westwesterson This patch so far fixes issues: #177084 #...

  • Commit 7ae1a34 on 5.x-2.x, 6.x-2.x, 6.x-3.x, 6.x-4.x, 6.x-5.x, 6.x-6.x, 7.x-4.x, master, 7.x-5.x, quiz-pages, 2269219 by kscheirer:
    issue #177350 by westwesterson This patch so far fixes issues: #177084 #...

  • Commit 7ae1a34 on 5.x-2.x, 6.x-2.x, 6.x-3.x, 6.x-4.x, 6.x-5.x, 6.x-6.x, 7.x-4.x, master, 7.x-5.x, 2269219 by kscheirer:
    issue #177350 by westwesterson This patch so far fixes issues: #177084 #...