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

Unable to access list of submitted assignments

          Details

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

            1. Click on link for upload assignment.
            2. Click on Status - To order by status.
            3. Receive error.
            4. No longer able to access assignment information.

            Debug info: Unknown column 'status' in 'order clause'
            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 FROM mdl_user u LEFT JOIN mdl_assignment_submissions s ON u.id = s.userid
            AND s.assignment = 10 WHERE u.id IN (8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,88,89,90,91,92,93) ORDER BY status ASC, timemarked ASC
            [array (
            )]
            Stack trace:

            line 394 of /lib/dml/moodle_database.php: dml_read_exception thrown
            line 809 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
            line 1325 of /mod/assignment/lib.php: call to mysqli_native_moodle_database->get_records_sql()
            line 649 of /mod/assignment/lib.php: call to assignment_base->display_submissions()
            line 57 of /mod/assignment/submissions.php: call to assignment_base->submissions()

            Show
            1. Click on link for upload assignment. 2. Click on Status - To order by status. 3. Receive error. 4. No longer able to access assignment information. Debug info: Unknown column 'status' in 'order clause' 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 FROM mdl_user u LEFT JOIN mdl_assignment_submissions s ON u.id = s.userid AND s.assignment = 10 WHERE u.id IN (8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,88,89,90,91,92,93) ORDER BY status ASC, timemarked ASC [array ( )] Stack trace: line 394 of /lib/dml/moodle_database.php: dml_read_exception thrown line 809 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end() line 1325 of /mod/assignment/lib.php: call to mysqli_native_moodle_database->get_records_sql() line 649 of /mod/assignment/lib.php: call to assignment_base->display_submissions() line 57 of /mod/assignment/submissions.php: call to assignment_base->submissions()
          • Affected Branches:
            MOODLE_21_STABLE

            Description

            When attempting to list assignments (uploaded) by status order receive Error reading from database message. No longer able to access assignments at all.

            Opening with another browser allows for viewing of information. Still can not order list.

              Gliffy Diagrams

                Attachments

                  Issue Links

                  duplicates

                  Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-29529 Error reading from database - Unknown column 'status' in 'order clause'

                  • Blocker - Blocks development and/or testing, prevents Moodle from running (applicable to bugs only)
                  • Closed

                    Activity

                    Ascending order - Click to sort in descending order
                    Hide
                    Permalink
                    quen Sam Marshall added a comment -

                    Sounds like this is related to assignment. Reassigning.

                    Show
                    quen Sam Marshall added a comment - Sounds like this is related to assignment. Reassigning.
                    Hide
                    Permalink
                    sbourget Stephen Bourget added a comment -

                    Does this still happen with the latest version of Moodle 2.1.3+ I think this was fixed as part of MDL-29529

                    Show
                    sbourget Stephen Bourget added a comment - Does this still happen with the latest version of Moodle 2.1.3+ I think this was fixed as part of MDL-29529
                    Hide
                    Permalink
                    salvetore Michael de Raadt added a comment -

                    Thanks for reporting this. Please look for pre-existing issues before reporting.

                    This issue has been resolved. You will need to upgrade to get the fix.

                    Show
                    salvetore Michael de Raadt added a comment - Thanks for reporting this. Please look for pre-existing issues before reporting. This issue has been resolved. You will need to upgrade to get the fix.

                      People

                      • Votes:
                        0 Vote for this issue
                        Watchers:
                        1 Start watching this issue

                        Dates

                        • Created:
                          Updated:
                          Resolved: