Moodle
  1. Moodle
  2. MDL-23327

Course report fails with course/enrol log entries

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Cannot Reproduce
    • Affects Version/s: 2.0
    • Fix Version/s: 2.0
    • Component/s: Course
    • Labels:
      None
    • Affected Branches:
      MOODLE_20_STABLE
    • Fixed Branches:
      MOODLE_20_STABLE

      Description

      I get the following error on the course/reports/ view activity log for today:

      debug info: Unknown column 'course' in 'field list'
      SELECT course FROM mdl_user WHERE id = ?
      [array (
      0 => '2',
      )]
      Stack trace:

      • line 378 of /lib/dml/moodle_database.php: dml_read_exception thrown
      • line 632 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
      • line 1216 of /lib/dml/moodle_database.php: call to mysqli_native_moodle_database->get_records_sql()
      • line 1291 of /lib/dml/moodle_database.php: call to moodle_database->get_record_sql()
      • line 1270 of /lib/dml/moodle_database.php: call to moodle_database->get_field_sql()
      • line 1249 of /lib/dml/moodle_database.php: call to moodle_database->get_field_select()
      • line 390 of /course/lib.php: call to moodle_database->get_field()
      • line 116 of /course/report/log/index.php: call to print_log()

      when $log =
      stdClass Object
      (
      [id] => 533
      [time] => 1279241218
      [userid] => 2
      [ip] => 203.97.116.120
      [course] => 2
      [module] => course
      [cmid] => 0
      [action] => enrol
      [url] => ../enrol/users.php?id=2
      [info] => 2
      [firstname] => Admin
      [lastname] => User
      [picture] => 0
      )

      and ld =
      stdClass Object
      (
      [id] => 5
      [module] => course
      [action] => enrol
      [mtable] => user
      [field] => course
      )

        Gliffy Diagrams

          Activity

          Dan Marsden created issue -
          James Brisland made changes -
          Field Original Value New Value
          Assignee moodle.com [ moodle.com ] James Brisland [ mrbriz ]
          Dan Marsden made changes -
          Status Open [ 1 ] Resolved [ 5 ]
          Resolution Cannot Reproduce [ 5 ]
          Martin Dougiamas made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          QA Assignee nobody
          Martin Dougiamas made changes -
          Workflow jira [ 37575 ] MDL Workflow [ 64951 ]
          Martin Dougiamas made changes -
          Workflow MDL Workflow [ 64951 ] MDL Full Workflow [ 94260 ]

            People

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

              Dates

              • Created:
                Updated:
                Resolved: