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

Error in tags with accents

    XMLWordPrintable

Details

    • Bug
    • Status: Open
    • Minor
    • Resolution: Unresolved
    • 3.4.8, 3.5.5, 3.6.3, 3.7
    • None
    • Tags
    • mysql Ver 14.14 Distrib 5.7.26, for Linux (x86_64) using EditLine wrapper
    • MySQL
    • MOODLE_34_STABLE, MOODLE_35_STABLE, MOODLE_36_STABLE, MOODLE_37_STABLE
    • 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

    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

            Unassigned Unassigned
            cirano David Herney Bernal
            Amaia Anabitarte, Carlos Escobedo, Ferran Recio, Ilya Tregubov, Laurent David, Raquel Ortega, Sara Arjona (@sarjona)
            Votes:
            6 Vote for this issue
            Watchers:
            10 Start watching this issue

            Dates

              Created:
              Updated: