Problem with upgrade when LTI instance containing submissions exists
Bug #1950413 reported by
Robert Lyon
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
Mahara | ||||||
21.10 |
Fix Released
|
High
|
Unassigned | |||
22.04 |
Fix Released
|
High
|
Unassigned |
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
no longer affects: | mahara |
To post a comment you must log in.
Patch for "main" branch: https:/ /reviews. mahara. org/12238