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

Relation mdl_course_modules_viewed not exist error since upgrade has not been run

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Critical Critical
    • 4.1
    • 4.1
    • General
    • MOODLE_401_STABLE
    • MOODLE_401_STABLE
    • MDL-76033-master
    • Hide
      1. Install a fresh Moodle site using Moodle 3.11
      2. Create a course using default settings
      3. View the course page and copy the url to clipboard so you can go back there
      4. Upgrade the code to Moodle 4.0 (just code - don't run upgrade script)
      5. Visit the course page directly

      EXPECTED: You should not see a coding exception error at this point, but should be redirect to the upgrade process as normal.

      BEFORE FIX: A coding exception appears.

      Same instructions for my/indexsys.php page

      Show
      Install a fresh Moodle site using Moodle 3.11 Create a course using default settings View the course page and copy the url to clipboard so you can go back there Upgrade the code to Moodle 4.0 (just code - don't run upgrade script) Visit the course page directly EXPECTED : You should not see a coding exception error at this point, but should be redirect to the upgrade process as normal. BEFORE FIX : A coding exception appears. Same instructions for my/indexsys.php page

      After landing MDL-58266 if you update Moodle to use latest code and access course page without running upgrade you will get

      Debug info: ERROR: relation "mdl_course_modules_viewed" does not exist
      LINE 6: ... LEFT JOIN mdl_course...
      ^
      SELECT cm.id AS cmid, cmc.*,
      CASE WHEN cmv.id IS NULL THEN 0 ELSE 1 END AS viewed
      FROM mdl_course_modules cm
      LEFT JOIN mdl_course_modules_completion cmc
      ON cmc.coursemoduleid = cm.id AND cmc.userid = $1
      LEFT JOIN mdl_course_modules_viewed cmv
      ON cmv.coursemoduleid = cm.id AND cmv.userid = $2
      INNER JOIN mdl_modules m ON m.id = cm.module
      WHERE m.visible = 1 AND cm.course = $3
      [array (
      0 => 2,
      1 => 2,
      2 => '13',
      )]
      Error code: dmlreadexception
      

      We should force site upgrade to create a table

        1. MDL-76033_indexsys.webm
          1.19 MB
          Angelia Dela Cruz
        2. MDL-76033_course.webm
          1.36 MB
          Angelia Dela Cruz

            ilyatregubov Ilya Tregubov
            ilyatregubov Ilya Tregubov
            Eloy Lafuente (stronk7) Eloy Lafuente (stronk7)
            Victor Déniz Falcón Victor Déniz Falcón
            Angelia Dela Cruz Angelia Dela Cruz
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved:

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 1 hour, 25 minutes
                1h 25m

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