Quiz wrongly marked open
Brought to you by:
neosurya
If a quiz is not evaluated, it is marked as "Open" in the table savsoft_result under the column "savsoft_result". If the student attempts the quiz once again, he is shown a message saying
You have a pending quiz to submit!
System redirecting to resume that quiz...
The quiz is then started again. Sometimes, thje quiz does not start, saying that the user has no time to complete the test.
Solution will be to mark a quiz as "pending evaluation"
To allow this to not show the error message, we have temporarily enabled openquiz, by changing the flag in config.php
// Allow open quiz( true or false )
$config['open_quiz']=true;
There are two errors appearing in the insertion of query:
Query error: Unknown column 'indTim0' in 'field list' - Invalid query: INSERT INTO
savsoft_answers
(rid
,qid
,u id
,q_option
,score_u
,indTim
,indTim0
,indTim1
,evaluated
,selectedWords
,selectedOptions
) VALUES ('43', '122', '1', 'saadadddas', 0, '3', '14,1,7', '4', '0', 'The,monsoon,', '[\"dog\",\"4\"]')
This is in line no 1099 of Quiz_model.php
This was causing the paragraph question results to not get recorded.
I can't access phpmyadmin remotely, is it possible the savsoft_answers doesn't contain " 'indTim0" column?
There are two errors appearing in the insertion of query:
Error 1: (Stapin, you need to check this)
Query error: Unknown column 'indTim0' in 'field list' - Invalid query: INSERT INTO
savsoft_answers
(rid
,qid
,u id
,q_option
,score_u
,indTim
,indTim0
,indTim1
,evaluated
,selectedWords
,selectedOptions
) VALUES ('43', '122', '1', 'saadadddas', 0, '3', '14,1,7', '4', '0', 'The,monsoon,', '[\"dog\",\"4\"]')
This is in line no 1099 of Quiz_model.php
This was causing the paragraph question results to not get recorded.
Error 2:
There is also an error in line no 794 of Quiz_model.php.
$userdata['result_status']=$qr;
However, $qr is not set.
Last edit: Suryaprakash 2019-08-02
I just saw the issue was resolved, i saw this comment "What is the purpose of indTim0 and indTim1? " in the quiz model, after analysing the quiz_attempt_default.php while performing a quiz, indTim0 was how many seconds i spent while trying to find each word ex "goat" in the given text in my case they were 3 words, and indTim1 was how many seconds i spent on the following questions about the text after clicking next
In the savsoft_answers table, the columns infTim0 and indTim1 are not present. Do you know how it got changed?
No i don't know how it happened, Maybe they weren't added during
installation.
On Sat, Aug 3, 2019, 3:21 AM Suryaprakash, neosurya@users.sourceforge.net
wrote:
Related
Tickets: #4