mahara-contributors team mailing list archive

[Robert Lyon <1950413@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

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

** Affects: mahara
     Importance: High
         Status: In Progress

** Affects: mahara/21.10
     Importance: High
         Status: New

** Affects: mahara/22.04
     Importance: High
         Status: In Progress

** Also affects: mahara/22.04
   Importance: Undecided
       Status: New

** Also affects: mahara/21.10
   Importance: Undecided
       Status: New

** Changed in: mahara/22.04
    Milestone: None => 22.04.0

** Changed in: mahara/21.10
    Milestone: None => 21.10.1

** Changed in: mahara/22.04
       Status: New => In Progress

** Changed in: mahara/21.10
   Importance: Undecided => High

** Changed in: mahara/22.04
   Importance: Undecided => High

-- 
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:
  In Progress
Status in Mahara 21.10 series:
  New
Status in Mahara 22.04 series:
  In Progress

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