<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&rid=2350&filter=1">http://moodle.org/mod/data/view.php?d=13&rid=2350&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"><<a href="mailto:moodle-request@edulists.com.au">moodle-request@edulists.com.au</a>></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 'help' 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 "Re: Contents of moodle digest..."<br><br><br>Today'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 <<a href="mailto:pdbrown@gmail.com">pdbrown@gmail.com</a>><br>
Subject: Re: [Moodle] moodle - Database Error message detail Help<br> needed<br>To: "The Moodle Users' in Schools Mailing List"<br> <<a href="mailto:moodle@edulists.com.au">moodle@edulists.com.au</a>><br>
Message-ID: <<a href="mailto:BANLkTikdwTaVREDR73_dfgQ3-0ngcJgqAw@mail.gmail.com">BANLkTikdwTaVREDR73_dfgQ3-0ngcJgqAw@mail.gmail.com</a>><br>Content-Type: text/plain; charset="windows-1252"<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 -><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'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 <<br><a href="mailto:arnott.suzanne.s@edumail.vic.gov.au">arnott.suzanne.s@edumail.vic.gov.au</a>> wrote:<br>
<br>> Hi guys...****<br>><br>> I am having a problem with an assignment ? when I go to view the submitted<br>> assignments I get the message ?error reading from database? and my<br>> technician has had a look around and came up with the message below...****<br>
><br>> I am reading all the words, but they are making no sense...what do I need<br>> to do to fix it?****<br>><br>> Cheers****<br>><br>> Suz****<br>><br>> ** **<br>><br>> *From:* Laursen, David W<br>
> *Sent:* Friday, 1 July 2011 10:05 AM<br>> *To:* Arnott, Suzanne S<br>> *Subject:* Re: moodle - Database Error message detail****<br>><br>> ** **<br>><br>> Hi Suz,****<br>><br>> Post this around and see what you get!****<br>
><br>> ** **<br>><br>> Dave.****<br>><br>> ** **<br>><br>> See all course grades<<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>><br>
> ****<br>><br>> ** **<br>><br>> *( ! )** Warning: mysqli::query() [mysqli.query<<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>>]:<br>
> (22003/1690): BIGINT UNSIGNED value is out of range in<br>> '(`vsmcllgbscamp_moodle`.`s`.`timemarked` -<br>> `vsmcllgbscamp_moodle`.`s`.`timemodified`)' in<br>> C:\wamp\www\Moodle\lib\dml\mysqli_native_moodle_database.php on line 793**<br>
> *<br>><br>> *Call Stack***<br>><br>> *#***<br>><br>> *Time***<br>><br>> *Memory***<br>><br>> *Function***<br>><br>> *Location***<br>><br>> 1****<br>><br>> 0.0010****<br>
><br>> 393184****<br>><br>> {main}( )****<br>><br>> ..\submissions.php*:*0****<br>><br>> 2****<br>><br>> 0.3814****<br>><br>> 29455776****<br>><br>> assignment_base->submissions( )****<br>
><br>> ..\submissions.php*:*57****<br>><br>> 3****<br>><br>> 0.3815****<br>><br>> 29455808****<br>><br>> assignment_base->display_submissions( )****<br>><br>> ..\lib.php*:*642****<br>
><br>> 4****<br>><br>> 1.5469****<br>><br>> 51879560****<br>><br>> mysqli_native_moodle_database->get_records_sql( )****<br>><br>> ..\lib.php*:*1295****<br>><br>> 5****<br>><br>> 1.5470****<br>
><br>> 51880904****<br>><br>> mysqli->query( )****<br>><br>> ..\mysqli_native_moodle_database.php*:*793****<br>><br>> Error reading from database****<br>><br>> More information about this error<<a href="http://docs.moodle.org/en/error/moodle/dmlreadexception" target="_blank">http://docs.moodle.org/en/error/moodle/dmlreadexception</a>><br>
> ****<br>><br>> *Debug info:* BIGINT UNSIGNED value is out of range in<br>> '(`vsmcllgbscamp_moodle`.`s`.`timemarked` -<br>> `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,<br>
> <a href="http://s.id/" target="_blank">s.id</a> AS submissionid, s.grade, s.submissioncomment,<br>> s.timemodified, s.timemarked,<br>> COALESCE(SIGN(SIGN(s.timemarked) + SIGN(s.timemarked - s.timemodified)), 0)<br>
> AS status FROM mdl_user u LEFT JOIN mdl_assignment_submissions s ON <a href="http://u.id/" target="_blank">u.id</a> =<br>> s.userid<br>> AND s.assignment = 21 WHERE <a href="http://u.id/" target="_blank">u.id</a> IN<br>
> (6,395,428,430,444,446,449,450,451,452,454,455,456,457,458,459,462) ORDER BY<br>> lastname ASC<br>> [array (<br>> )]****<br>><br>> *Stack trace:*****<br>><br>> **? **line 391 of \lib\dml\moodle_database.php: dml_read_exception<br>
> thrown****<br>><br>> **? **line 794 of \lib\dml\mysqli_native_moodle_database.php: call<br>> to moodle_database->query_end()****<br>><br>> **? **line 1295 of \mod\assignment\lib.php: call to<br>
> mysqli_native_moodle_database->get_records_sql()****<br>><br>> **? **line 642 of \mod\assignment\lib.php: call to<br>> assignment_base->display_submissions()****<br>><br>> **? **line 57 of \mod\assignment\submissions.php: call to<br>
> assignment_base->submissions()****<br>><br>> ** **<br>><br>> Dave.****<br>><br>> ** **<br>><br>> Mr David Laursen****<br>><br>> ICT Technician Beaumaris Campus****<br>><br>> Sandringham College****<br>
><br>> 0409 339 068****<br>><br>> ** **<br>><br>> ** **<br>><br>> *From: *"Arnott, Suzanne S" <<a href="mailto:arnott.suzanne.s@edumail.vic.gov.au">arnott.suzanne.s@edumail.vic.gov.au</a>><br>
> *Date: *Thu, 30 Jun 2011 22:05:02 +1000<br>> *To: *David Laursen <<a href="mailto:laursen.david.w@edumail.vic.gov.au">laursen.david.w@edumail.vic.gov.au</a>><br>> *Subject: *RE: moodle - Database Error****<br>
><br>> ** **<br>><br>> I will send out some feelers too****<br>><br>> ****<br>><br>> *From:* Laursen, David W<br>> *Sent:* Thursday, 30 June 2011 6:21 PM<br>> *To:* Arnott, Suzanne S<br>> *Subject:* RE: moodle - Database Error****<br>
><br>> ****<br>><br>> Hi Suz,****<br>><br>> I don?t have an answer yet.****<br>><br>> I may have to hit the forums.****<br>><br>> ****<br>><br>> Regards,****<br>><br>> Dave****<br>
><br>> ****<br>><br>> *From:* Arnott, Suzanne S<br>> *Sent:* Thursday, 30 June 2011 2:47 PM<br>> *To:* Laursen, David W<br>> *Subject:* moodle ****<br>><br>> ****<br>><br>> For some reason I can?t fathom at the moment the data for an assignment I<br>
> have set is not being read...****<br>><br>> Any ideas?****<br>><br>> It is in Design Tech 2 Textiles, assignment in outcome 1****<br>><br>> Cheers****<br>><br>> Suz****<br>><br>> ****<br>
><br>> *Suzanne Arnott*****<br>><br>> eLearning Leader****<br>><br>> Sandringham College****<br>><br>> ****<br>><br>> *Important - *This email and any attachments may be confidential. If<br>
> received in error, please contact us and delete all copies. Before opening<br>> or using attachments check them for viruses and defects. Regardless of any<br>> loss, damage or consequence, whether caused by the negligence of the sender<br>
> or not, resulting directly or indirectly from the use of any attached files<br>> our liability is limited to resupplying any affected attachments. Any<br>> representations or opinions expressed are those of the individual sender,<br>
> and not necessarily those of the Department of Education and Early Childhood<br>> Development.<br>><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<br>> and<br>> <a href="http://www.vitta.org.au/" target="_blank">http://www.vitta.org.au</a> - VITTA Victorian Information Technology Teachers<br>
> Association Inc<br>><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>