Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-27678

Submitted Assignments unable to be accessed

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 2.0.3
    • Fix Version/s: None
    • Component/s: Assignment (2.2)
    • Labels:
      None
    • Testing Instructions:
      Hide

      Create a course with an activity of type 'Assignment - Advanced uploading of files'.
      Log in as a student and upload a word document file via the Activity page in course.
      Mark the submission 'Ready for Marking' after it has been uploaded.
      Log in as a Teacher / Admin and click on activity in the navigation to display the activity details
      In the 'Assignment Administration' block, select 'View 1 submitted assignments'
      *ERROR OCCURS HERE*
      Expect to see the assignment document.

      Show
      Create a course with an activity of type 'Assignment - Advanced uploading of files'. Log in as a student and upload a word document file via the Activity page in course. Mark the submission 'Ready for Marking' after it has been uploaded. Log in as a Teacher / Admin and click on activity in the navigation to display the activity details In the 'Assignment Administration' block, select 'View 1 submitted assignments' * ERROR OCCURS HERE * Expect to see the assignment document.
    • Affected Branches:
      MOODLE_20_STABLE

      Description

      Have created an Assignment that requires a submission in Moodle 2.0.3
      Logged in as a student and submitted the assignment as a word document.
      Submission appeared to save ok, was viewable by student, was downloadable by student etc.
      Logged in as Admin and went to 'View Submitted Assessments' via course admin
      Recieved an 'Error Reading from database' message.

      Debugging info includes:

      Debug info: BIGINT UNSIGNED value is out of range in '(`moodle`.`s`.`timemarked` - `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 = 1 WHERE u.id IN (6) 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 1303 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 369 of \mod\assignment\type\upload\assignment.class.php: call to assignment_base->submissions()
      line 57 of \mod\assignment\submissions.php: call to assignment_upload->submissions()

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              moodle.com moodle.com
              Reporter:
              bbear31oz Steven Evans
              Participants:
              Component watchers:
              Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: