May 2019 - Koha-bugs - lists.koha-community.org

[Bug 22879] New: Cannot reindex elastic
by bugzilla-daemon＠bugs.koha-community.org 12 May '19

12 May '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22879 Bug ID: 22879 Summary: Cannot reindex elastic Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: blocker Priority: P5 - low Component: Searching - Elasticsearch Assignee: koha-bugs(a)lists.koha-community.org Reporter: jonathan.druart(a)bugs.koha-community.org Target Milestone: --- kohadev-koha@kohadevbox:/home/vagrant/kohaclone$ perl -MCarp::Always misc/search_tools/rebuild_elastic_search.pl -d -a -b No record passed at /home/vagrant/kohaclone/Koha/MetadataRecord.pm line 82. Koha::MetadataRecord::new("Koha::BiblioUtils", HASH(0x55ee0f6a58f8)) called at /home/vagrant/kohaclone/Koha/BiblioUtils.pm line 62 Koha::BiblioUtils::new("Koha::BiblioUtils", undef, 647) called at /home/vagrant/kohaclone/Koha/BiblioUtils.pm line 128 eval {...} called at /home/vagrant/kohaclone/Koha/BiblioUtils.pm line 127 Koha::BiblioUtils::__ANON__() called at /home/vagrant/kohaclone/Koha/MetadataIterator.pm line 71 Koha::MetadataIterator::next(Koha::MetadataIterator=HASH(0x55ee0c8d4278)) called at misc/search_tools/rebuild_elastic_search.pl line 137 main::__ANON__() called at misc/search_tools/rebuild_elastic_search.pl line 182 main::do_reindex(CODE(0x55ee0c8cc380), "biblios") called at /home/vagrant/kohaclone/Koha/MetadataRecord.pm line 82. Koha::MetadataRecord::new("Koha::BiblioUtils", HASH(0x55ee0f6a58f8)) called at /home/vagrant/kohaclone/Koha/BiblioUtils.pm line 62 Koha::BiblioUtils::new("Koha::BiblioUtils", undef, 647) called at /home/vagrant/kohaclone/Koha/BiblioUtils.pm line 128 eval {...} called at /home/vagrant/kohaclone/Koha/BiblioUtils.pm line 127 Koha::BiblioUtils::__ANON__() called at /home/vagrant/kohaclone/Koha/MetadataIterator.pm line 71 Koha::MetadataIterator::next(Koha::MetadataIterator=HASH(0x55ee0c8d4278)) called at misc/search_tools/rebuild_elastic_search.pl line 137 main::__ANON__() called at misc/search_tools/rebuild_elastic_search.pl line 182 main::do_reindex(CODE(0x55ee0c8cc380), "biblios") called at misc/search_tools/rebuild_elastic_search.pl line 140 Something went wrong reading record for biblio Koha::Schema::Result::Biblio=HASH(0x55ee0f686228)->biblionumber: Can't bless non-reference value at /home/vagrant/kohaclone/Koha/BiblioUtils.pm line 70. Koha::BiblioUtils::new("Koha::BiblioUtils", undef, 647) called at /home/vagrant/kohaclone/Koha/BiblioUtils.pm line 128 eval {...} called at /home/vagrant/kohaclone/Koha/BiblioUtils.pm line 127 Koha::BiblioUtils::__ANON__() called at /home/vagrant/kohaclone/Koha/MetadataIterator.pm line 71 Koha::MetadataIterator::next(Koha::MetadataIterator=HASH(0x55ee0c8d4278)) called at misc/search_tools/rebuild_elastic_search.pl line 137 main::__ANON__() called at misc/search_tools/rebuild_elastic_search.pl line 182 main::do_reindex(CODE(0x55ee0c8cc380), "biblios") called at /home/vagrant/kohaclone/Koha/BiblioUtils.pm line 131. Koha::BiblioUtils::__ANON__() called at /home/vagrant/kohaclone/Koha/MetadataIterator.pm line 71 Koha::MetadataIterator::next(Koha::MetadataIterator=HASH(0x55ee0c8d4278)) called at misc/search_tools/rebuild_elastic_search.pl line 137 main::__ANON__() called at misc/search_tools/rebuild_elastic_search.pl line 182 main::do_reindex(CODE(0x55ee0c8cc380), "biblios") called at misc/search_tools/rebuild_elastic_search.pl line 140 -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 8

[Bug 22869] New: Can't use an undefined value as an ARRAY reference at /usr/lib/x86_64-linux-gnu/perl5/5.26/DBI.pm line 2081.
by bugzilla-daemon＠bugs.koha-community.org 12 May '19

12 May '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22869 Bug ID: 22869 Summary: Can't use an undefined value as an ARRAY reference at /usr/lib/x86_64-linux-gnu/perl5/5.26/DBI.pm line 2081. Change sponsored?: --- Product: Koha Version: 18.11 Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Acquisitions Assignee: koha-bugs(a)lists.koha-community.org Reporter: ata.rehman(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org Target Milestone: --- Created attachment 89479 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=89479&action=ed… Screen before searching a term I got the above mentioned error while search or add new vendor in acquisition module in Koha 18.11.05 on Linux Ubuntu 18.04 LTS. I updated my database from an old version of koha and this error is new after up-gradation. Note: Migration was normal without any error. When I look into log files, I see the following entries: [Thu May 09 01:31:31.751639 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: DBD::mysql::st execute failed: Out of sort memory, consider increasing server sort buffer size [for Statement ": /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.752809 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: SELECT aqbasket.basketno, aqbasket.basketname, aqbasket.note, aqbasket.booksellernote, aqbasket.contractnumber, aqbasket.creationdate, aqbasket.closedate, aqbasket.booksellerid, aqbasket.authorisedby, aqbasket.booksellerinvoicenumber, aqbasket.basketgroupid, aqbasket.deliveryplace, aqbasket.billingplace, aqbasket.branch, aqbasket.is_standing, aqbasket.create_items,: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.753108 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: SUM(aqorders.quantity) AS total_items,: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.753281 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: SUM(: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.753555 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: IF ( aqorders.orderstatus = 'cancelled', aqorders.quantity, 0 ): /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.753784 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: ) AS total_items_cancelled,: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.754027 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: COUNT(DISTINCT aqorders.biblionumber) AS total_biblios,: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.754164 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: SUM(: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.754361 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: IF(aqorders.datereceived IS NULL: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.754741 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: AND (aqorders.datecancellationprinted IS NULL OR aqorders.datecancellationprinted='0000-00-00'): /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.754920 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: , aqorders.quantity: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.755064 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: , 0): /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.755235 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: ) AS expected_items: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.755404 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: FROM aqbasket: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.755786 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: LEFT JOIN aqorders ON aqorders.basketno = aqbasket.basketno: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.756914 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: WHERE booksellerid = ? GROUP BY aqbasket.basketno, aqbasket.basketname, aqbasket.note, aqbasket.booksellernote, aqbasket.contractnumber, aqbasket.creationdate, aqbasket.closedate, aqbasket.booksellerid, aqbasket.authorisedby, aqbasket.booksellerinvoicenumber, aqbasket.basketgroupid, aqbasket.deliveryplace, aqbasket.billingplace, aqbasket.branch, aqbasket.is_standing, aqbasket.create_items HAVING (closedate IS NULL OR (: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.757067 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: SUM(: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.757268 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: IF(aqorders.datereceived IS NULL: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.757644 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: AND (aqorders.datecancellationprinted IS NULL OR aqorders.datecancellationprinted='0000-00-00'): /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.757851 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: , aqorders.quantity: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.757993 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: , 0): /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.762276 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: ) > 0))" with ParamValues: 0=1] at /usr/share/koha/lib/C4/Acquisition.pm line 705.: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.762667 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: Can't use an undefined value as an ARRAY reference at /usr/lib/x86_64-linux-gnu/perl5/5.26/DBI.pm line 2081.: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 1

[Bug 16899] New: Add ability to disallow overpayments
by bugzilla-daemon＠bugs.koha-community.org 12 May '19

12 May '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16899 Bug ID: 16899 Summary: Add ability to disallow overpayments Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: SIP2 Assignee: koha-bugs(a)lists.koha-community.org Reporter: kyle(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org CC: colin.campbell(a)ptfs-europe.com Some SIP services ( such as Comprise ) require that an attempt at over-paying a patron's account via SIP2 should fail, rather than create a credit on the account. We should make this a configurable option on a per-login basis in the SIP2 config file. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 28

[Bug 14364] Allow automatically canceled expired waiting holds to fill the next hold
by bugzilla-daemon＠bugs.koha-community.org 12 May '19

12 May '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14364 --- Comment #35 from Claudio <costalc(a)gmail.com> --- Many thanks Katrin. What a pity... -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 14364] Allow automatically canceled expired waiting holds to fill the next hold
by bugzilla-daemon＠bugs.koha-community.org 12 May '19

12 May '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14364 --- Comment #34 from Katrin Fischer <katrin.fischer(a)bsz-bw.de> --- Hi Claudio, we have reached 'feature freeze' - this means no new features will be pushed for 19.05 apart from a select few that the RM has marked with rel_19_05_candidate. See here: http://lists.koha-community.org/pipermail/koha-devel/2019-April/045179.html So chances are rather slim right now. -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 14364] Allow automatically canceled expired waiting holds to fill the next hold
by bugzilla-daemon＠bugs.koha-community.org 11 May '19

11 May '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14364 --- Comment #33 from Claudio <costalc(a)gmail.com> --- Any chance to have it in 19.05? -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 21940] New: Query parameters of the form <<in "foo">> return no results.
by bugzilla-daemon＠bugs.koha-community.org 11 May '19

11 May '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21940 Bug ID: 21940 Summary: Query parameters of the form <<in "foo">> return no results. Change sponsored?: --- Product: Koha Version: 18.05 Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Reports Assignee: koha-bugs(a)lists.koha-community.org Reporter: barton(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org Running the following report select cardnumber, firstname, surname, categorycode from borrowers where categorycode = <<in "s">> returns no results. Inspecting 'Show SQL' reveals select cardnumber, firstname, surname, categorycode from borrowers where categorycode = NULL however where categorycode = <<in s>> and where categorycode = <<"s">> both work. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 2

[Bug 13094] Make it easy to hide 'Cancel all' button on holds over report
by bugzilla-daemon＠bugs.koha-community.org 11 May '19

11 May '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13094 Katrin Fischer <katrin.fischer(a)bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Keywords| |Academy --- Comment #5 from Katrin Fischer <katrin.fischer(a)bsz-bw.de> --- Rebased! -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 13094] Make it easy to hide 'Cancel all' button on holds over report
by bugzilla-daemon＠bugs.koha-community.org 11 May '19

11 May '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13094 Katrin Fischer <katrin.fischer(a)bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #86494|0 |1 is obsolete| | --- Comment #4 from Katrin Fischer <katrin.fischer(a)bsz-bw.de> --- Created attachment 89621 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=89621&action=ed… Bug 13094: Make it easy to hide 'Cancel all' button on holds over report This patch makes some small modifications to the 'Holds awaiting pickup' report: - Fixes typo sypref - Fixes 'Home branch' to 'Home library' - Adds a span to easily hide the cancel all button with CSS To test: - Make sure you have a hold appearing on the awaiting pickup list second tab: Holds waiting over... - Verify the 'cancel all' button on top shows - Verify syspref and Home library changes mentioned above - Add #holdsover-cancel-all { display:none; } to IntrentUserCSS - Verify that the button and the text have vanished Note: If the text doesn't display next to the button, try toggling the TransferWhenCancelAllWaitingHolds system preference. -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 14669] Search orders by managing library
by bugzilla-daemon＠bugs.koha-community.org 11 May '19

11 May '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14669 --- Comment #4 from Katrin Fischer <katrin.fischer(a)bsz-bw.de> --- Rebased and fixed authorship (me, not kohadev-koha!) -- You are receiving this mail because: You are watching all bug changes.

1 0