[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

quickfire28 at gmail.com changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |quickfire28 at gmail.com

--- Comment #15 from quickfire28 at gmail.com ---
(In reply to victor from comment #3)
> (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.

Good day!

I tried to use this fix on my KOHA, and the update works. but when i use patron
seach on koha web and try to open the patron list it gives an error 500.

or when type name of patron on search bar and hit enter it also gives error
500.

Thank you!

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