Hi guys,

I've had an error come up, and hope that maybe you'll be able to run through it with me. I've got a quiz that has a textbox with no right or wrong answer in it, so a quiz admin/manager has to go through and 'mark' the question as being right or wrong. When I do this, I submit the form and get an error.

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table '[REMOVED].quiz_node_results_answers' doesn't exist: SELECT SUM(points_awarded) FROM (quiz_node_results_answers) WHERE result_id = :result_id; Array ( [:result_id] => 13 ) in quiz_get_score_array() (line 232 of /home/[REMOVED]/public_html/[REMOVED]/sites/all/modules/quiz/quiz.pages.inc).

I looked over the DB and the table is there. My only route of thinking is that there may be an issue with the fact I have table prefixes set up in case Drupal may need to share this DB later on with anything else. Can I push for the maintainers here to take table prefixes in to account so that this can be fixed for people using them?

Thanks guys,
Kris

Comments

rougekris’s picture

rougekris CreditAttribution: rougekris commented

Update. I've successfully removed the table prefixes and believe the site is robust now without them. However, when I save the page in the same place, I don't get an error output to the screen but I get a WSOD instead. It writes to the database for sure now, but I'm not sent back to the quiz when 'marking' an answer.

Any ideas?

djdevin’s picture

djdevin
Location Philadelphia
CreditAttribution: djdevin as a volunteer and at Cadmium commented
Issue summary: View changes
Status: Active » Closed (outdated)

This 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.