January 2022 - Koha-bugs - lists.koha-community.org

[Bug 28698] New: News for all displays in all locations
by bugzilla-daemon＠bugs.koha-community.org 31 Jan '22

31 Jan '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28698 Bug ID: 28698 Summary: News for all displays in all locations Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: OPAC Assignee: oleonard(a)myacpl.org Reporter: fridolin.somers(a)biblibre.com QA Contact: testopia(a)bugs.koha-community.org Some news are used for custom text with a specific language, for example "opacheader". The bug is that in these locations, news for all (staff and opac) are displayed. This is because GetNewsToDisplay uses SQL : opac_news.lang = '' OR opac_news.lang = ? -- You are receiving this mail because: You are watching all bug changes.

1 24

[Bug 29437] New: 500 error when performing a catalog search for an ISBN13 with no valid ISBN10
by bugzilla-daemon＠bugs.koha-community.org 31 Jan '22

31 Jan '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29437 Bug ID: 29437 Summary: 500 error when performing a catalog search for an ISBN13 with no valid ISBN10 Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Cataloging Assignee: koha-bugs(a)lists.koha-community.org Reporter: nick(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org CC: m.de.rooy(a)rijksmuseum.nl When performing a cataloging search we take the query and test to see if it is a valid isbn: If not, we perform a SQL search for the term as author or title If so, we pass it to BreedingSearch as an ISBN - we then normailize it to ISBN 10 - then perform aSQL search for ISBN In the ISBN case, if it cannot be converted to a 10 digit ISBN we nullify the term - the SQL then has no where statement and fails in plack-error.log: C4::Breeding::BreedingSearch(): DBI Exception: DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 5 at /kohadevbox/koha/cataloguing/addbooks.pl line 117 -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 35

[Bug 29319] New: Errors when doing a cataloging search which starts with a number + letter
by bugzilla-daemon＠bugs.koha-community.org 31 Jan '22

31 Jan '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29319 Bug ID: 29319 Summary: Errors when doing a cataloging search which starts with a number + letter Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Cataloging Assignee: koha-bugs(a)lists.koha-community.org Reporter: lucas(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org CC: m.de.rooy(a)rijksmuseum.nl To recreate: Go to addbooks.pl and try a catalog search that starts with a number like 3rd degree, 7th heaven, or 6th target. The searches will result in an ugly error page and the following in the error logs: C4::Breeding::BreedingSearch(): DBI Exception: DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 5 at /kohadevbox/koha/cataloguing/addbooks.pl line 123 at /usr/share/perl5/DBIx/Class/Exception.pm line 77 DBIx::Class::Exception::throw('DBIx::Class::Exception', 'DBI Exception: DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near \'\' at line 5', 0) called at /usr/share/perl5/DBIx/Class/Schema.pm line 1118 DBIx::Class::Schema::throw_exception('Koha::Schema=HASH(0x560206b40608)', 'DBI Exception: DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near \'\' at line 5') called at /usr/share/perl5/DBIx/Class/Storage.pm line 113 DBIx::Class::Storage::throw_exception('DBIx::Class::Storage::DBI::mysql=HASH(0x560206d0e768)', 'DBI Exception: DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near \'\' at line 5') called at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1501 DBIx::Class::Storage::DBI::__ANON__('DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near \'\' at line 5', 'DBI::st=HASH(0x56020b84bbe8)', undef) called at /kohadevbox/koha/C4/Breeding.pm line 99 C4::Breeding::BreedingSearch(undef, '7th heaven') called at /kohadevbox/koha/cataloguing/addbooks.pl line 123 eval {...} at /kohadevbox/koha/cataloguing/addbooks.pl line 2 Note: If I search for something like '33rd Heaven', 77th target, I get no error -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 25

[Bug 7911] Greater flexibility in auto barcode number generation
by bugzilla-daemon＠bugs.koha-community.org 31 Jan '22

31 Jan '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7911 Emmi Takkinen <emmi.takkinen(a)koha-suomi.fi> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |emmi.takkinen(a)koha-suomi.fi -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 28472] New: UpdateItemLocationOnCheckin not updating items where location is null
by bugzilla-daemon＠bugs.koha-community.org 31 Jan '22

31 Jan '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28472 Bug ID: 28472 Summary: UpdateItemLocationOnCheckin not updating items where location is null Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Staff Client Assignee: koha-bugs(a)lists.koha-community.org Reporter: andrew(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com UpdateItemLocationOnCheckin can be set to update ALL items at checkin. But that ALL is excluding items where location is null. To recreate: - have a location CART - in UpdateItemLocationOnCheckin, enter "_ALL_: CART" - find an item with a shelving location, check it in, confirm it changes to CART - find an item with a NULL shelving location, check it in, confirm it doesn't go to CART -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 33

[Bug 14576] Allow automatic update of location on checkin
by bugzilla-daemon＠bugs.koha-community.org 31 Jan '22

31 Jan '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14576 Marcel de Rooy <m.de.rooy(a)rijksmuseum.nl> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |https://bugs.koha-community | |.org/bugzilla3/show_bug.cgi | |?id=28472 --- Comment #156 from Marcel de Rooy <m.de.rooy(a)rijksmuseum.nl> --- (In reply to Marcel de Rooy from comment #155) > Somewhere an extra defined test on item->location has been introduced to > this feature, which effectively causes location NULL items to be skipped > from marking them with CART. > Probably only with the good intention to remove a warn, but adding this > side-effect. This has been fixed on bug 28472 -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 29981] New: AddReturn does not set CART when items.location is NULL
by bugzilla-daemon＠bugs.koha-community.org 31 Jan '22

31 Jan '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29981 Bug ID: 29981 Summary: AddReturn does not set CART when items.location is NULL Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: Circulation Assignee: koha-bugs(a)lists.koha-community.org Reporter: m.de.rooy(a)rijksmuseum.nl QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com This is a regression somewhere between bug 14576 and current master 21.12. Probably originating from trying to resolve a warn on the NULL value. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 5

[Bug 29284] New: Koha dies when an analytics search fails in Elasticsearch
by bugzilla-daemon＠bugs.koha-community.org 31 Jan '22

31 Jan '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29284 Bug ID: 29284 Summary: Koha dies when an analytics search fails in Elasticsearch Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: Searching - Elasticsearch Assignee: koha-bugs(a)lists.koha-community.org Reporter: nick(a)bywatersolutions.com Bug 28316 added some escaping of reserved ES characters, bug 28484 used the escaping on detail pages, however, it seems there may still be combinations that break the search. We should prevent a failure when loading these records To recreate: 1 - Add a title to catalog, with 245a: Digger does it all (not really!) 2 - Set searchEngine preference to: Elasticsearch 3 - The record does not load -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 22

[Bug 15201] Managing serial numbering patterns requires full serials module permissions
by bugzilla-daemon＠bugs.koha-community.org 30 Jan '22

30 Jan '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15201 Katrin Fischer <katrin.fischer(a)bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |DUPLICATE Status|NEW |RESOLVED --- Comment #1 from Katrin Fischer <katrin.fischer(a)bsz-bw.de> --- *** This bug has been marked as a duplicate of bug 29608 *** -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 0

[Bug 29977] New: Want To Know How Can Someone Hack Your Cash App With Your Name
by bugzilla-daemon＠bugs.koha-community.org 30 Jan '22

30 Jan '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29977 Bug ID: 29977 Summary: Want To Know How Can Someone Hack Your Cash App With Your Name Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: koha-bugs(a)lists.koha-community.org Reporter: kevinwilliams.kevin11(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org If you are looking to be aware of the right source of information about how Can Someone Hack Your Cash App With Your Name, you need to simply get in touch with Cash App professionals who will provide you with the one-stop solution and get your account protected in every possible manner. https://www.digitalworldsupport.com/can-someone-hack-your-cash-app-with-jus… -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 1