[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
bugzilla-daemon at bugs.koha-community.org
Fri Feb 3 02:44:00 CET 2023
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32762
--- Comment #4 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.
More information about the Koha-bugs
mailing list