[Moodle] moodle Digest, Vol 75, Issue 2

Fri Jul 1 16:13:28 EST 2011

That sounds like a lot of file searching. Is it not possible to use

http://moodle.org/mod/data/view.php?d=13&rid=2350&filter=1

PDF reader. You can also write comment within PDF documents and it saves the
altered document as a different file.
cheers
johnD
Digital Teacher - Super Tech <http://www.digitalteacher.com.au/>

On Fri, Jul 1, 2011 at 2:08 PM, <moodle-request at edulists.com.au> wrote:

> Send moodle mailing list submissions to
>        moodle at edulists.com.au
>
> To subscribe or unsubscribe via the World Wide Web, visit
>        http://www.edulists.com.au/mailman/listinfo/moodle
> or, via email, send a message with subject or body 'help' to
>        moodle-request at edulists.com.au
>
> You can reach the person managing the list at
>        moodle-owner at edulists.com.au
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of moodle digest..."
>
>
> Today's Topics:
>
>   1. Re: moodle - Database Error message detail Help needed
>      (Phil Brown)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Fri, 1 Jul 2011 14:07:51 +1000
> From: Phil Brown <pdbrown at gmail.com>
> Subject: Re: [Moodle] moodle - Database Error message detail Help
>        needed
> To: "The Moodle Users' in Schools Mailing List"
>        <moodle at edulists.com.au>
> Message-ID: <BANLkTikdwTaVREDR73_dfgQ3-0ngcJgqAw at mail.gmail.com>
> Content-Type: text/plain; charset="windows-1252"
>
> Hi Suz,
>
> You can access the work (I presume students have uploaded to the
> assignment)
> by going to the files section of the class and going to moddata ->
> assignment, then choose the id number of the assignment.
>
> Each file uploaded into Moodle has a URL eg
>
> http://myschool.vic.edu.au/file/php/333/moddata/assignment/1603/2520/filename.doc
>
> 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.
>
> Good luck.
>
> Phil Brown
> WellingtonSC
>
> On Fri, Jul 1, 2011 at 10:39 AM, Arnott, Suzanne S <
> arnott.suzanne.s at edumail.vic.gov.au> wrote:
>
> >  Hi guys...****
> >
> > I am having a problem with an assignment ? when I go to view the
> submitted
> > assignments I get the message ?error reading from database? and my
> > technician has had a look around and came up with the message
> below...****
> >
> > I am reading all the words, but they are making no sense...what do I need
> > to do to fix it?****
> >
> > Cheers****
> >
> > Suz****
> >
> > ** **
> >
> > *From:* Laursen, David W
> > *Sent:* Friday, 1 July 2011 10:05 AM
> > *To:* Arnott, Suzanne S
> > *Subject:* Re: moodle - Database Error message detail****
> >
> > ** **
> >
> > Hi Suz,****
> >
> > Post this around and see what you get!****
> >
> > ** **
> >
> > Dave.****
> >
> > ** **
> >
> > See all course grades<
> http://moodle.sandringhamsc.vic.edu.au/grade/report/grader/index.php?id=51
> >
> > ****
> >
> > ** **
> >
> > *( ! )** Warning: mysqli::query() [mysqli.query<
> http://moodle.sandringhamsc.vic.edu.au/mod/assignment/mysqli.query>]:
> > (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
> 793**
> > *
> >
> > *Call Stack***
> >
> > *#***
> >
> > *Time***
> >
> > *Memory***
> >
> > *Function***
> >
> > *Location***
> >
> > 1****
> >
> > 0.0010****
> >
> > 393184****
> >
> > {main}( )****
> >
> > ..\submissions.php*:*0****
> >
> > 2****
> >
> > 0.3814****
> >
> > 29455776****
> >
> > assignment_base->submissions( )****
> >
> > ..\submissions.php*:*57****
> >
> > 3****
> >
> > 0.3815****
> >
> > 29455808****
> >
> > assignment_base->display_submissions( )****
> >
> > ..\lib.php*:*642****
> >
> > 4****
> >
> > 1.5469****
> >
> > 51879560****
> >
> > mysqli_native_moodle_database->get_records_sql( )****
> >
> > ..\lib.php*:*1295****
> >
> > 5****
> >
> > 1.5470****
> >
> > 51880904****
> >
> > mysqli->query( )****
> >
> > ..\mysqli_native_moodle_database.php*:*793****
> >
> > Error reading from database****
> >
> > More information about this error<
> http://docs.moodle.org/en/error/moodle/dmlreadexception>
> > ****
> >
> > *Debug info:* BIGINT UNSIGNED value is out of range in
> > '(`vsmcllgbscamp_moodle`.`s`.`timemarked` -
> > `vsmcllgbscamp_moodle`.`s`.`timemodified`)'
> > SELECT u.id,u.picture,u.firstname,u.lastname,u.imagealt,u.email,
> > s.id AS submissionid, s.grade, s.submissioncomment,
> > s.timemodified, s.timemarked,
> > COALESCE(SIGN(SIGN(s.timemarked) + SIGN(s.timemarked - s.timemodified)),
> 0)
> > AS status FROM mdl_user u LEFT JOIN mdl_assignment_submissions s ON u.id=
> > s.userid
> > AND s.assignment = 21 WHERE u.id IN
> > (6,395,428,430,444,446,449,450,451,452,454,455,456,457,458,459,462) ORDER
> BY
> > lastname ASC
> > [array (
> > )]****
> >
> > *Stack trace:*****
> >
> > **?         **line 391 of \lib\dml\moodle_database.php:
> dml_read_exception
> > thrown****
> >
> > **?         **line 794 of \lib\dml\mysqli_native_moodle_database.php:
> call
> > to moodle_database->query_end()****
> >
> > **?         **line 1295 of \mod\assignment\lib.php: call to
> > mysqli_native_moodle_database->get_records_sql()****
> >
> > **?         **line 642 of \mod\assignment\lib.php: call to
> > assignment_base->display_submissions()****
> >
> > **?         **line 57 of \mod\assignment\submissions.php: call to
> > assignment_base->submissions()****
> >
> > ** **
> >
> > Dave.****
> >
> > ** **
> >
> > Mr David Laursen****
> >
> > ICT Technician Beaumaris Campus****
> >
> > Sandringham College****
> >
> > 0409 339 068****
> >
> > ** **
> >
> > ** **
> >
> > *From: *"Arnott, Suzanne S" <arnott.suzanne.s at edumail.vic.gov.au>
> > *Date: *Thu, 30 Jun 2011 22:05:02 +1000
> > *To: *David Laursen <laursen.david.w at edumail.vic.gov.au>
> > *Subject: *RE: moodle - Database Error****
> >
> > ** **
> >
> > I will send out some feelers too****
> >
> >  ****
> >
> > *From:* Laursen, David W
> > *Sent:* Thursday, 30 June 2011 6:21 PM
> > *To:* Arnott, Suzanne S
> > *Subject:* RE: moodle - Database Error****
> >
> >  ****
> >
> > Hi Suz,****
> >
> > I don?t have an answer yet.****
> >
> > I may have to hit the forums.****
> >
> >  ****
> >
> > Regards,****
> >
> > Dave****
> >
> >  ****
> >
> > *From:* Arnott, Suzanne S
> > *Sent:* Thursday, 30 June 2011 2:47 PM
> > *To:* Laursen, David W
> > *Subject:* moodle ****
> >
> >  ****
> >
> > For some reason I can?t fathom at the moment the data for an assignment I
> > have set is not being read...****
> >
> > Any ideas?****
> >
> > It is in Design Tech 2 Textiles, assignment in outcome 1****
> >
> > Cheers****
> >
> > Suz****
> >
> >  ****
> >
> > *Suzanne Arnott*****
> >
> > eLearning Leader****
> >
> > Sandringham College****
> >
> >  ****
> >
> > *Important - *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.
> >
> > _______________________________________________
> > http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
> > Moodle Mailing List kindly supported by
> > http://www.vcaa.vic.edu.au - Victorian Curriculum and Assessment
> Authority
> > and
> > http://www.vitta.org.au  - VITTA Victorian Information Technology
> Teachers
> > Association Inc
> >
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:
> http://www.edulists.com.au/pipermail/moodle/attachments/20110701/f3a7f649/attachment.html
>
> ------------------------------
>
> _______________________________________________
> moodle mailing list
> moodle at edulists.com.au
> http://www.edulists.com.au/mailman/listinfo/moodle
>
>
> End of moodle Digest, Vol 75, Issue 2
> *************************************
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/moodle/attachments/20110701/3846742d/attachment.html 