Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
I want to create a report that shows the questions that are most frequently answered incorrectly.
I tried adding the field Quiz Results by Question: Is Correct
but it generates an error.
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'quiz_node_results.result_id' in 'on clause'
Any one have any idea how I would get these statistics?
Comments
Comment #1
jlongbottom CreditAttribution: jlongbottom commentedI went ahead and just made a module to do it. Judging by the issue queue, my question was not going to get answered soon or ever.
Anyways, here is the query to do it in case anyone in the future is reading this:
Comment #2
JCL324I'm having the same issue with 4.0-beta1 and was apparently somewhat fixed in https://drupal.org/node/1459358 but not for this (our) case. I need the same type of report, mind sharing how you did it in your module? Did you still use a View but just do a hook_query_alter in the module? If not, how did you display the output of the query?
Also, I added a HAVING count(*) > 2 to limit the results instead of the LIMIT to show all questions that had more than 1 wrong answer.
Comment #2.0
JCL324moved error message into CODE tag
Comment #3
djdevinThis issue is being closed because it was filed against a version that is no longer supported. If the issue still persists in the latest version of Quiz, please open a new issue.