Bug 34580

Summary: 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
Product: Koha Reporter: Manos PETRIDIS <egpetridis>
Component: Installation and upgrade (web-based installer)Assignee: Fridolin Somers <fridolin.somers>
Status: CLOSED FIXED QA Contact: Testopia <testopia>
Severity: blocker    
Priority: P3 CC: fridolin.somers, gmcharlt
Version: 23.05   
Hardware: All   
OS: All   
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:
Bug Depends on: 33117    
Bug Blocks:    
Attachments: Error screenshot

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.