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

assignment submissions.php throws db error when using visible groups mode

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Minor Minor
    • None
    • 2.1.1
    • Assignment (2.2)
    • None
    • Centos 5.x x86_64, Postgresql 8.4, php 5.3.x, apache 2.2
    • PostgreSQL
    • MOODLE_21_STABLE
    • Hide

      create an assignment in the visible groups mode.
      let students submit their assignments.
      open the submitted assignments

      Show
      create an assignment in the visible groups mode. let students submit their assignments. open the submitted assignments

      When you want to see the submissions of an assignment using visible groups mode and you click on the "View X submitted assignments" link you get an 'Error reading from database' message:

      e.g.

      Debug info: ERROR: column "status" does not exist at character 467
      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 = 1329 WHERE u.id IN (11399,395,9660,3125,2675,13744,5234,2144,2510,12783,13603,4836,10865,2522,2567,3050,6448,13717,6396,2460,14207,2122) ORDER BY status ASC, lastname ASC
      [array (
      )]
      Stack trace:
      line 394 of /lib/dml/moodle_database.php: dml_read_exception thrown
      line 232 of /lib/dml/pgsql_native_moodle_database.php: call to moodle_database->query_end()
      line 678 of /lib/dml/pgsql_native_moodle_database.php: call to pgsql_native_moodle_database->query_end()
      line 1321 of /mod/assignment/lib.php: call to pgsql_native_moodle_database->get_records_sql()
      line 645 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()

            stronk7 Eloy Lafuente (stronk7)
            edinamonsoon edinamonsoon (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved:

                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.