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

Legacy log report error for modules

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 2.7
    • Fix Version/s: 2.7
    • Component/s: Logging, Reports
    • Labels:
    • Testing Instructions:
      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.
    • Affected Branches:
      MOODLE_27_STABLE
    • Fixed Branches:
      MOODLE_27_STABLE
    • Pull Master Branch:

      Description

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

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved:
                Fix Release Date:
                12/May/14