When we delete a group, we delete the records in 'lti_assessment' if there was any lti submissions to the group. The same when deleting a collection.
I think we should also delete the 'lti_assessment' records in this case.
I made a patch with Ghada as the author for this solution:
To delete, add the following to /htdocs/webservice/admin.oauthv1sregister.php at line 120:
delete_records_sql('DELETE FROM {lti_assessment} WHERE oauthserver IN (SELECT id FROM {oauth_server_registry} WHERE consumer_key = ?)', array($dbserver->consumer_key));
When we delete a group, we delete the records in 'lti_assessment' if there was any lti submissions to the group. The same when deleting a collection.
I think we should also delete the 'lti_assessment' records in this case.
I made a patch with Ghada as the author for this solution:
To delete, add the following to /htdocs/ webservice/ admin.oauthv1sr egister. php at line 120:
delete_ records_ sql('DELETE FROM {lti_assessment} WHERE oauthserver IN (SELECT id FROM {oauth_ server_ registry} WHERE consumer_key = ?)', array($ dbserver- >consumer_ key));