Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-63982

ltiservice_gradebookservices missing DB upgrade steps from prior version

    XMLWordPrintable

    Details

    • Affected Branches:
      MOODLE_35_STABLE

      Description

      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.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              heather.williams Heather Williams
              Participants:
              Component watchers:
              Adrian Greeve, Mihail Geshoski, Peter Dias, Adrian Greeve, Mihail Geshoski, Peter Dias
            • Votes:
              1 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated: