[Moodle] moodle - Database Error message detail Help needed

Fri Jul 1 16:14:10 EST 2011

Thanks Phil...
Nothing much is making sense...but my very clever tech is helping and may have more success :)

From: moodle-bounces at edulists.com.au [mailto:moodle-bounces at edulists.com.au] On Behalf Of Phil Brown
Sent: Friday, 1 July 2011 2:08 PM
To: The Moodle Users' in Schools Mailing List
Subject: Re: [Moodle] moodle - Database Error message detail Help needed

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<mailto: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<http://u.id>,u.picture,u.firstname,u.lastname,u.imagealt,u.email,
s.id<http://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<http://u.id> = s.userid
AND s.assignment = 21 WHERE u.id<http://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<mailto: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<mailto: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

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/moodle/attachments/20110701/af819899/attachment-0001.html 