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

Bigbluebutton upgrade script failure when recording table exists

    XMLWordPrintable

Details

    • MOODLE_400_STABLE, MOODLE_401_STABLE
    • MOODLE_400_STABLE, MOODLE_401_STABLE
    • MDL-75281-401
    • MDL-75281-master
    • Hide

      Note: You will need to install a new 3.11 site, perhaps with:

      mdk create -t -n test75281 -v 311
      

      Between each version test you will need to reset it back to 3.11 and reinstall it at 3.11 and then complete the next step.

      Basic steps

      1. Install a fresh 3.11 Moodle instance using MariaDB or MySQL
      2. Install the mod_bigbluebuttonbn plugin version 2.4 https://github.com/blindsidenetworks/moodle-mod_bigbluebuttonbn/tree/v2.4-stable
      3. Create the recording table manually

        CREATE TABLE mdl_bigbluebuttonbn_recordings (
            id BIGINT(10) NOT NULL auto_increment,
            courseid BIGINT(10) NOT NULL,
            bigbluebuttonbnid BIGINT(10) NOT NULL,
            groupid BIGINT(10),
            recordingid VARCHAR(64) COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
            headless TINYINT(1) NOT NULL DEFAULT 0,
            imported TINYINT(1) NOT NULL DEFAULT 0,
            status TINYINT(1) NOT NULL DEFAULT 0,
            importeddata LONGTEXT COLLATE utf8mb4_0900_ai_ci,
            timecreated BIGINT(10) NOT NULL DEFAULT 0,
            usermodified BIGINT(10) NOT NULL DEFAULT 0,
            timemodified BIGINT(10) NOT NULL DEFAULT 0,
        CONSTRAINT  PRIMARY KEY (id)
        , KEY mdl_bigbreco_cou2_ix (courseid)
        , KEY mdl_bigbreco_rec2_ix (recordingid)
        , KEY mdl_bigbreco_big2_ix (bigbluebuttonbnid)
        , KEY mdl_bigbreco_use2_ix (usermodified)
        )
         ENGINE = InnoDB
         DEFAULT COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT=Compressed
         COMMENT='The bigbluebuttonbn table to store references to recordings';
        

      4. Check out the test branch (400, 401, master)
      5. Run the CLI upgrade:

        php admin/cli/upgrade.php
        

        1. Confirm that the site was upgaded without error
      Show
      Note: You will need to install a new 3.11 site, perhaps with: mdk create -t -n test75281 -v 311 Between each version test you will need to reset it back to 3.11 and reinstall it at 3.11 and then complete the next step. Basic steps Install a fresh 3.11 Moodle instance using MariaDB or MySQL Install the mod_bigbluebuttonbn plugin version 2.4 https://github.com/blindsidenetworks/moodle-mod_bigbluebuttonbn/tree/v2.4-stable Create the recording table manually CREATE TABLE mdl_bigbluebuttonbn_recordings ( id BIGINT(10) NOT NULL auto_increment, courseid BIGINT(10) NOT NULL, bigbluebuttonbnid BIGINT(10) NOT NULL, groupid BIGINT(10), recordingid VARCHAR(64) COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '', headless TINYINT(1) NOT NULL DEFAULT 0, imported TINYINT(1) NOT NULL DEFAULT 0, status TINYINT(1) NOT NULL DEFAULT 0, importeddata LONGTEXT COLLATE utf8mb4_0900_ai_ci, timecreated BIGINT(10) NOT NULL DEFAULT 0, usermodified BIGINT(10) NOT NULL DEFAULT 0, timemodified BIGINT(10) NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) , KEY mdl_bigbreco_cou2_ix (courseid) , KEY mdl_bigbreco_rec2_ix (recordingid) , KEY mdl_bigbreco_big2_ix (bigbluebuttonbnid) , KEY mdl_bigbreco_use2_ix (usermodified) ) ENGINE = InnoDB DEFAULT COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT=Compressed COMMENT='The bigbluebuttonbn table to store references to recordings'; Check out the test branch (400, 401, master) Run the CLI upgrade: php admin/cli/upgrade.php Confirm that the site was upgaded without error

    Description

      Step to reproduce:

      • Do a fresh 3.11 install
      • Install the bigbluebutton plugin 2.4-stable
      • Create the recording table

        CREATE TABLE mdl_bigbluebuttonbn_recordings (
            id BIGINT(10) NOT NULL auto_increment,
            courseid BIGINT(10) NOT NULL,
            bigbluebuttonbnid BIGINT(10) NOT NULL,
            groupid BIGINT(10),
            recordingid VARCHAR(64) COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
            headless TINYINT(1) NOT NULL DEFAULT 0,
            imported TINYINT(1) NOT NULL DEFAULT 0,
            status TINYINT(1) NOT NULL DEFAULT 0,
            importeddata LONGTEXT COLLATE utf8mb4_0900_ai_ci,
            timecreated BIGINT(10) NOT NULL DEFAULT 0,
            usermodified BIGINT(10) NOT NULL DEFAULT 0,
            timemodified BIGINT(10) NOT NULL DEFAULT 0,
        CONSTRAINT  PRIMARY KEY (id)
        , KEY mdl_bigbreco_cou2_ix (courseid)
        , KEY mdl_bigbreco_rec2_ix (recordingid)
        , KEY mdl_bigbreco_big2_ix (bigbluebuttonbnid)
        , KEY mdl_bigbreco_use2_ix (usermodified)
        )
         ENGINE = InnoDB
         DEFAULT COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT=Compressed
         COMMENT='The bigbluebuttonbn table to store references to recordings';
        

      • Upgrade to 4.0.2 via the command line (php admin/cli/upgrade.php)
      • The following error should appear:

      mod_bigbluebuttonbn
      Field "recording" does not exist in table "bigbluebuttonbn_recordings"
       
      More information about this error
       
      Debug info:
      Error code: ddlfieldnotexist × Dismiss this notification
      Stack trace:
      line 683 of /lib/ddl/database_manager.php: ddl_field_missing_exception thrown
      line 356 of /mod/bigbluebuttonbn/db/upgrade.php: call to database_manager->rename_field()
      line 883 of /lib/upgradelib.php: call to xmldb_bigbluebuttonbn_upgrade()
      line 582 of /lib/upgradelib.php: call to upgrade_plugins_modules()
      line 1935 of /lib/upgradelib.php: call to upgrade_plugins()
      line 719 of /admin/index.php: call to upgrade_noncore()
      

      Attachments

        1. 311_step3.1.png
          108 kB
          Safat Shahin
        2. 311_step3.png
          195 kB
          Safat Shahin
        3. 311_to_400.txt
          22 kB
          Safat Shahin
        4. 311_to_401.txt
          24 kB
          Safat Shahin
        5. 311_to_master.txt
          25 kB
          Safat Shahin

        Issue Links

          Activity

            People

              lmdavid Laurent DAVID
              lmdavid Laurent DAVID
              Shamiso Jaravaza Shamiso Jaravaza
              Andrew Lyons Andrew Lyons
              Safat Shahin Safat Shahin
              Votes:
              0 Vote for this issue
              Watchers:
              9 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - 0 minutes
                  0m
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 2 hours, 52 minutes
                  2h 52m

                  Clockify

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