mahara-contributors team mailing list archive

[Mahara Bot <1952362@xxxxxxxxxxxxxxxxxx>]

Reviewed:  https://reviews.mahara.org/12373
Committed: https://git.mahara.org/mahara/mahara/commit/d00efc46e34381b6d14a3291add044e619db3ab7
Submitter: Robert Lyon (robertl@xxxxxxxxxxxxxxx)
Branch:    20.10_DEV

commit d00efc46e34381b6d14a3291add044e619db3ab7
Author: Robert Lyon <robertl@xxxxxxxxxxxxxxx>
Date:   Fri Nov 26 11:31:44 2021 +1300

Bug 1952362: Unable to delete an LTI 1.1 external app

When there are submissions added to it

Change-Id: I23b1f6900b9e57fb3f12dcd5ab6ec3c8b2ad6eb3
Signed-off-by: Robert Lyon <robertl@xxxxxxxxxxxxxxx>

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

Title:
  Unable to delete LTI external app if there is assessments associated
  with it

Status in Mahara:
  Fix Committed
Status in Mahara 20.10 series:
  Fix Committed
Status in Mahara 21.04 series:
  Fix Committed
Status in Mahara 21.10 series:
  Fix Committed
Status in Mahara 22.04 series:
  Fix Committed

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,
  lisoutcomeserviceurl, contexttitle, resourcelinktitle, "group",
  emailnotifications, lock, archive, timeconfigured) VALUES ([instance
  id], '123', '107', 'https://example.com', 'Catalyst', 'Mahara
  assignment', 1, 1, 0, 0, '2019-04-26 07:34:27');

  Then select the info from lti_assessment to find the [id from lti]

  INSERT INTO lti_assessment_submission (usr, ltiassessment,
  lisresultsourceid, timesubmitted, grade, timegraded, gradedbyusr,
  collectionid, viewid) VALUES ([user id], [id from lti], 'this is a
  test', '2019-04-26 07:38:11', 90, '2019-04-27 07:08:09', 1,
  [collection id], null);

  6) Go to Administration -> Webservices -> External apps and try and
  delete the external app

  Expected - app deleted

  Actual - get an SQL error

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