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

XMLDB Editor issue when loading multiple columns keys

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.8.1
    • 1.8.3, 1.9
    • Database SQL/XMLDB
    • None
    • Php 5.2.3 Mysql 5.0.x, XP Pro, Apache 2.0.59
    • MySQL
    • MOODLE_18_STABLE
    • MOODLE_18_STABLE, MOODLE_19_STABLE

    Description

      After the generator (table from MySQL) creates the index :

      <INDEXES>
      <INDEX NAME="mdl_projectid" UNIQUE="false" FIELDS="projectId, groupId" />
      </INDEXES>

      Loading back into editor hangs with XML error :

      XML Error: Element 'INDEX', attribute 'FIELDS': [facet 'pattern'] The value 'projectId, groupId' is not accepted by the pattern '[0-9a-z_, ]+' at line 56. Element 'INDEX', attribute 'FIELDS': 'projectId, groupId' is not a valid value of the atomic type 'fieldsList' at line 56.

      Attachments

        Activity

          People

            stronk7 Eloy Lafuente (stronk7)
            vf Valery Fremaux
            Nobody Nobody
            David Woloszyn, Huong Nguyen, Jake Dallimore, Meirza, Michael Hawkins, Raquel Ortega, Safat Shahin, Stevani Andolo
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:
              11/Oct/07