[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 #17 from Katrin Fischer <katrin.fischer at bsz-bw.de> ---
(In reply to quickfire28 from comment #15)
> (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!

I believe these are unrelated - the error you see is unlikely to be linked to
the change to languages. Please try the mailing list with a description of your
issue.

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