Unable to delete LTI external app if there is assessments associated with it
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Mahara |
Fix Released
|
High
|
Unassigned | ||
20.10 |
Fix Released
|
High
|
Unassigned | ||
21.04 |
Fix Released
|
High
|
Unassigned | ||
21.10 |
Fix Released
|
High
|
Unassigned | ||
22.04 |
Fix Released
|
High
|
Unassigned |
Bug Description
To test:
1) Install new site
2) Go to Administration -> Webservices -> External apps and create a new instance of the LTI 1.1 and make note of the instance id
3) Create a new person and make note of the [user id]
4) Log in as that person and create a collection and make note of the [collection id]
5) Normally we'd test this with a connection to an external site but for speed we can insert some info directly to the database - swapping out [instance id]
INSERT INTO lti_assessment (oauthserver, resourcelinkid, contextid, lisoutcomeservi
Then select the info from lti_assessment to find the [id from lti]
INSERT INTO lti_assessment_
6) Go to Administration -> Webservices -> External apps and try and delete the external app
Expected - app deleted
Actual - get an SQL error
Changed in mahara: | |
milestone: | none → 22.04.0 |
status: | New → In Progress |
importance: | Undecided → High |
Changed in mahara: | |
status: | In Progress → Fix Committed |
Patch for "main" branch: https:/ /reviews. mahara. org/12276