<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 12 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
        {font-family:Wingdings;
        panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
        {font-family:"Cambria Math";
        panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
        {font-family:Calibri;
        panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
        {font-family:Tahoma;
        panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
        {font-family:Gigi;
        panose-1:4 4 5 4 6 16 7 2 13 2;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0cm;
        margin-bottom:.0001pt;
        font-size:12.0pt;
        font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
        {mso-style-priority:99;
        color:blue;
        text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
        {mso-style-priority:99;
        color:purple;
        text-decoration:underline;}
p
        {mso-style-priority:99;
        mso-margin-top-alt:auto;
        margin-right:0cm;
        mso-margin-bottom-alt:auto;
        margin-left:0cm;
        font-size:12.0pt;
        font-family:"Times New Roman","serif";}
span.EmailStyle19
        {mso-style-type:personal-reply;
        font-family:"Calibri","sans-serif";
        color:#1F497D;}
.MsoChpDefault
        {mso-style-type:export-only;}
@page WordSection1
        {size:612.0pt 792.0pt;
        margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
        {page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-AU" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;color:#1F497D">Thanks Phil...<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;color:#1F497D">Nothing much is making sense...but my very clever tech is helping and may have more success
</span><span style="font-size:11.0pt;font-family:Wingdings;color:#1F497D">J</span><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;color:#1F497D"><o:p></o:p></span></p>
<p class="MsoNormal"><a name="_MailEndCompose"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;color:#1F497D"><o:p>&nbsp;</o:p></span></a></p>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Tahoma&quot;,&quot;sans-serif&quot;">From:</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Tahoma&quot;,&quot;sans-serif&quot;"> moodle-bounces@edulists.com.au [mailto:moodle-bounces@edulists.com.au]
<b>On Behalf Of </b>Phil Brown<br>
<b>Sent:</b> Friday, 1 July 2011 2:08 PM<br>
<b>To:</b> The Moodle Users' in Schools Mailing List<br>
<b>Subject:</b> Re: [Moodle] moodle - Database Error message detail Help needed<o:p></o:p></span></p>
</div>
<p class="MsoNormal"><o:p>&nbsp;</o:p></p>
<p class="MsoNormal">Hi Suz,<o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p>&nbsp;</o:p></p>
</div>
<div>
<p class="MsoNormal">You can&nbsp;access&nbsp;the work (I presume students have uploaded to the assignment) by going to the files section of the class and going to moddata -&gt; assignment, then choose the id number of the assignment.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p>&nbsp;</o:p></p>
</div>
<div>
<p class="MsoNormal">Each file uploaded into Moodle has a URL eg <a href="http://myschool.vic.edu.au/file/php/333/moddata/assignment/1603/2520/filename.doc">
http://myschool.vic.edu.au/file/php/333/moddata/assignment/1603/2520/filename.doc</a><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p>&nbsp;</o:p></p>
</div>
<div>
<p class="MsoNormal">The moddata folder is found in the files section of each class. All assignments have numbers (in the eg above it's 1603) and students have numbers ( 2520, above) If you can work out the assignment number you can retrieve the student woks
 from that folder.&nbsp;<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p>&nbsp;</o:p></p>
</div>
<div>
<p class="MsoNormal">Good luck.&nbsp;<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p>&nbsp;</o:p></p>
</div>
<div>
<p class="MsoNormal">Phil Brown<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt">WellingtonSC<o:p></o:p></p>
<div>
<p class="MsoNormal">On Fri, Jul 1, 2011 at 10:39 AM, Arnott, Suzanne S &lt;<a href="mailto:arnott.suzanne.s@edumail.vic.gov.au">arnott.suzanne.s@edumail.vic.gov.au</a>&gt; wrote:<o:p></o:p></p>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="color:#1F497D">Hi guys...</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="color:#1F497D">I am having a problem with an assignment &#8211; when I go to view the submitted assignments I get the message &#8220;error reading from database&#8221; and my technician
 has had a look around and came up with the message below...</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="color:#1F497D">I am reading all the words, but they are making no sense...what do I need to do to fix it?</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="color:#1F497D">Cheers</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="color:#1F497D">Suz</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><a name="130e3234924b3413__MailEndCompose"><span style="color:#1F497D">&nbsp;</span></a><o:p></o:p></p>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span lang="EN-US" style="font-size:10.0pt">From:</span></b><span lang="EN-US" style="font-size:10.0pt"> Laursen, David W
<br>
<b>Sent:</b> Friday, 1 July 2011 10:05 AM<br>
<b>To:</b> Arnott, Suzanne S<br>
<b>Subject:</b> Re: moodle - Database Error message detail</span><o:p></o:p></p>
</div>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">&nbsp;<o:p></o:p></p>
<div>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;line-height:14.25pt">
<span style="font-size:10.5pt;color:black">Hi Suz,</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;line-height:14.25pt">
<span style="font-size:10.5pt;color:black">Post this around and see what you get!</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;line-height:14.25pt">
<span style="font-size:10.5pt;color:black">&nbsp;</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;line-height:14.25pt">
<span style="font-size:10.5pt;color:black">Dave.</span><o:p></o:p></p>
<p class="MsoNormal" align="right" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;text-align:right;line-height:14.25pt">
<span style="font-size:10.5pt;color:black">&nbsp;</span><o:p></o:p></p>
<p class="MsoNormal" align="right" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;text-align:right;line-height:14.25pt">
<span style="font-size:10.5pt;color:black"><a href="http://moodle.sandringhamsc.vic.edu.au/grade/report/grader/index.php?id=51" target="_blank"><span style="color:#446E4C;text-decoration:none">See all course grades</span></a></span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;line-height:14.25pt">
<span style="font-size:7.5pt">&nbsp;</span><o:p></o:p></p>
<table class="MsoNormalTable" border="1" cellspacing="0" cellpadding="0" style="border-collapse:collapse;font-size:inherit">
<tbody>
<tr>
<td colspan="5" style="border:solid black 1.0pt;background:#F57900;padding:6.0pt 6.0pt 6.0pt 6.0pt">
<p class="MsoNormal" align="center" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;text-align:center">
<b><span style="font-size:24.0pt;color:#FCE94F;background:#CC0000">( ! )</span>&nbsp;Warning: mysqli::query() [<a href="http://moodle.sandringhamsc.vic.edu.au/mod/assignment/mysqli.query" target="_blank"><span style="color:#446E4C;text-decoration:none">mysqli.query</span></a>]:
 (22003/1690): BIGINT UNSIGNED value is out of range in '(`vsmcllgbscamp_moodle`.`s`.`timemarked` - `vsmcllgbscamp_moodle`.`s`.`timemodified`)' in C:\wamp\www\Moodle\lib\dml\mysqli_native_moodle_database.php on line&nbsp;<i>793</i></b><o:p></o:p></p>
</td>
</tr>
<tr>
<td colspan="5" style="border:solid black 1.0pt;border-top:none;background:#E9B96E;padding:6.0pt 6.0pt 6.0pt 6.0pt">
<p class="MsoNormal" align="center" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;text-align:center">
<b>Call Stack</b><o:p></o:p></p>
</td>
</tr>
<tr>
<td style="border:solid black 1.0pt;border-top:none;background:#EEEEEC;padding:6.0pt 6.0pt 6.0pt 6.0pt">
<p class="MsoNormal" align="center" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;text-align:center">
<b>#</b><o:p></o:p></p>
</td>
<td style="border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;background:#EEEEEC;padding:6.0pt 6.0pt 6.0pt 6.0pt">
<p class="MsoNormal" align="center" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;text-align:center">
<b>Time</b><o:p></o:p></p>
</td>
<td style="border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;background:#EEEEEC;padding:6.0pt 6.0pt 6.0pt 6.0pt">
<p class="MsoNormal" align="center" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;text-align:center">
<b>Memory</b><o:p></o:p></p>
</td>
<td style="border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;background:#EEEEEC;padding:6.0pt 6.0pt 6.0pt 6.0pt">
<p class="MsoNormal" align="center" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;text-align:center">
<b>Function</b><o:p></o:p></p>
</td>
<td style="border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;background:#EEEEEC;padding:6.0pt 6.0pt 6.0pt 6.0pt">
<p class="MsoNormal" align="center" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;text-align:center">
<b>Location</b><o:p></o:p></p>
</td>
</tr>
<tr>
<td style="border:solid black 1.0pt;border-top:none;background:#EEEEEC;padding:6.0pt 6.0pt 6.0pt 6.0pt">
<p class="MsoNormal" align="center" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;text-align:center">
1<o:p></o:p></p>
</td>
<td style="border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;background:#EEEEEC;padding:6.0pt 6.0pt 6.0pt 6.0pt">
<p class="MsoNormal" align="center" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;text-align:center">
0.0010<o:p></o:p></p>
</td>
<td style="border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;background:#EEEEEC;padding:6.0pt 6.0pt 6.0pt 6.0pt">
<p class="MsoNormal" align="right" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;text-align:right">
393184<o:p></o:p></p>
</td>
<td style="border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;background:#EEEEEC;padding:6.0pt 6.0pt 6.0pt 6.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">{main}( )<o:p></o:p></p>
</td>
<td style="border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;background:#EEEEEC;padding:6.0pt 6.0pt 6.0pt 6.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">..\submissions.php<b>:</b>0<o:p></o:p></p>
</td>
</tr>
<tr>
<td style="border:solid black 1.0pt;border-top:none;background:#EEEEEC;padding:6.0pt 6.0pt 6.0pt 6.0pt">
<p class="MsoNormal" align="center" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;text-align:center">
2<o:p></o:p></p>
</td>
<td style="border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;background:#EEEEEC;padding:6.0pt 6.0pt 6.0pt 6.0pt">
<p class="MsoNormal" align="center" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;text-align:center">
0.3814<o:p></o:p></p>
</td>
<td style="border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;background:#EEEEEC;padding:6.0pt 6.0pt 6.0pt 6.0pt">
<p class="MsoNormal" align="right" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;text-align:right">
29455776<o:p></o:p></p>
</td>
<td style="border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;background:#EEEEEC;padding:6.0pt 6.0pt 6.0pt 6.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">assignment_base-&gt;submissions( )<o:p></o:p></p>
</td>
<td style="border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;background:#EEEEEC;padding:6.0pt 6.0pt 6.0pt 6.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">..\submissions.php<b>:</b>57<o:p></o:p></p>
</td>
</tr>
<tr>
<td style="border:solid black 1.0pt;border-top:none;background:#EEEEEC;padding:6.0pt 6.0pt 6.0pt 6.0pt">
<p class="MsoNormal" align="center" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;text-align:center">
3<o:p></o:p></p>
</td>
<td style="border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;background:#EEEEEC;padding:6.0pt 6.0pt 6.0pt 6.0pt">
<p class="MsoNormal" align="center" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;text-align:center">
0.3815<o:p></o:p></p>
</td>
<td style="border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;background:#EEEEEC;padding:6.0pt 6.0pt 6.0pt 6.0pt">
<p class="MsoNormal" align="right" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;text-align:right">
29455808<o:p></o:p></p>
</td>
<td style="border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;background:#EEEEEC;padding:6.0pt 6.0pt 6.0pt 6.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">assignment_base-&gt;display_submissions( )<o:p></o:p></p>
</td>
<td style="border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;background:#EEEEEC;padding:6.0pt 6.0pt 6.0pt 6.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">..\lib.php<b>:</b>642<o:p></o:p></p>
</td>
</tr>
<tr>
<td style="border:solid black 1.0pt;border-top:none;background:#EEEEEC;padding:6.0pt 6.0pt 6.0pt 6.0pt">
<p class="MsoNormal" align="center" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;text-align:center">
4<o:p></o:p></p>
</td>
<td style="border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;background:#EEEEEC;padding:6.0pt 6.0pt 6.0pt 6.0pt">
<p class="MsoNormal" align="center" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;text-align:center">
1.5469<o:p></o:p></p>
</td>
<td style="border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;background:#EEEEEC;padding:6.0pt 6.0pt 6.0pt 6.0pt">
<p class="MsoNormal" align="right" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;text-align:right">
51879560<o:p></o:p></p>
</td>
<td style="border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;background:#EEEEEC;padding:6.0pt 6.0pt 6.0pt 6.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">mysqli_native_moodle_database-&gt;get_records_sql( )<o:p></o:p></p>
</td>
<td style="border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;background:#EEEEEC;padding:6.0pt 6.0pt 6.0pt 6.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">..\lib.php<b>:</b>1295<o:p></o:p></p>
</td>
</tr>
<tr>
<td style="border:solid black 1.0pt;border-top:none;background:#EEEEEC;padding:6.0pt 6.0pt 6.0pt 6.0pt">
<p class="MsoNormal" align="center" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;text-align:center">
5<o:p></o:p></p>
</td>
<td style="border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;background:#EEEEEC;padding:6.0pt 6.0pt 6.0pt 6.0pt">
<p class="MsoNormal" align="center" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;text-align:center">
1.5470<o:p></o:p></p>
</td>
<td style="border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;background:#EEEEEC;padding:6.0pt 6.0pt 6.0pt 6.0pt">
<p class="MsoNormal" align="right" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;text-align:right">
51880904<o:p></o:p></p>
</td>
<td style="border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;background:#EEEEEC;padding:6.0pt 6.0pt 6.0pt 6.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">mysqli-&gt;query( )<o:p></o:p></p>
</td>
<td style="border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;background:#EEEEEC;padding:6.0pt 6.0pt 6.0pt 6.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">..\mysqli_native_moodle_database.php<b>:</b>793<o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
<div style="margin-top:12.0pt;margin-bottom:12.0pt">
<p align="center" style="margin-bottom:12.0pt;text-align:center;line-height:14.25pt">
<span style="font-size:10.5pt;color:black">Error reading from database</span><o:p></o:p></p>
<p align="center" style="margin-bottom:12.0pt;text-align:center;line-height:14.25pt">
<span style="font-size:10.5pt;color:black"><a href="http://docs.moodle.org/en/error/moodle/dmlreadexception" target="_blank"><span style="color:#446E4C;text-decoration:none">More information about this error</span></a></span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;line-height:14.25pt">
<strong><span style="font-size:7.5pt;color:black">Debug info:</span></strong><span style="font-size:7.5pt;color:black">&nbsp;BIGINT UNSIGNED value is out of range in '(`vsmcllgbscamp_moodle`.`s`.`timemarked` - `vsmcllgbscamp_moodle`.`s`.`timemodified`)'<br>
SELECT <a href="http://u.id" target="_blank">u.id</a>,u.picture,u.firstname,u.lastname,u.imagealt,u.email,&nbsp;<br>
<a href="http://s.id" target="_blank">s.id</a> AS submissionid, s.grade, s.submissioncomment,&nbsp;<br>
s.timemodified, s.timemarked,&nbsp;<br>
COALESCE(SIGN(SIGN(s.timemarked) &#43; SIGN(s.timemarked - s.timemodified)), 0) AS status FROM mdl_user u LEFT JOIN mdl_assignment_submissions s ON
<a href="http://u.id" target="_blank">u.id</a> = s.userid&nbsp;<br>
AND s.assignment = 21 WHERE <a href="http://u.id" target="_blank">u.id</a> IN (6,395,428,430,444,446,449,450,451,452,454,455,456,457,458,459,462) ORDER BY lastname ASC<br>
[array (<br>
)]</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;line-height:14.25pt">
<strong><span style="font-size:7.5pt;color:black">Stack trace:</span></strong><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;margin-right:18.0pt;margin-left:18.0pt;line-height:14.25pt">
<span style="font-size:10.0pt;font-family:Symbol;color:black">&middot;</span><span style="font-size:7.0pt;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span><span style="font-size:7.5pt;color:black">line 391 of \lib\dml\moodle_database.php: dml_read_exception thrown</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;margin-right:18.0pt;margin-left:18.0pt;line-height:14.25pt">
<span style="font-size:10.0pt;font-family:Symbol;color:black">&middot;</span><span style="font-size:7.0pt;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span><span style="font-size:7.5pt;color:black">line 794 of \lib\dml\mysqli_native_moodle_database.php: call to moodle_database-&gt;query_end()</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;margin-right:18.0pt;margin-left:18.0pt;line-height:14.25pt">
<span style="font-size:10.0pt;font-family:Symbol;color:black">&middot;</span><span style="font-size:7.0pt;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span><span style="font-size:7.5pt;color:black">line 1295 of \mod\assignment\lib.php: call to mysqli_native_moodle_database-&gt;get_records_sql()</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;margin-right:18.0pt;margin-left:18.0pt;line-height:14.25pt">
<span style="font-size:10.0pt;font-family:Symbol;color:black">&middot;</span><span style="font-size:7.0pt;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span><span style="font-size:7.5pt;color:black">line 642 of \mod\assignment\lib.php: call to assignment_base-&gt;display_submissions()</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;margin-right:18.0pt;margin-left:18.0pt;line-height:14.25pt">
<span style="font-size:10.0pt;font-family:Symbol;color:black">&middot;</span><span style="font-size:7.0pt;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span><span style="font-size:7.5pt;color:black">line 57 of \mod\assignment\submissions.php: call to assignment_base-&gt;submissions()</span><o:p></o:p></p>
</div>
</div>
<div>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:10.5pt;color:black">&nbsp;</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:10.5pt;color:black">Dave.</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:10.5pt;color:black">&nbsp;</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:10.5pt;color:black">Mr David Laursen</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:10.5pt;color:black">ICT Technician Beaumaris Campus</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:10.5pt;color:black">Sandringham College</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:10.5pt;color:black">0409 339 068</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:10.5pt;color:black">&nbsp;</span><o:p></o:p></p>
</div>
</div>
</div>
</div>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:10.5pt;color:black">&nbsp;</span><o:p></o:p></p>
</div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span style="color:black">From:
</span></b><span style="color:black">&quot;Arnott, Suzanne S&quot; &lt;<a href="mailto:arnott.suzanne.s@edumail.vic.gov.au" target="_blank">arnott.suzanne.s@edumail.vic.gov.au</a>&gt;<br>
<b>Date: </b>Thu, 30 Jun 2011 22:05:02 &#43;1000<br>
<b>To: </b>David Laursen &lt;<a href="mailto:laursen.david.w@edumail.vic.gov.au" target="_blank">laursen.david.w@edumail.vic.gov.au</a>&gt;<br>
<b>Subject: </b>RE: moodle - Database Error</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:10.5pt;color:black">&nbsp;</span><o:p></o:p></p>
</div>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="color:#1F497D">I will send out some feelers too</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="color:#1F497D">&nbsp;</span><o:p></o:p></p>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span lang="EN-US" style="font-size:10.0pt;color:black">From:</span></b><span lang="EN-US" style="font-size:10.0pt;color:black"> Laursen, David W
<br>
<b>Sent:</b> Thursday, 30 June 2011 6:21 PM<br>
<b>To:</b> Arnott, Suzanne S<br>
<b>Subject:</b> RE: moodle - Database Error</span><o:p></o:p></p>
</div>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="color:black">&nbsp;</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="color:#1F497D">Hi Suz,</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="color:#1F497D">I don&#8217;t have an answer yet.</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="color:#1F497D">I may have to hit the forums.</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="color:#1F497D">&nbsp;</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="color:#1F497D">Regards,</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="color:#1F497D">Dave</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="color:#1F497D">&nbsp;</span><o:p></o:p></p>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span lang="EN-US" style="font-size:10.0pt;color:black">From:</span></b><span lang="EN-US" style="font-size:10.0pt;color:black"> Arnott, Suzanne S
<br>
<b>Sent:</b> Thursday, 30 June 2011 2:47 PM<br>
<b>To:</b> Laursen, David W<br>
<b>Subject:</b> moodle </span><o:p></o:p></p>
</div>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="color:black">&nbsp;</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="color:black">For some reason I can&#8217;t fathom at the moment the data for an assignment I have set is not being read...</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="color:black">Any ideas?</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="color:black">It is in Design Tech 2 Textiles, assignment in outcome 1</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="color:black">Cheers</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="color:black">Suz</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="color:black">&nbsp;</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span style="font-size:16.0pt;font-family:Gigi;color:#403152">Suzanne Arnott</span></b><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="color:black">eLearning Leader</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="color:black">Sandringham College</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="color:black">&nbsp;</span><o:p></o:p></p>
</div>
</div>
</div>
<p><b>Important - </b>This email and any attachments may be confidential. If received in error, please contact us and delete all copies. Before opening or using attachments check them for viruses and defects. Regardless of any loss, damage or consequence, whether
 caused by the negligence of the sender or not, resulting directly or indirectly from the use of any attached files our liability is limited to resupplying any affected attachments. Any representations or opinions expressed are those of the individual sender,
 and not necessarily those of the Department of Education and Early Childhood Development.<o:p></o:p></p>
</div>
<p class="MsoNormal"><br>
_______________________________________________<br>
<a href="http://www.edulists.com.au" target="_blank">http://www.edulists.com.au</a> - FAQ, resources, subscribe, unsubscribe<br>
Moodle Mailing List kindly supported by<br>
<a href="http://www.vcaa.vic.edu.au" target="_blank">http://www.vcaa.vic.edu.au</a> - Victorian Curriculum and Assessment Authority and<br>
<a href="http://www.vitta.org.au" target="_blank">http://www.vitta.org.au</a> &nbsp;- VITTA Victorian Information Technology Teachers Association Inc<o:p></o:p></p>
</div>
<p class="MsoNormal"><o:p>&nbsp;</o:p></p>
</div>
</div>
<p></p><p><b>Important - </b>This email and any attachments may be confidential. If received in error, please contact us and delete all copies. Before opening or using attachments check them for viruses and defects. Regardless of any loss, damage or consequence, whether caused by the negligence of the sender or not, resulting directly or indirectly from the use of any attached files our liability is limited to resupplying any affected attachments. Any representations or opinions expressed are those of the individual sender, and not necessarily those of the Department of Education and Early Childhood Development.</p>
</body>
</html>