mahara-contributors team mailing list archive

[Mahara Bot <1950413@xxxxxxxxxxxxxxxxxx>]

Patch for "21.10_DEV" branch: https://reviews.mahara.org/12309

-- 
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/1950413

Title:
  Problem with upgrade when LTI instance containing submissions exists

Status in Mahara:
  Fix Committed
Status in Mahara 21.10 series:
  New
Status in Mahara 22.04 series:
  Fix Committed

Bug description:
  Get error:
  Cannot delete or update a parent row: a foreign key constraint fails in "lti_assessment"

  To test:
  1) have an older site, say version 20.04 and create a group in the site
  2) create a Webservice -> External app for LTI
  3) insert a row in lti_assessment table where the 'oauthserver' equals the value from
   SELECT id FROM external_services WHERE shortname = 'maharalti';
  4) upgrade site and see error

  The problem is the auth/webservice upgrade step happens before
  module/lti upgrade step but relies on the module/lti step having
  first.

  So we need to move a module/lti step to auth/webservice upgrade to
  avoid this problem

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