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

Missing Indexes In assignment_submissions table for MySQL

          Details

          • Type: Bug
          • Status: Closed
          • Priority: Minor
          • Resolution: Won't Fix
          • Affects Version/s: 1.5.4
          • Fix Version/s: None
          • Component/s: Assignment (2.2)
          • Labels:
            None
          • Database:
            MySQL
          • Affected Branches:
            MOODLE_15_STABLE

            Description

            The following Indexes need to be added to the assignment_submissions table;

            ALTER TABLE `mdl_assignment_submissions` ADD INDEX `userid` (`userid`);
            ALTER TABLE `mdl_assignment_submissions` ADD INDEX `timemarked` (`timemarked`);
            ALTER TABLE `mdl_assignment_submissions` ADD INDEX `timemodified` (`timemodified`);
            ALTER TABLE `mdl_assignment_submissions` ADD INDEX `assignment` (`assignment`);

              Gliffy Diagrams

                Attachments

                  Activity

                  Ascending order - Click to sort in descending order
                  Hide
                  Permalink
                  salvetore Michael de Raadt added a comment -

                  Thanks for reporting this issue.

                  We have detected that this issue has been inactive for over a year has been recorded as affecting versions that are no longer supported.

                  If you believe that this issue is still relevant to current versions (2.1 and beyond), please comment on the issue. Issues left inactive for a further month will be closed.

                  Michael d;

                  lqjjLKA0p6

                  Show
                  salvetore Michael de Raadt added a comment - Thanks for reporting this issue. We have detected that this issue has been inactive for over a year has been recorded as affecting versions that are no longer supported. If you believe that this issue is still relevant to current versions (2.1 and beyond), please comment on the issue. Issues left inactive for a further month will be closed. Michael d; lqjjLKA0p6
                  Hide
                  Permalink
                  salvetore Michael de Raadt added a comment -

                  I'm closing this issue as it has become inactive and does not appear to affect a current supported version. If you are encountering this problem or one similar, please launch a new issue.

                  Show
                  salvetore Michael de Raadt added a comment - I'm closing this issue as it has become inactive and does not appear to affect a current supported version. If you are encountering this problem or one similar, please launch a new issue.

                    People

                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      0 Start watching this issue

                      Dates

                      • Created:
                        Updated:
                        Resolved: