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

Error message in accessing feedback responses

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Won't Fix
    • Affects Version/s: 2.0.1
    • Fix Version/s: None
    • Component/s: Feedback
    • Labels:
      None
    • Affected Branches:
      MOODLE_20_STABLE

      Description

      Debug info: Column 'timemodified' in order clause is ambiguous
      SELECT DISTINCT u.id,u.picture,u.firstname,u.lastname,u.imagealt,u.email FROM mdl_user u, mdl_feedback_completed c
      WHERE anonymous_response = ? AND u.id = c.userid AND c.feedback = ?
      ORDER BY timemodified ASC, lastname DESC LIMIT 0, 20
      [array (
      0 => 2,
      1 => '1',
      )]
      Stack trace:

      line 391 of /lib/dml/moodle_database.php: dml_read_exception thrown
      line 769 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
      line 875 of /mod/feedback/lib.php: call to mysqli_native_moodle_database->get_records_sql()
      line 167 of /mod/feedback/show_entries.php: call to feedback_get_complete_users()

        Gliffy Diagrams

          Attachments

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: