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 |
| Mahara Bot (dev-mahara) wrote A patch has been submitted for review | #1 |
| Mahara Bot (dev-mahara) wrote A change has been merged | #2 |
| Changed in mahara: | |
| status: | In Progress → Fix Committed |
| Mahara Bot (dev-mahara) wrote A patch has been submitted for review | #3 |
| Mahara Bot (dev-mahara) wrote | #4 |
| Mahara Bot (dev-mahara) wrote | #5 |
| Mahara Bot (dev-mahara) wrote A change has been merged | #6 |
| Mahara Bot (dev-mahara) wrote | #7 |
| Mahara Bot (dev-mahara) wrote | #8 |
Patch for "main" branch: https:/