-
Type:
Bug
-
Status: Open
-
Priority:
Minor
-
Resolution: Unresolved
-
Affects Version/s: 3.5.2
-
Fix Version/s: None
-
Component/s: External Tool (IMS-LTI), LTI provider
-
Labels:None
-
Affected Branches:MOODLE_35_STABLE
ltiservice_gradebookservices plugin which is included now as part of core instead of as a separate plugin only has the install steps, and is missing the upgrade steps to transition clients upgrading to M35 from previous versions of the standalone plugin. Upgrade steps are needed to convert the old database table from it's previous structure in version 2017060100:
CREATE TABLE `mdl_ltiservice_gradebookservices` (
|
`id` bigint(10) NOT NULL AUTO_INCREMENT, |
`toolproxyid` bigint(10) NOT NULL, |
`resourcelinkid` bigint(10) DEFAULT NULL, |
`tag` varchar(255) DEFAULT NULL, |
`previousid` bigint(10) DEFAULT NULL, |
PRIMARY KEY (`id`),
|
KEY `mdl_ltisgrad_res_ix` (`resourcelinkid`)
|
) ENGINE=InnoDB AUTO_INCREMENT=10108 DEFAULT CHARSET=utf8 COMMENT='This file records the grade items created by the LTI Gradebo'; |
to the new format of version 2018051400 currently in Moodle 3.5:
CREATE TABLE mdl_ltiservice_gradebookservices (
|
id BIGINT(10) NOT NULL auto_increment, |
gradeitemid BIGINT(10) NOT NULL, |
courseid BIGINT(10) NOT NULL, |
toolproxyid BIGINT(10), |
typeid BIGINT(10), |
baseurl LONGTEXT COLLATE utf8mb4_unicode_ci,
|
ltilinkid BIGINT(10), |
tag VARCHAR(255) COLLATE utf8mb4_unicode_ci, |
CONSTRAINT PRIMARY KEY (id)
|
, KEY mdl_ltisgrad_lti_ix (ltilinkid)
|
, KEY mdl_ltisgrad_gracou_ix (gradeitemid, courseid)
|
)
|
ENGINE = InnoDB
|
DEFAULT COLLATE = utf8mb4_unicode_ci ROW_FORMAT=Compressed
|
COMMENT='This file records the grade items created by the LTI Gradebo'; |
Until this is resolved users cannot duplicate/create new activities of this type.