[Moodle] moodle - Database Error message detail Help needed

[Arnott, Suzanne S]

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