[Koha-bugs] [Bug 32762] Duplicate entry '10434' for key 'PRIMARY' at /usr/share/koha/lib/C4/Installer.pm line 739

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

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

--- Comment #3 from quickfire28 at gmail.com ---
Im not that good in MySQL, can i ask how can i locate the lines before and
after the error? the KOHA version im going to update is 20.05( i already fix
the first bug i found in my update using this (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 ;)


but after this one the next error bug appears.
(ERROR - {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Duplicate entry
'10434' for key 'PRIMARY' at /usr/share/koha/lib/C4/Installer.pm line 739)

Please help me in finding the error.

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