Bug 34580 - ERROR: {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Duplicate entry 'DefaultPatronSearchMethod' for key 'PRIMARY' at /usr/share/koha/lib/C4/Installer.pm line 741
Summary: ERROR: {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Duplicate entry 'D...
Status: RESOLVED FIXED
Alias: None
Product: Koha
Classification: Unclassified
Component: Installation and upgrade (web-based installer) (show other bugs)
Version: 23.05
Hardware: All All
: P3 blocker (vote)
Assignee: Fridolin Somers
QA Contact: Testopia
URL:
Keywords:
Depends on: 33117
Blocks:
  Show dependency treegraph
 
Reported: 2023-08-18 20:03 UTC by Manos PETRIDIS
Modified: 2023-08-25 11:41 UTC (History)
2 users (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments
Error screenshot (23.07 KB, image/png)
2023-08-18 20:03 UTC, Manos PETRIDIS
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Manos PETRIDIS 2023-08-18 20:03:00 UTC
Created attachment 154671 [details]
Error screenshot

While updating from 22.11 to 23.05

Updating database structure
Update errors :

Upgrade to 23.05.01.002 [22:40:49]: Bug 33117 - Patron checkout is not able to find patrons if using a second surname or other name during the search
ERROR: {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Duplicate entry 'DefaultPatronSearchMethod' for key 'PRIMARY' at /usr/share/koha/lib/C4/Installer.pm line 741
Comment 1 Fridolin Somers 2023-08-24 19:00:17 UTC
Hi,

This is fixed in next release 23.05.03 by patch "Bug 33117: Make dbrev idempotent"
https://git.koha-community.org/Koha-community/Koha/commits/branch/23.05.x/search?q=33117
Comment 2 Manos PETRIDIS 2023-08-25 11:41:53 UTC
Thank you for your reply. Amended /usr/share/koha/intranet/cgi-bin/installer/data/mysql/db_revs/230501002.pl accordingly and can verify that update proceeded without any further problem.