I think the change proposed by René should resolve this issue; that is
change line 62 of students/assessments/index.php from
WHERE (module_id = {$_module_id}) AND (assessment_id IN
{$assessment_clause})
to
WHERE (assessment_id IN {$assessment_clause})
If not, it is certainly part of the solution.
Stephen
On 12/11/2012 10:54, Voce, Julie K wrote:
> Hi René,
>
> Did you manage to fix this issue? We too seem to be experiencing the issue where students are being told 'DID NOT SUBMIT' but they have indeed submitted.
>
> Best wishes,
> Julie
>
> -----Original Message-----
> From: WebPA [mailto:[log in to unmask]] On Behalf Of René Haentjens
> Sent: 05 September 2012 12:28
> To: [log in to unmask]
> Subject: Re: Submitted / Not submitted confusion (WebPA_2.0.0.9beta)
>
> I think I found something...
>
> In students/assessments/index.php, lines 59-65, one can read:
> $assessments_with_response = $DB->fetch_col($rsql = "
> SELECT DISTINCT assessment_id
> FROM " . APP__DB_TABLE_PREFIX . "user_mark
> WHERE (module_id = {$_module_id}) AND (assessment_id IN
> {$assessment_clause})
> AND (user_id = {$_user->id})
> ORDER BY assessment_id
> ");
>
> The table user_mark does not have a column 'module_id'...
>
> Shall I submit this to sourceforge.bugtracker?
>
> René.
>
> ----- Original Message -----
> From: "René Haentjens" <[log in to unmask]>
> To: "WebPA" <[log in to unmask]>
> Sent: Wednesday, September 05, 2012 11:12 AM
> Subject: Submitted / Not submitted confusion (WebPA_2.0.0.9beta)
>
>
>> I've rearranged 3 pieces of earlier mails in chronological order:
>>
>>> Rene: ...
>>> One of us (Fanny) noticed in a recent test that students had "DID NOT
>>> SUBMIT" although they filled the form and submitted their marks. I
>>> checked the database tables and the data seems to be there all right.
>>> Earlier tests by Fanny seemed correct...
>>
>>> Stephen: ...
>>> 2. The "DID NOT SUBMIT" issue sounds like a bug but would require more
>>> details to trace - I have not encountered it myself. Is the system still
>>> mis-reporting this, or could it possibly be related to timezone issues
>>> (this has happened in other areas)?...
>>
>>> Rene: ...
>>> There was indeed a timezone-issue, I changed the config from
>>> 'Europe/London' to 'Europe/Brussels' while an assessment was open.
>>
>> I've now created a new test assessment; two groups, one student of the
>> first
>> group submitted data immediately after the assessment was opened.
>>
>> As tutor the responded list looks OK, regardless of whether the assessment
>> is open or already closed.
>>
>> When logging in as the student who submitted data:
>> - when the assessment is still open, there is a button "Take Assessment",
>> but when clicking it, there is a message "you have already submitted";
>> - when the assessment has been closed, the assessment is listed with "DID
>> NOT SUBMIT".
>>
>> A day later, one student of the second group submits data.
>>
>> Same story, the day later does not seem to solve anything.
>>
>> It looks as if, when the list of the user's assessments is composed,
>> submitted or not submitted gets confused (because the timezone is not
>> London? sounds bizarre...)
>>
>> I'll look into the code...
>>
>> René.
>>
|