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

DB error on creating graph of some course stats

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Critical
    • 2.6.6, 2.7.3
    • 2.7.2
    • Reports
    • MOODLE_27_STABLE
    • MOODLE_26_STABLE, MOODLE_27_STABLE
    • Hide
      • enable and generate statistics (you need to play with your system date to do it on dev machines) - make sure you have individual users statistics for the course (just logging in and viewing the course is enough)
      • Go to the course reports > Statistics
      • On top of the screen a weird dropdown appears, select "Detailed view"
      • Try playing with different views, selecting individual students, etc. Graph should be displayed on every page that has data. If you see graph header but no image - it is a fail
      Show
      enable and generate statistics (you need to play with your system date to do it on dev machines) - make sure you have individual users statistics for the course (just logging in and viewing the course is enough) Go to the course reports > Statistics On top of the screen a weird dropdown appears, select "Detailed view" Try playing with different views, selecting individual students, etc. Graph should be displayed on every page that has data. If you see graph header but no image - it is a fail

    Description

      Instead of the graph on this URI:
      /report/stats/graph.php?mode=2&course=30&time=44&report=8&userid=0

      I get this error:
      Error reading from database

      Debug info: Unknown column 'statsreads' in 'field list'
      SELECT id,roleid,timeend,statsreads+statswrites as line1 FROM mdl_stats_monthly WHERE courseid = 30 AND stattype = 'activity' AND timeend >= 1349049600 ORDER BY timeend DESC
      [array (
      )]
      Error code: dmlreadexception
      Stack trace:
      line 443 of /lib/dml/moodle_database.php: dml_read_exception thrown
      line 1014 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
      line 84 of /report/stats/graph.php: call to mysqli_native_moodle_database->get_records_sql()

      In other courses the graphs are ok.

      Attachments

        1. stats1.png
          stats1.png
          96 kB
        2. stats2.png
          stats2.png
          148 kB
        3. stats3.png
          stats3.png
          90 kB

        Issue Links

          Activity

            People

              marina Marina Glancy
              complicator Pavel Krejci
              Simey Lameze Simey Lameze
              Sam Hemelryk Sam Hemelryk
              Michael de Raadt Michael de Raadt
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                10/Nov/14