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

mnet index upgrade causes error and stops upgrade

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 1.8
    • Fix Version/s: 1.8, 1.9
    • Component/s: MNet
    • Labels:
      None
    • Affected Branches:
      MOODLE_18_STABLE
    • Fixed Branches:
      MOODLE_18_STABLE, MOODLE_19_STABLE

      Description

      It's this unique index .... when it dies everything dies. Someone else reported this in the forum recently too.

      (mysql): CREATE UNIQUE INDEX user_mneuse_uix ON user (mnethostid, username) 1062: Duplicate entry '1-s' for key 2

      adodb_mysql._execute(CREATE UNIQUE INDEX user_mneuse_uix ON user (mnethostid, username), false) % line 889, file: adodb.inc.php
      adodb_mysql.execute(CREATE UNIQUE INDEX user_mneuse_uix ON user (mnethostid, username)) % line 89, file: dmllib.php
      execute_sql(CREATE UNIQUE INDEX user_mneuse_uix ON user (mnethostid, username), true) % line 1899, file: dmllib.php
      execute_sql_arr(Array[1], true, true) % line 1080, file: ddllib.php
      add_index(Object:xmldbtable, Object:xmldbindex) % line 342, file: upgrade.php

        Gliffy Diagrams

          Attachments

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Fix Release Date:
                  31/Mar/07