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
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:
              11/Oct/07