Closed (fixed)
Project:
Quiz
Version:
5.x-1.x-dev
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
27 Jul 2007 at 05:47 UTC
Updated:
20 Aug 2007 at 23:18 UTC
Jump to comment: Most recent file
1) Although no errors were reported after I enabled quiz module, when I created my first quiz i got:
Table 'db18358_drupal47.quiz' doesn't exist query: quiz_insert INSERT INTO quiz (nid, number_of_questions, shuffle, quiz_open, quiz_close, takes, pass_rate, summary_pass, summary_default, quiz_always) VALUES(13023, 5, 1, 1185433200, 1188025200, 0, 75, 'Congratulations! You passed!', '', 1) in /home/18358/domains/lifetwo.com/html/production/includes/database.mysql.inc on line 172.
... and sure enough, using PHPMyAdmin, there is no quiz table or any of the others. I was able to create them manually using the text inside quiz.install.
Per Status Report, we're running Drupal 5.1, MySQL 4.1.11, PHP 5.2.2
2) After enabling quiz and multichoice, my administer/user/access page was a blank sheet of white. Disabling the modules returns it to normal. I raised php_value memory_limit from 20M to 24M, and now it's OK, but still ...
3) When I went to take a two question test quiz, I got
The quiz is not currently available
user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-2' at line 1 query: quiz_build_question_list SELECT question_nid FROM quiz_questions WHERE quiz_nid = 13023 AND question_status = 0 ORDER BY RAND() LIMIT 0, -2 in /home/18358/domains/lifetwo.com/html/production/includes/database.mysql.inc on line 172.(FWIW, both the quiz and questions were unpublished, since I was mucking w/ this on a live site)
However, it does look like I was able to successfully take the quiz.
| Comment | File | Size | Author |
|---|---|---|---|
| #2 | quiz_build_question_list.patch | 1.22 KB | kscheirer |
Comments
Comment #1
greg_y commentedissue #3 above disappeared after I created a second new quiz. I think the issue was caused by the lack of any record in quiz table; that was because when I first went to create a new quiz, there WAS no quiz table (see #1 above).
(This was confusing b/c I could edit the nonexistent quiz, 'submit' would seem to work, but the changes wouldn't take ... not surprising since there was no record to store them in).
Comment #2
kscheirerThe first problem seems to be an issue of the install file with mysql 4 perhaps? I've never run into any trouble installing the module under mysql 5, so thats my best guess.
the second one is pretty typical of a drupal site, and not really specific to the quiz module.
The requirements suggest 20-24MB as the PHP memory limit.
I'm not sure how the third issue came about, since you shouldn't be able to have a 2 question quiz who number_of _questions is 0,
but it did, so a sanity check would help out. Like you mentioned, its probably related to having trouble creating the tables earlier.
Theres another issue in the queue that deals with restricting access to unpublished quizzes.
The provided patch adds a sanity check, and would prevent the second listed sql error.
Comment #3
kscheirersupplied patch committed to 5.x-1.x-dev
Comment #4
(not verified) commented