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

XMLDB Editor issue when loading multiple columns keys

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.8.1
    • Fix Version/s: 1.8.3, 1.9
    • Component/s: Database SQL/XMLDB
    • Labels:
      None
    • Environment:
      Php 5.2.3 Mysql 5.0.x, XP Pro, Apache 2.0.59
    • Database:
      MySQL
    • Affected Branches:
      MOODLE_18_STABLE
    • Fixed Branches:
      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

            Assignee:
            stronk7 Eloy Lafuente (stronk7)
            Reporter:
            vf Valery Fremaux
            Tester:
            Nobody
            Participants:
            Component watchers:
            Andrew Nicols, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Fix Release Date:
              11/Oct/07