April 2026 - Koha-bugs - lists.koha-community.org

[Bug 39139] New: SIP2 patron lookups can fail if no active currency is set
by bugzilla-daemon＠bugs.koha-community.org 16 Oct '26

16 Oct '26

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=39139 Bug ID: 39139 Summary: SIP2 patron lookups can fail if no active currency is set Change sponsored?: --- Product: Koha Version: Main Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: SIP2 Assignee: koha-bugs(a)lists.koha-community.org Reporter: gmcharlt(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org If no active currency is set, SIIP2 patron information lookups can fail to return a response. This was observed for message 23 responses, but probably also affects message 63 responses. The problem is line 128 of C4/SIP/ILS/Patron.pm: my $currency = substr Koha::Acquisition::Currencies->get_active->currency, 0, 3; If no currency is active, an exception is thrown and the SIP protocol loop terminates. This likely affects all releases that include the patches for bug 23426 -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 4

[Bug 40032] New: Make SIP2 log missing active currency
by bugzilla-daemon＠bugs.koha-community.org 16 Oct '26

16 Oct '26

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=40032 Bug ID: 40032 Summary: Make SIP2 log missing active currency Change sponsored?: --- Product: Koha Version: Main Hardware: All OS: All Status: NEW Severity: minor Priority: P5 - low Component: SIP2 Assignee: koha-bugs(a)lists.koha-community.org Reporter: magnus(a)libriotech.no QA Contact: testopia(a)bugs.koha-community.org We just had a situation where "Patron Status Requests" were failing, because no currency was set to active. There was a warning about this in "About Koha > System information", but it would be nice if there was a warning in the SIP2 log too. To reproduce in KTD: Make sure not currency is active, then: $ telnet localhost 6001 Trying 127.0.0.1... Connected to localhost. Escape character is '^]'. 9300CNterm1|COterm1|CPCPL 941 2300120250530 090947AOCPL|AAterm1|AC|ADterm1 Connection closed by foreign host. In /var/log/koha/kohadev/sip-output.log: [2025/05/30 08:34:28] [2336] [INFO] term1(a)127.0.0.1: INPUT MSG: '2300120250530 090947AOCPL|AAterm1|AC***|ADterm1' C4::SIP::Sip::siplog /kohadevbox/koha/C4/SIP/Sip.pm (319) [2025/05/30 08:34:28] [2336] [DEBUG] term1(a)127.0.0.1: Sip::MsgType::new('C4::SIP::Sip::MsgType', '2300120250...', '23'): seq.no '0', protocol 2 C4::SIP::Sip::siplog /kohadevbox/koha/C4/SIP/Sip.pm (319) [2025/05/30 08:34:28] [2336] [DEBUG] term1(a)127.0.0.1: Sip::MsgType::_initialize('Patron Status Request', '00120250530 090947AOCPL|AAterm1|AC***|ADterm1', 'A3A18', '21', ...) C4::SIP::Sip::siplog /kohadevbox/koha/C4/SIP/Sip.pm (319) [2025/05/30 08:34:28] [2336] [DEBUG] term1(a)127.0.0.1: Debarred = undef : C4::SIP::Sip::siplog /kohadevbox/koha/C4/SIP/Sip.pm (319) [2025/05/30 08:34:28] [2336] [INFO] term1(a)127.0.0.1: raw_transport: shutting down C4::SIP::Sip::siplog /kohadevbox/koha/C4/SIP/Sip.pm (319) Suggested solution: In C4::SIP::ILS::Patron::new() we do this: # Get currency 3 chars max my $currency = substr Koha::Acquisition::Currencies->get_active->currency, 0, 3; We could add a check for defined $currency and a log message if it is not defined. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 6

[Bug 41178] New: SIP2 module does not notify that linked accounts are deleted when deleting an institution
by bugzilla-daemon＠bugs.koha-community.org 16 Oct '26

16 Oct '26

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=41178 Bug ID: 41178 Summary: SIP2 module does not notify that linked accounts are deleted when deleting an institution Initiative type: --- Sponsorship --- status: Product: Koha Version: Main Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: SIP2 Assignee: koha-bugs(a)lists.koha-community.org Reporter: pedro.amorim(a)openfifth.co.uk QA Contact: testopia(a)bugs.koha-community.org -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 34

[Bug 40910] New: Log pollution for undefined/empty barcodes
by bugzilla-daemon＠bugs.koha-community.org 16 Oct '26

16 Oct '26

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=40910 Bug ID: 40910 Summary: Log pollution for undefined/empty barcodes Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: SIP2 Assignee: koha-bugs(a)lists.koha-community.org Reporter: tomascohen(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org Noticed in production, when `C4::SIP::ILS::Item->new` is passed an `$item_id` that is not defined or empty -or barcodedecode makes it like that- (e.g. faulty plugins) logs get flooded with DBIx::Class errors when it should never reach the ORM with a query because there's nothing to search for. If `barcodedecode` empties the barcode, a debug log should be printed because it might be a sign of a misconfiguration or faulty plugin. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 17

[Bug 42043] New: SIP recording DBIX class errors
by bugzilla-daemon＠bugs.koha-community.org 16 Oct '26

16 Oct '26

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42043 Bug ID: 42043 Summary: SIP recording DBIX class errors Initiative type: --- Sponsorship --- status: Product: Koha Version: Main Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: SIP2 Assignee: koha-bugs(a)lists.koha-community.org Reporter: nick(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org In KTD: tail -f /var/log/koha/kohadev/*.log In another terminal: perl misc/sip_cli_emulator.pl -a localhost -p 6001 -su term1 -sp term1 -l CPL -m patron_information --patron enda -t CR Note: [2026/03/09 16:10:41] [179650] [ERROR] [undef]@[undef]: DBIx::Class::ResultSource::_minimal_valueset_satisfying_constraint(): Unable to satisfy requested constraint 'primary', missing values for column(s): 'borrowernumber' at /kohadevbox/koha/Koha/Objects.pm line 95 C4::SIP::Trapper::__ANON__ /kohadevbox/koha/C4/SIP/Trapper.pm (70) [2026/03/09 16:10:41] [179650] [ERROR] [undef]@[undef]: DBIx::Class::ResultSource::_minimal_valueset_satisfying_constraint(): Unable to satisfy requested constraint 'cardnumber', missing values for column(s): 'cardnumber' at /kohadevbox/koha/Koha/Objects.pm line 95 C4::SIP::Trapper::__ANON__ /kohadevbox/koha/C4/SIP/Trapper.pm (70) [2026/03/09 16:10:41] [179650] [ERROR] [undef]@[undef]: DBIx::Class::ResultSource::_minimal_valueset_satisfying_constraint(): Unable to satisfy requested constraint 'cardnumber', missing values for column(s): 'cardnumber' at /kohadevbox/koha/Koha/Object.pm line 382 C4::SIP::Trapper::__ANON__ /kohadevbox/koha/C4/SIP/Trapper.pm (70) [2026/03/09 16:10:41] [179650] [ERROR] [undef]@[undef]: DBIx::Class::ResultSource::_minimal_valueset_satisfying_constraint(): Unable to satisfy requested constraint 'userid', missing values for column(s): 'userid' at /kohadevbox/koha/Koha/Object.pm line 382 C4::SIP::Trapper::__ANON__ /kohadevbox/koha/C4/SIP/Trapper.pm (70) -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 8

[Bug 40120] New: Log changes to SIP configuration made through staff interface
by bugzilla-daemon＠bugs.koha-community.org 16 Oct '26

16 Oct '26

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=40120 Bug ID: 40120 Summary: Log changes to SIP configuration made through staff interface Change sponsored?: --- Product: Koha Version: Main Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Tools Assignee: koha-bugs(a)lists.koha-community.org Reporter: andrew(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org Depends on: 37893 Bug 37893 seeks to make parts of SIP setup accessible via the staff interface. If those things become editable in the staff interface, we'll want the action_logs to record any changes made. Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37893 [Bug 37893] Migrate some SIP configuration into the staff interface -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 2

[Bug 39840] New: Lost status does not block checkout via SIP
by bugzilla-daemon＠bugs.koha-community.org 16 Oct '26

16 Oct '26

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=39840 Bug ID: 39840 Summary: Lost status does not block checkout via SIP Change sponsored?: --- Product: Koha Version: Main Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Circulation Assignee: koha-bugs(a)lists.koha-community.org Reporter: hebah(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com Some libraries would like SIP checkouts to block issuing of lost items to force patrons to bring the item to a staff member to override or resolve the lost status. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 2

[Bug 35130] New: Limit Item Types that can be checked in Via SIP2
by bugzilla-daemon＠bugs.koha-community.org 16 Oct '26

16 Oct '26

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=35130 Bug ID: 35130 Summary: Limit Item Types that can be checked in Via SIP2 Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: SIP2 Assignee: koha-bugs(a)lists.koha-community.org Reporter: lisette.scheer(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org Similar to 34101, some libraries would like the ability to limit check in via SIP2 by item type. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 3

[Bug 41179] New: SIP2 module should auto-complete (search) patrons for accounts staff userid input
by bugzilla-daemon＠bugs.koha-community.org 16 Oct '26

16 Oct '26

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=41179 Bug ID: 41179 Summary: SIP2 module should auto-complete (search) patrons for accounts staff userid input Initiative type: --- Sponsorship --- status: Product: Koha Version: Main Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: SIP2 Assignee: koha-bugs(a)lists.koha-community.org Reporter: pedro.amorim(a)openfifth.co.uk QA Contact: testopia(a)bugs.koha-community.org When creating/editing a SIP2 account, the 'Staff userid for SIP2 authentication' field should auto-complete (search) patrons. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 3

[Bug 40802] New: cleanup_database is broken with ChildNeedsGuarantor
by bugzilla-daemon＠bugs.koha-community.org 16 Oct '26

16 Oct '26

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=40802 Bug ID: 40802 Summary: cleanup_database is broken with ChildNeedsGuarantor Change sponsored?: --- Product: Koha Version: Main Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Command-line Utilities Assignee: koha-bugs(a)lists.koha-community.org Reporter: baptiste.wojtkowski(a)biblibre.com QA Contact: testopia(a)bugs.koha-community.org CC: robin(a)catalyst.net.nz Steps to reproduce : 1 - Have a child expired patron expired for more than the content of LockExpiredDelay syspref 2 - Set syspref to "childneedsguarantor" 3 - Run /home/koha/src/misc/cronjobs/cleanup_database.pl You will get an uncaught error -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 4