[Koha-bugs] [Bug 30951] Duplicate entry 'ar' for key 'PRIMARY'

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30951

--- Comment #3 from victor <vbovictor at gmail.com> ---
(In reply to Fridolin Somers from comment #2)
> 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 ;

Thank you very much!
The issue was resolved with your guidance.

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.