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

Legacy log report error for modules

XMLWordPrintable

    • MOODLE_27_STABLE
    • MOODLE_27_STABLE
    • Hide
      1. Enable legacy logs on the site (Make you you both 'unhide' Legacy logs, and enable Log legacy data in its settings)
      2. In a course, create a forum
      3. Go into the forum
      4. Go to Logs under forum admin
      5. Change the log store from Standard to Legacy, hit 'Get these logs'
      6. Make sure you see records (probably just you viewing the forum once) and you get no errors.
      Show
      Enable legacy logs on the site (Make you you both 'unhide' Legacy logs, and enable Log legacy data in its settings) In a course, create a forum Go into the forum Go to Logs under forum admin Change the log store from Standard to Legacy, hit 'Get these logs' Make sure you see records (probably just you viewing the forum once) and you get no errors.

      If you try to view legacy log data for a specific module, you get an error:

      error converting legacy event data Error reading from databaseERROR: column "contextlevel" does not exist LINE 1: ... FROM mdl_log WHERE course = $1 AND cmid = $2 AND contextlev... ^ SELECT COUNT('x') FROM mdl_log WHERE course = $1 AND cmid = $2 AND contextlevel = $3 [array ( 0 => '2', 1 => '4', 2 => 70, )]
      * line 119 of /admin/tool/log/store/legacy/classes/log/store.php: call to debugging()
      * line 423 of /report/log/classes/table_log.php: call to logstore_legacy\log\store->get_events_select_count()
      * line 1495 of /lib/tablelib.php: call to report_log_table_log->query_db()
      * line 50 of /report/log/classes/renderer.php: call to table_sql->out()
      * line 221 of /lib/outputrenderers.php: call to report_log_renderer->render_report_log_renderable()
      * line 172 of /report/log/index.php: call to plugin_renderer_base->render()
       
      error converting legacy event data Error reading from databaseERROR: column "contextlevel" does not exist LINE 1: ... FROM mdl_log WHERE course = $1 AND cmid = $2 AND contextlev... ^ SELECT * FROM mdl_log WHERE course = $1 AND cmid = $2 AND contextlevel = $3 ORDER BY time DESC, id DESC LIMIT 100 OFFSET 0 [array ( 0 => '2', 1 => '4', 2 => 70, )]
      * line 100 of /admin/tool/log/store/legacy/classes/log/store.php: call to debugging()
      * line 427 of /report/log/classes/table_log.php: call to logstore_legacy\log\store->get_events_select()
      * line 1495 of /lib/tablelib.php: call to report_log_table_log->query_db()
      * line 50 of /report/log/classes/renderer.php: call to table_sql->out()
      * line 221 of /lib/outputrenderers.php: call to report_log_renderer->render_report_log_renderable()
      * line 172 of /report/log/index.php: call to plugin_renderer_base->render()
      

            emerrill Eric Merrill
            emerrill Eric Merrill
            Marina Glancy Marina Glancy
            Dan Poltawski Dan Poltawski
            Simey Lameze Simey Lameze
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved:

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