[Koha-bugs] [Bug 30951] Duplicate entry 'ar' for key 'PRIMARY'
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Mon Jun 13 22:54:37 CEST 2022
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30951
Fridolin Somers <fridolin.somers at biblibre.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |fridolin.somers at biblibre.co
| |m
--- Comment #2 from Fridolin Somers <fridolin.somers at biblibre.com> ---
Hi,
We have seen this one only once, on a very old database (started at 3.2).
We detect it with :
MariaDB [koha]> SELECT language_subtag,GROUP_CONCAT(script_subtag SEPARATOR ' |
'),COUNT(*) AS nb\
-> FROM language_script_mapping GROUP BY language_subtag HAVING nb > 1;
+-----------------+---------------------------------------------+----+
| language_subtag | GROUP_CONCAT(script_subtag SEPARATOR ' | ') | nb |
+-----------------+---------------------------------------------+----+
| ar | Arab | Arab | 2 |
| he | Hebr | Hebr | 2 |
+-----------------+---------------------------------------------+----+
And fix with :
DELETE FROM language_script_mapping WHERE language_subtag = 'ar' LIMIT 1 ;
DELETE FROM language_script_mapping WHERE language_subtag = 'he' LIMIT 1 ;
--
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
More information about the Koha-bugs
mailing list