mahara-contributors team mailing list archive

[Gold <1970680@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

While upgrading a test site on Mahara 21.x that did not have LTI
Advantage the upgrade fails.

Tracked this to an upgrade step in htdocs/lib/db/upgrade.php

This version resolved the issue:

    if ($oldversion < 2021042718) {
        $table = new XMLDBTable('lti_assessment');
        if (table_exists($table)) {
            log_debug("Make sure groups associated with LTI assessment have 'submittableto' set to true");
            execute_sql("
                UPDATE {group}
                SET submittableto = 1
                WHERE id IN (
                    SELECT foo.id FROM (
                        SELECT g1.id
                        FROM {lti_assessment} l
                        JOIN {group} g1 ON g1.id = l.group
                        WHERE g1.submittableto = 0
                    ) AS foo
                )");
        }
    }

** Affects: mahara
     Importance: Critical
     Assignee: Gold (gold.catalyst)
         Status: Confirmed


** Tags: bite-sized

-- 
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
Matching subscriptions: mahara-contributors
https://bugs.launchpad.net/bugs/1970680

Title:
  Upgrade fails when LTI Advantage not installed

Status in Mahara:
  Confirmed

Bug description:
  While upgrading a test site on Mahara 21.x that did not have LTI
  Advantage the upgrade fails.

  Tracked this to an upgrade step in htdocs/lib/db/upgrade.php

  This version resolved the issue:

      if ($oldversion < 2021042718) {
          $table = new XMLDBTable('lti_assessment');
          if (table_exists($table)) {
              log_debug("Make sure groups associated with LTI assessment have 'submittableto' set to true");
              execute_sql("
                  UPDATE {group}
                  SET submittableto = 1
                  WHERE id IN (
                      SELECT foo.id FROM (
                          SELECT g1.id
                          FROM {lti_assessment} l
                          JOIN {group} g1 ON g1.id = l.group
                          WHERE g1.submittableto = 0
                      ) AS foo
                  )");
          }
      }

To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/1970680/+subscriptions