Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-37555

Show poll questions might be out of sync

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: RESOLVED
    • Priority: Critical
    • Resolution: Won't Fix
    • Affects Version/s: 11.5 [Tentative]
    • Fix Version/s: None
    • Component/s: Lessons
    • Labels:
      None
    • 11 status:
      Please Merge
    • Previous Issue Keys:
      LSNBLDR-846

      Description

      While working on LSNBLDR-840, I noticed that it's possible for the show poll answer counts (in the graph) to quite possibly get out of sync if the row isn't created (when the question is initially created) and answers come in. I don't see anything obvious that re-counts up the correct answers. I have a conversion script that I attached to the ticket that should re-calculate but maybe there's something better.

      (NOTE: This doesn't work, this seems to not catch all the data, need something better, I wouldn't run this)

      DELETE FROM lesson_builder_qr_totals;
      INSERT INTO lesson_builder_qr_totals (questionId,responseId,respcount) select questionId, multipleChoiceId, sum(correct) from lesson_builder_q_responses group by questionId, multipleChoiceId;
      

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  jonespm Matthew Jones
                  Reporter:
                  jonespm Matthew Jones
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  5 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Git Source Code