<div>That sounds like a lot of file searching. Is it not possible to use</div>
<div> </div>
<div><a href="http://moodle.org/mod/data/view.php?d=13&amp;rid=2350&amp;filter=1">http://moodle.org/mod/data/view.php?d=13&amp;rid=2350&amp;filter=1</a></div>
<div> </div>
<div>PDF reader. You can also write comment within PDF documents and it saves the altered document as a different file.</div>
<div>cheers</div>
<div>johnD<br clear="all"></div>
<div><a href="http://www.digitalteacher.com.au/" target="_blank">Digital Teacher - Super Tech</a></div>
<div> </div><br><br><br>
<div class="gmail_quote">On Fri, Jul 1, 2011 at 2:08 PM, <span dir="ltr">&lt;<a href="mailto:moodle-request@edulists.com.au">moodle-request@edulists.com.au</a>&gt;</span> wrote:<br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">Send moodle mailing list submissions to<br>       <a href="mailto:moodle@edulists.com.au">moodle@edulists.com.au</a><br>
<br>To subscribe or unsubscribe via the World Wide Web, visit<br>       <a href="http://www.edulists.com.au/mailman/listinfo/moodle" target="_blank">http://www.edulists.com.au/mailman/listinfo/moodle</a><br>or, via email, send a message with subject or body &#39;help&#39; to<br>
       <a href="mailto:moodle-request@edulists.com.au">moodle-request@edulists.com.au</a><br><br>You can reach the person managing the list at<br>       <a href="mailto:moodle-owner@edulists.com.au">moodle-owner@edulists.com.au</a><br>
<br>When replying, please edit your Subject line so it is more specific<br>than &quot;Re: Contents of moodle digest...&quot;<br><br><br>Today&#39;s Topics:<br><br>  1. Re: moodle - Database Error message detail Help needed<br>
     (Phil Brown)<br><br><br>----------------------------------------------------------------------<br><br>Message: 1<br>Date: Fri, 1 Jul 2011 14:07:51 +1000<br>From: Phil Brown &lt;<a href="mailto:pdbrown@gmail.com">pdbrown@gmail.com</a>&gt;<br>
Subject: Re: [Moodle] moodle - Database Error message detail Help<br>       needed<br>To: &quot;The Moodle Users&#39; in Schools Mailing List&quot;<br>       &lt;<a href="mailto:moodle@edulists.com.au">moodle@edulists.com.au</a>&gt;<br>
Message-ID: &lt;<a href="mailto:BANLkTikdwTaVREDR73_dfgQ3-0ngcJgqAw@mail.gmail.com">BANLkTikdwTaVREDR73_dfgQ3-0ngcJgqAw@mail.gmail.com</a>&gt;<br>Content-Type: text/plain; charset=&quot;windows-1252&quot;<br><br>Hi Suz,<br>
<br>You can access the work (I presume students have uploaded to the assignment)<br>by going to the files section of the class and going to moddata -&gt;<br>assignment, then choose the id number of the assignment.<br><br>
Each file uploaded into Moodle has a URL eg<br><a href="http://myschool.vic.edu.au/file/php/333/moddata/assignment/1603/2520/filename.doc" target="_blank">http://myschool.vic.edu.au/file/php/333/moddata/assignment/1603/2520/filename.doc</a><br>
<br>The moddata folder is found in the files section of each class. All<br>assignments have numbers (in the eg above it&#39;s 1603) and students have<br>numbers ( 2520, above) If you can work out the assignment number you can<br>
retrieve the student woks from that folder.<br><br>Good luck.<br><br>Phil Brown<br>WellingtonSC<br><br>On Fri, Jul 1, 2011 at 10:39 AM, Arnott, Suzanne S &lt;<br><a href="mailto:arnott.suzanne.s@edumail.vic.gov.au">arnott.suzanne.s@edumail.vic.gov.au</a>&gt; wrote:<br>
<br>&gt;  Hi guys...****<br>&gt;<br>&gt; I am having a problem with an assignment ? when I go to view the submitted<br>&gt; assignments I get the message ?error reading from database? and my<br>&gt; technician has had a look around and came up with the message below...****<br>
&gt;<br>&gt; I am reading all the words, but they are making no sense...what do I need<br>&gt; to do to fix it?****<br>&gt;<br>&gt; Cheers****<br>&gt;<br>&gt; Suz****<br>&gt;<br>&gt; ** **<br>&gt;<br>&gt; *From:* Laursen, David W<br>
&gt; *Sent:* Friday, 1 July 2011 10:05 AM<br>&gt; *To:* Arnott, Suzanne S<br>&gt; *Subject:* Re: moodle - Database Error message detail****<br>&gt;<br>&gt; ** **<br>&gt;<br>&gt; Hi Suz,****<br>&gt;<br>&gt; Post this around and see what you get!****<br>
&gt;<br>&gt; ** **<br>&gt;<br>&gt; Dave.****<br>&gt;<br>&gt; ** **<br>&gt;<br>&gt; See all course grades&lt;<a href="http://moodle.sandringhamsc.vic.edu.au/grade/report/grader/index.php?id=51" target="_blank">http://moodle.sandringhamsc.vic.edu.au/grade/report/grader/index.php?id=51</a>&gt;<br>
&gt; ****<br>&gt;<br>&gt; ** **<br>&gt;<br>&gt; *( ! )** Warning: mysqli::query() [mysqli.query&lt;<a href="http://moodle.sandringhamsc.vic.edu.au/mod/assignment/mysqli.query" target="_blank">http://moodle.sandringhamsc.vic.edu.au/mod/assignment/mysqli.query</a>&gt;]:<br>
&gt; (22003/1690): BIGINT UNSIGNED value is out of range in<br>&gt; &#39;(`vsmcllgbscamp_moodle`.`s`.`timemarked` -<br>&gt; `vsmcllgbscamp_moodle`.`s`.`timemodified`)&#39; in<br>&gt; C:\wamp\www\Moodle\lib\dml\mysqli_native_moodle_database.php on line 793**<br>
&gt; *<br>&gt;<br>&gt; *Call Stack***<br>&gt;<br>&gt; *#***<br>&gt;<br>&gt; *Time***<br>&gt;<br>&gt; *Memory***<br>&gt;<br>&gt; *Function***<br>&gt;<br>&gt; *Location***<br>&gt;<br>&gt; 1****<br>&gt;<br>&gt; 0.0010****<br>
&gt;<br>&gt; 393184****<br>&gt;<br>&gt; {main}( )****<br>&gt;<br>&gt; ..\submissions.php*:*0****<br>&gt;<br>&gt; 2****<br>&gt;<br>&gt; 0.3814****<br>&gt;<br>&gt; 29455776****<br>&gt;<br>&gt; assignment_base-&gt;submissions( )****<br>
&gt;<br>&gt; ..\submissions.php*:*57****<br>&gt;<br>&gt; 3****<br>&gt;<br>&gt; 0.3815****<br>&gt;<br>&gt; 29455808****<br>&gt;<br>&gt; assignment_base-&gt;display_submissions( )****<br>&gt;<br>&gt; ..\lib.php*:*642****<br>
&gt;<br>&gt; 4****<br>&gt;<br>&gt; 1.5469****<br>&gt;<br>&gt; 51879560****<br>&gt;<br>&gt; mysqli_native_moodle_database-&gt;get_records_sql( )****<br>&gt;<br>&gt; ..\lib.php*:*1295****<br>&gt;<br>&gt; 5****<br>&gt;<br>&gt; 1.5470****<br>
&gt;<br>&gt; 51880904****<br>&gt;<br>&gt; mysqli-&gt;query( )****<br>&gt;<br>&gt; ..\mysqli_native_moodle_database.php*:*793****<br>&gt;<br>&gt; Error reading from database****<br>&gt;<br>&gt; More information about this error&lt;<a href="http://docs.moodle.org/en/error/moodle/dmlreadexception" target="_blank">http://docs.moodle.org/en/error/moodle/dmlreadexception</a>&gt;<br>
&gt; ****<br>&gt;<br>&gt; *Debug info:* BIGINT UNSIGNED value is out of range in<br>&gt; &#39;(`vsmcllgbscamp_moodle`.`s`.`timemarked` -<br>&gt; `vsmcllgbscamp_moodle`.`s`.`timemodified`)&#39;<br>&gt; SELECT <a href="http://u.id/" target="_blank">u.id</a>,u.picture,u.firstname,u.lastname,u.imagealt,u.email,<br>
&gt; <a href="http://s.id/" target="_blank">s.id</a> AS submissionid, s.grade, s.submissioncomment,<br>&gt; s.timemodified, s.timemarked,<br>&gt; COALESCE(SIGN(SIGN(s.timemarked) + SIGN(s.timemarked - s.timemodified)), 0)<br>
&gt; AS status FROM mdl_user u LEFT JOIN mdl_assignment_submissions s ON <a href="http://u.id/" target="_blank">u.id</a> =<br>&gt; s.userid<br>&gt; AND s.assignment = 21 WHERE <a href="http://u.id/" target="_blank">u.id</a> IN<br>
&gt; (6,395,428,430,444,446,449,450,451,452,454,455,456,457,458,459,462) ORDER BY<br>&gt; lastname ASC<br>&gt; [array (<br>&gt; )]****<br>&gt;<br>&gt; *Stack trace:*****<br>&gt;<br>&gt; **?         **line 391 of \lib\dml\moodle_database.php: dml_read_exception<br>
&gt; thrown****<br>&gt;<br>&gt; **?         **line 794 of \lib\dml\mysqli_native_moodle_database.php: call<br>&gt; to moodle_database-&gt;query_end()****<br>&gt;<br>&gt; **?         **line 1295 of \mod\assignment\lib.php: call to<br>
&gt; mysqli_native_moodle_database-&gt;get_records_sql()****<br>&gt;<br>&gt; **?         **line 642 of \mod\assignment\lib.php: call to<br>&gt; assignment_base-&gt;display_submissions()****<br>&gt;<br>&gt; **?         **line 57 of \mod\assignment\submissions.php: call to<br>
&gt; assignment_base-&gt;submissions()****<br>&gt;<br>&gt; ** **<br>&gt;<br>&gt; Dave.****<br>&gt;<br>&gt; ** **<br>&gt;<br>&gt; Mr David Laursen****<br>&gt;<br>&gt; ICT Technician Beaumaris Campus****<br>&gt;<br>&gt; Sandringham College****<br>
&gt;<br>&gt; 0409 339 068****<br>&gt;<br>&gt; ** **<br>&gt;<br>&gt; ** **<br>&gt;<br>&gt; *From: *&quot;Arnott, Suzanne S&quot; &lt;<a href="mailto:arnott.suzanne.s@edumail.vic.gov.au">arnott.suzanne.s@edumail.vic.gov.au</a>&gt;<br>
&gt; *Date: *Thu, 30 Jun 2011 22:05:02 +1000<br>&gt; *To: *David Laursen &lt;<a href="mailto:laursen.david.w@edumail.vic.gov.au">laursen.david.w@edumail.vic.gov.au</a>&gt;<br>&gt; *Subject: *RE: moodle - Database Error****<br>
&gt;<br>&gt; ** **<br>&gt;<br>&gt; I will send out some feelers too****<br>&gt;<br>&gt;  ****<br>&gt;<br>&gt; *From:* Laursen, David W<br>&gt; *Sent:* Thursday, 30 June 2011 6:21 PM<br>&gt; *To:* Arnott, Suzanne S<br>&gt; *Subject:* RE: moodle - Database Error****<br>
&gt;<br>&gt;  ****<br>&gt;<br>&gt; Hi Suz,****<br>&gt;<br>&gt; I don?t have an answer yet.****<br>&gt;<br>&gt; I may have to hit the forums.****<br>&gt;<br>&gt;  ****<br>&gt;<br>&gt; Regards,****<br>&gt;<br>&gt; Dave****<br>
&gt;<br>&gt;  ****<br>&gt;<br>&gt; *From:* Arnott, Suzanne S<br>&gt; *Sent:* Thursday, 30 June 2011 2:47 PM<br>&gt; *To:* Laursen, David W<br>&gt; *Subject:* moodle ****<br>&gt;<br>&gt;  ****<br>&gt;<br>&gt; For some reason I can?t fathom at the moment the data for an assignment I<br>
&gt; have set is not being read...****<br>&gt;<br>&gt; Any ideas?****<br>&gt;<br>&gt; It is in Design Tech 2 Textiles, assignment in outcome 1****<br>&gt;<br>&gt; Cheers****<br>&gt;<br>&gt; Suz****<br>&gt;<br>&gt;  ****<br>
&gt;<br>&gt; *Suzanne Arnott*****<br>&gt;<br>&gt; eLearning Leader****<br>&gt;<br>&gt; Sandringham College****<br>&gt;<br>&gt;  ****<br>&gt;<br>&gt; *Important - *This email and any attachments may be confidential. If<br>
&gt; received in error, please contact us and delete all copies. Before opening<br>&gt; or using attachments check them for viruses and defects. Regardless of any<br>&gt; loss, damage or consequence, whether caused by the negligence of the sender<br>
&gt; or not, resulting directly or indirectly from the use of any attached files<br>&gt; our liability is limited to resupplying any affected attachments. Any<br>&gt; representations or opinions expressed are those of the individual sender,<br>
&gt; and not necessarily those of the Department of Education and Early Childhood<br>&gt; Development.<br>&gt;<br>&gt; _______________________________________________<br>&gt; <a href="http://www.edulists.com.au/" target="_blank">http://www.edulists.com.au</a> - FAQ, resources, subscribe, unsubscribe<br>
&gt; Moodle Mailing List kindly supported by<br>&gt; <a href="http://www.vcaa.vic.edu.au/" target="_blank">http://www.vcaa.vic.edu.au</a> - Victorian Curriculum and Assessment Authority<br>&gt; and<br>&gt; <a href="http://www.vitta.org.au/" target="_blank">http://www.vitta.org.au</a>  - VITTA Victorian Information Technology Teachers<br>
&gt; Association Inc<br>&gt;<br>-------------- next part --------------<br>An HTML attachment was scrubbed...<br>URL: <a href="http://www.edulists.com.au/pipermail/moodle/attachments/20110701/f3a7f649/attachment.html" target="_blank">http://www.edulists.com.au/pipermail/moodle/attachments/20110701/f3a7f649/attachment.html</a><br>
<br>------------------------------<br><br>_______________________________________________<br>moodle mailing list<br><a href="mailto:moodle@edulists.com.au">moodle@edulists.com.au</a><br><a href="http://www.edulists.com.au/mailman/listinfo/moodle" target="_blank">http://www.edulists.com.au/mailman/listinfo/moodle</a><br>
<br><br>End of moodle Digest, Vol 75, Issue 2<br>*************************************<br></blockquote></div><br>