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

Error in tags with accents

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 3.4.8, 3.5.5, 3.6.3, 3.7
    • Fix Version/s: None
    • Component/s: Tags
    • Labels:
    • Environment:
      mysql Ver 14.14 Distrib 5.7.26, for Linux (x86_64) using EditLine wrapper
    • Database:
      MySQL
    • Testing Instructions:
      Hide
      1. Login into the platform
      2. Go to User account > Edit profile
      3. Set "musica" into "List of interests"
      4. Save with "Update profile" button
      5. Edit profile again
      6. Add "música" into "List of interests"
      7. Save with "Update profile" button
      8. The error is showed
      Show
      Login into the platform Go to User account > Edit profile Set "musica" into "List of interests" Save with "Update profile" button Edit profile again Add "música" into "List of interests" Save with "Update profile" button The error is showed
    • Affected Branches:
      MOODLE_34_STABLE, MOODLE_35_STABLE, MOODLE_36_STABLE, MOODLE_37_STABLE

      Description

      An error happen when a tag with accent is added if other equal tag exist without accent. Por example: "música"/"musica".

      The error is by the "tag_tagnam_uix" index.

      An error message example:

      Duplicate entry '1-música' for key 'mdl_tag_tagnam_uix'

      Using utf8mb4_unicode_ci (recomended by Moodle - https://docs.moodle.org/36/en/MySQL_full_unicode_support) and MySQL.

       

       

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated: