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