I am having difficulty creating a quiz in 1.9 using different types of questions. Here is the script with the issues involved:
ost connection to MySQL server during query
SELECT *, (SELECT count(1) FROM mdl_question q WHERE c.id = q.category AND q.hidden='0' AND q.parent='0') as questioncount FROM mdl_question_categories as c WHERE c.contextid IN (69, 57, 3, 1) ORDER BY parent, sortorder, name ASC
line 684 of lib/dmllib.php: call to debugging()
line 934 of lib/dmllib.php: call to get_recordset_sql()
line 1736 of lib/questionlib.php: call to get_records_sql()
line 1750 of lib/questionlib.php: call to get_categories_for_contexts()
line 1712 of lib/questionlib.php: call to question_category_options()
line 431 of question/editlib.php: call to question_category_select_menu()
line 623 of question/editlib.php: call to question_list()
line 362 of mod/quiz/edit.php: call to question_showbank()
Warning: Invalid argument supplied for foreach() in /home/content/f/l/o/floriantp/html/lib/questionlib.php on line 1788
MySQL server has gone away
SELECT * FROM mdl_course_modules WHERE id = '10'
line 684 of lib/dmllib.php: call to debugging()
line 481 of lib/dmllib.php: call to get_recordset_sql()
line 421 of lib/dmllib.php: call to get_record_sql()
line 3362 of lib/accesslib.php: call to get_record()
line 1762 of lib/questionlib.php: call to print_context_name()
line 1712 of lib/questionlib.php: call to question_category_options()
line 431 of question/editlib.php: call to question_category_select_menu()
line 623 of question/editlib.php: call to question_list()
line 362 of mod/quiz/edit.php: call to question_showbank()
MySQL server has gone away
SELECT * FROM mdl_course WHERE id = '6'
line 684 of lib/dmllib.php: call to debugging()
line 481 of lib/dmllib.php: call to get_recordset_sql()
line 421 of lib/dmllib.php: call to get_record_sql()
line 3336 of lib/accesslib.php: call to get_record()
line 1762 of lib/questionlib.php: call to print_context_name()
line 1712 of lib/questionlib.php: call to question_category_options()
line 431 of question/editlib.php: call to question_category_select_menu()
line 623 of question/editlib.php: call to question_list()
line 362 of mod/quiz/edit.php: call to question_showbank()
MySQL server has gone away
SELECT * FROM mdl_course_categories WHERE id = '1'
line 684 of lib/dmllib.php: call to debugging()
line 481 of lib/dmllib.php: call to get_recordset_sql()
line 421 of lib/dmllib.php: call to get_record_sql()
line 3327 of lib/accesslib.php: call to get_record()
line 1762 of lib/questionlib.php: call to print_context_name()
line 1712 of lib/questionlib.php: call to question_category_options()
line 431 of question/editlib.php: call to question_category_select_menu()
line 623 of question/editlib.php: call to question_list()
line 362 of mod/quiz/edit.php: call to question_showbank()
Is this correct place to post this? I have used Tony GM's modifications for CBM scoring. I can reload the web page and it eventually works, however it takes 60 to 90 seconds to load or crash.
From the error messages, it looks like the problem is with your database server. Is it crashing? What sort of load is it under?
This test site for 1.9 is the only thing I am running on my shared server. I also used 1.8.2 on the same server and did not have the issue. It only happens when I am working with or taking a quiz. I have no traffic on the site at this time as my students are on break for a week.
I also recieve th following error when I submit a multichoice question:
Notice: Undefined property: feedback in /home/content/f/l/o/floriantp/html/question/type/multichoice/questiontype.php on line 352
-Tim
Notice: Undefined property: feedback in /home/content/f/l/o/floriantp/html/question/type/multichoice/questiontype.php on line 352
-Tim
You are not running the latest 1.9 beta2+ code, so I can't track down this error. There is no reference to a property called feedback anywhere near that line.
The other notice you posted about was close enough to the line you gave that I could find and fix it.
About your main error. Google finds this: http://dev.mysql.com/doc/refman/5.0/en/gone-away.html. Error messages are often good things to google for - enclose them in double quotes: http://www.google.com/search?q=%22MySQL+server+has+gone+away%22
The other notice you posted about was close enough to the line you gave that I could find and fix it.
About your main error. Google finds this: http://dev.mysql.com/doc/refman/5.0/en/gone-away.html. Error messages are often good things to google for - enclose them in double quotes: http://www.google.com/search?q=%22MySQL+server+has+gone+away%22
Tim I found the information on the load when submitting a quiz:
27.942695 secs
Included 66 files
Load average: 2.38
Record cache hit/miss ratio : 0/0
Additionally, I receive the following error when submitting the quiz:
Notice: Undefined property: passwordcheckedquizzes in /home/content/f/l/o/floriantp/html/mod/quiz/attempt.php on line 396
Although I an not an expert on php or mysql I do understand enough make modifications if I have some instruction/direction.
Thanks for the help.
-Tim
Notices are the least sever sort of error or warning that PHP produces. On the one hand, they can normally be safely ignored. On the other hand, code that causes them is sloppy, and ought to be cleaned up. Thank you for reportin these.
However, they will not be the cause of the more serious error you are seeing, which I don't understand at all, I am afraid.
However, they will not be the cause of the more serious error you are seeing, which I don't understand at all, I am afraid.
Can you point me in a direction that might be of help?
I'm not really sure, I'm afraid. People in the General Problems forum may have seen something like this before?
Any information on the questiontype.php line 352 error? I get this when I use CBM in a quiz or not.
-Tim
-Tim
Well, I found out about this problem late last night when I checked the forums after getting back from an orchestra rehearsal, and since then I have been in bed asleep. So, no news. I don't think that is unreasonable, is it?
I understand that we sit in different time zones. I, like you just happened to check the forum late last night. I do apperciate your work on the quiz module and any help you can offer.
You mentioned you were able to track down the fix for an error. What it this one?
property: passwordcheckedquizzes in /home/content/f/l/o/floriantp/html/mod/quiz/attempt.php on line 396
If not can you help me track down this error?
-Tim
That is the one I fixed. If you upgrade to the latest Moodle 1.9 beta2+ you will get the fix.