[MDL-65556] Error in tags with accents - Moodle Tracker

XML

Word

Printable

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:
- triaged
Environment:
mysql Ver 14.14 Distrib 5.7.26, for Linux (x86_64) using EditLine wrapper

Database:

MySQL
Testing Instructions:
Hide

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
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

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.

Participants:: Carlos Lopez, David Herney Bernal, Ewout ter Haar, Janelle Barcega, Lee Hasson, Peter Miller, Sara Arjona (@sarjona)

Component watchers:: Amaia Anabitarte, Carlos Escobedo, Ferran Recio, Ilya Tregubov, Sara Arjona (@sarjona)