[Moodle] moodle - Database Error message detail Help needed

Fri Jul 1 14:07:51 EST 2011

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-0001.html 