mahara-contributors team mailing list archive

[Robert Lyon <1952362@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

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

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

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

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

** Changed in: mahara
   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/1952362

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

Status in Mahara:
  In Progress

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