Moodle
  1. Moodle
  2. MDL-26049

Error message in accessing feedback responses

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Critical 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
    • Rank:
      15599

      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()

        Activity

        Vernellia Randall created issue -
        Martin Dougiamas made changes -
        Field Original Value New Value
        Workflow MDL Workflow [ 66977 ] MDL Full Workflow [ 75699 ]
        Hide
        Michael de Raadt added a comment -

        Thanks for reporting this issue.

        We have detected that this issue has been inactive for over a year. It was reported as affecting versions that are no longer supported.

        If you believe that this issue is still relevant to current versions (2.5 and beyond), please comment on the issue. Issues left inactive for a further month will be closed.

        Michael d.

        TW9vZGxlDQo=

        Show
        Michael de Raadt added a comment - Thanks for reporting this issue. We have detected that this issue has been inactive for over a year. It was reported as affecting versions that are no longer supported. If you believe that this issue is still relevant to current versions (2.5 and beyond), please comment on the issue. Issues left inactive for a further month will be closed. Michael d. TW9vZGxlDQo=
        Hide
        Michael de Raadt added a comment -

        I'm closing this issue as it has been inactive for over a year has been recorded as affecting versions that are no longer supported.

        This is being done as part of a bulk annual clean-up of issues.

        If you still believe this is an issue in supported versions, please create a new issue.

        Show
        Michael de Raadt added a comment - I'm closing this issue as it has been inactive for over a year has been recorded as affecting versions that are no longer supported. This is being done as part of a bulk annual clean-up of issues. If you still believe this is an issue in supported versions, please create a new issue.
        Michael de Raadt made changes -
        Status Open [ 1 ] Closed [ 6 ]
        Assignee Andreas Grabs [ grabs ]
        Resolution Won't Fix [ 2 ]

          People

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

            Dates

            • Created:
              Updated:
              Resolved: