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

[Bug 17774] New: Acquisitions module getting internal server error when adding orders to basket - a case of barcode not autoincrementing (?)
by bugzilla-daemon＠bugs.koha-community.org 11 Dec '19

11 Dec '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17774 Bug ID: 17774 Summary: Acquisitions module getting internal server error when adding orders to basket - a case of barcode not autoincrementing (?) Change sponsored?: --- Product: Koha Version: 16.11 Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Acquisitions Assignee: koha-bugs(a)lists.koha-community.org Reporter: eugenegf(a)yahoo.com QA Contact: testopia(a)bugs.koha-community.org In a new Koha 16.11 instance, when adding orders to basket with the following system preferences: a) AcqCreateItem = placing an order b) autoBarcode is set to generated in the form <branchcode>yymm0001. c) plack enabled d) 952$o has plugin 'barcode.pl' A barcode is not filled up (just clicked 'Add item' button) during adding of items since it is implicitly stated in the interface: "The autoBarcode system preference is set to hbyymmincr and items with blank barcodes will have barcodes generated upon save to database." However, when the order is being saved, I am getting internal server error. So, I have to click the Back button to go back to what I'm doing. And when I returned to the "add orders to basket" interface, and then click save to finish the transaction, I am able to finish the transaction, however, I now get two items ordered, first one with only the title and the second one has the title and the patron who suggested the material (see http://koha.1045719.n5.nabble.com/file/n5913371/acqui_internal_server_error…) Tried this in another server with same database, however I'm getting "Software error: DBIx::Class::Storage::DBI::_dbh_execute(): Column 'itemnumber' cannot be null at /usr/share/koha/lib/Koha/Acquisition/Order.pm line 68" But when brought to the Basket no., I can see the order. Delving into the plack-error message in the first server: No existing hbyymmincr barcodes found. Reverting to initial value. at /usr/share/koha/lib/C4/Barcodes/hbyymmincr.pm line 62. DBD::mysql::st execute failed: Duplicate entry 'DLSU-D16120002' for key 'itembarcodeidx' [for Statement "INSERT INTO items SET biblionumber = ?, biblioitemnumber = ?, barcode = ?, dateaccessioned = ?, booksellerid = ?, homebranch = ?, price = ?, replacementprice = ?, replacementpricedate = ?, datelastborrowed = ?, datelastseen = ?, stack = ?, notforloan = ?, damaged = ?, itemlost = ?, withdrawn = ?, itemcallnumber = ?, coded_location_qualifier = ?, restricted = ?, itemnotes = ?, itemnotes_nonpublic = ?, holdingbranch = ?, paidfor = ?, location = ?, permanent_location = ?, onloan = ?, issues = ?, renewals = ?, reserves = ?, cn_source = ?, cn_sort = ?, ccode = ?, itype = ?, materials = ?, uri = ?, enumchron = ?, more_subfields_xml = ?, copynumber = ?, stocknumber = ?, new_status = ? " with ParamValues: 0="4911", 1='4911', 2="DLSU-D16120002", 3='2016-12-14', 4=undef, 5="DLSU-D", 6=undef, 7=undef, 8='2016-12-14', 9=undef, 10='2016-12-14', 11=undef, 12=0, 13=0, 14=0, 15=0, 16=undef, 17=undef, 18=undef, 19=undef, 20=undef, 21="DLSU-D", 22=undef, 23=undef, 24=undef, 25=undef, 26=undef, 27=undef, 28=undef, 29="lcc", 30='', 31=undef, 32=undef, 33=undef, 34=undef, 35=undef, 36=undef, 37=undef, 38=undef, 39=undef] at /usr/share/koha/lib/C4/Items.pm line 2119. DBD::mysql::st execute failed: Column 'itemnumber' cannot be null [for Statement "INSERT INTO `aqorders_items` ( `itemnumber`, `ordernumber`) VALUES ( ?, ? )" with ParamValues: 0=undef, 1='45'] at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1832. And the second server's intranet error log snippet: [Wed Dec 14 18:15:55.903548 2016] [cgi:error] [pid 19570] [client 112.198.75.180:54634] AH01215: [Wed Dec 14 18:15:55 2016] addorder.pl: " with ParamValues: 0="4914", 1='4913', 2="DLSU-D16120002", 3='2016-12-14', 4=undef, 5="DLSU-D", 6=undef, 7=undef, 8='2016-12-14', 9=undef, 10='2016-12-14', 11=undef, 12=0, 13=0, 14=0, 15=0, 16=undef, 17=undef, 18=undef, 19=undef, 20=undef, 21="DLSU-D", 22=undef, 23=undef, 24=undef, 25=undef, 26=undef, 27=undef, 28=undef, 29="lcc", 30='', 31=undef, 32=undef, 33=undef, 34=undef, 35=undef, 36=undef, 37=undef, 38=undef, 39=undef] at /usr/share/koha/lib/C4/Items.pm line 2119. I feel that the barcode is not auto-incrementing (but I don't know why it isn't) as I see in the first server the same barcode 'DLSU-D16120002' is showing up several times, and this is supposed to be incremented. I also see that this barcode is already used by another item. A discussion of this is in http://koha.1045719.n5.nabble.com/Acquisitions-module-internal-server-error… -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 5

[Bug 23709] New: Can't add new subfields to bibliographic frameworks
by bugzilla-daemon＠bugs.koha-community.org 11 Dec '19

11 Dec '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23709 Bug ID: 23709 Summary: Can't add new subfields to bibliographic frameworks Change sponsored?: --- Product: Koha Version: 18.11 Hardware: All OS: All Status: NEW Severity: critical Priority: P5 - low Component: Cataloging Assignee: koha-bugs(a)lists.koha-community.org Reporter: corinne.hayet(a)progilone.fr QA Contact: testopia(a)bugs.koha-community.org CC: m.de.rooy(a)rijksmuseum.nl It only works if the subfield is connected to an Authorized values list. I created a subfield 099$m with a link with COUNTRY authorized values list and it's OK But, if I try to create a simple subfield 012$z and I've got the following error in logs : DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`koha`.`marc_subfield_structure`, CONSTRAINT `marc_subfield_structure_ibfk_1` FOREIGN KEY (`authorised_value`) REFERENCES `authorised_value_categories` (`category_name`) ON DELETE SET NULL ON ) [for Statement "INSERT INTO `marc_subfield_structure` ( `authorised_value`, `authtypecode`, `defaultvalue`, `frameworkcode`, `hidden`, `isurl`, `kohafield`, `liblibrarian`, `libopac`, `link`, `mandatory`, `maxlength`, `repeatable`, `seealso`, `tab`, `tagfield`, `tagsubfield`, `value_builder`) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )" with ParamValues: 0="", 1="", 2="", 3="", 4="0", 5=0, 6="", 7="test", 8="test", 9="", 10=0, 11="9999", 12=0, 13=undef, 14="0", 15="013", 16="x", 17=""] at /usr/local/share/perl5/DBIx/Class/Storage/DBI.pm line 1836. Best regards, Corinne -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 10

[Bug 19789] New: Remove some indirect DBIx calls from updatedatabase
by bugzilla-daemon＠bugs.koha-community.org 11 Dec '19

11 Dec '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19789 Bug ID: 19789 Summary: Remove some indirect DBIx calls from updatedatabase Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: koha-bugs(a)lists.koha-community.org Reporter: m.de.rooy(a)rijksmuseum.nl QA Contact: testopia(a)bugs.koha-community.org Triggered by a comment on 19096. What happens when DBIx schema does not match table design? Add a field to schema file that does not exist => Koha::Object->new and store still works, Koha::Objects->search still works but an actual fetch by calling ->next is enough to crash. DBD::mysql::st execute failed: Unknown column 'me.iserniet' in 'field list' Add a field to the table but not to the schema file => Seems to work still Dubious lines in updatedatabase L12389 Koha::SearchEngine::Elasticsearch->reset_elasticsearch_mappings; This includes Koha Objects calls to Koha::SearchFields and Koha::SearchMarcMaps. The sub add_to_search_marc_maps in Koha::SearchField puzzles me. Does this work, why is there no test associated with it ? Any (future) new column in search fields or search marc maps may lead to a crash at 3.23.00.050 L13526 and context: Koha::Number::Price->new( $order->{rrp} )->round; Only new calls seem to be fine. But might be tricky. L14364 and context: Koha::Holds->search({ found => 'W', priority => 0 }); Any future change in reserves table may lead to a crash on the next statement in 16.12.00.032. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 9

[Bug 23184] New: Export/bibs/holdings settings unclear for exporting bibs without any holdings
by bugzilla-daemon＠bugs.koha-community.org 11 Dec '19

11 Dec '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23184 Bug ID: 23184 Summary: Export/bibs/holdings settings unclear for exporting bibs without any holdings Change sponsored?: --- Product: Koha Version: 18.11 Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Tools Assignee: koha-bugs(a)lists.koha-community.org Reporter: bwsdonna(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org Target Milestone: --- By default, Koha will not export bibs without items as the "owned by libraries" check boxes are selected. This is unclear to users. If I upload a file of bibs to export, and don't uncheck the library boxes, the resulting mrc file will only contain records that have items, all bib records without items will not be included. The check boxes should either be empty by default, or a clarification note should be added stating that itemless bibs will not be exported. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 17

[Bug 22677] New: Include hint on OAI-PMH URL for Koha in system preference
by bugzilla-daemon＠bugs.koha-community.org 10 Dec '19

10 Dec '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22677 Bug ID: 22677 Summary: Include hint on OAI-PMH URL for Koha in system preference Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Keywords: Academy Severity: enhancement Priority: P5 - low Component: Web services Assignee: koha-bugs(a)lists.koha-community.org Reporter: katrin.fischer(a)bsz-bw.de QA Contact: testopia(a)bugs.koha-community.org Target Milestone: --- We should include a link to the right URL like we do for other things like ILS-DI and Self checkout in the description of the OAI-PMH system preference. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 17

[Bug 22923] New: Items search does not take care of independent branches
by bugzilla-daemon＠bugs.koha-community.org 10 Dec '19

10 Dec '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22923 Bug ID: 22923 Summary: Items search does not take care of independent branches Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: Searching Assignee: koha-bugs(a)lists.koha-community.org Reporter: fridolin.somers(a)biblibre.com QA Contact: testopia(a)bugs.koha-community.org Target Milestone: --- Items search /cgi-bin/koha/catalogue/itemsearch.pl should be impacted by preference IndependentBranches. Maybe it should automatically limit to current branch. Main problem is that actually its a way to edit items of other branches. Maybe there should also be a check in cataloguing/additem.pl itself. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 11

[Bug 20493] New: SIP2 sending blank Title Identifier and Due date while Renew the books through Selfcheck
by bugzilla-daemon＠bugs.koha-community.org 10 Dec '19

10 Dec '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20493 Bug ID: 20493 Summary: SIP2 sending blank Title Identifier and Due date while Renew the books through Selfcheck Change sponsored?: --- Product: Koha Version: 17.05 Hardware: PC OS: Windows Status: NEW Severity: critical Priority: P5 - low Component: SIP2 Assignee: koha-bugs(a)lists.koha-community.org Reporter: aniltiwari86(a)hotmail.com QA Contact: testopia(a)bugs.koha-community.org CC: colin.campbell(a)ptfs-europe.com Created attachment 73418 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=73418&action=ed… SIP2 Logs Hi, When we are renewing the books through Selfcheck Unit, the SIP2 is not sending the Item Identifier and Due Date, and because of this the Patrons are getting Item not checked out message. can you please look in to this. Parsing: 300NUN20180326 142806AAPSPHPS170013|AB104059|AJ|AH|AOMAIN|AFItem not checked out to SOUMITRA MIDYA|AY3AZE1C5 2018-03-26 14:27:44,123 INFO [ 7] MessageFormatter - Parsed: [30] Renew Response {ok = 0, renewal ok = False, magnetic media = null, desensitize = False, transaction date = 2018-03-26 14:28:06, [AA] patron identifier = #d587bf42, [AB] item identifier = "104059", [AJ] title identifier = "", [AH] due date = "", [AO] institution id = "MAIN", [AF] screen message = "Item not checked out to SOUMITRA MIDYA"} 2018-03-26 14:27:44,123 DEBUG [ 7] SipCirculationProvider - Duration of operation: 77 ms SIP Logs attached for your reference. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 3

[Bug 21486] New: SIP does not return checked out (charged) items on patron_information request
by bugzilla-daemon＠bugs.koha-community.org 10 Dec '19

10 Dec '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21486 Bug ID: 21486 Summary: SIP does not return checked out (charged) items on patron_information request Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: SIP2 Assignee: koha-bugs(a)lists.koha-community.org Reporter: josef.moravec(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org CC: colin.campbell(a)ptfs-europe.com You can test it with this: misc/sip_cli_emulator.pl -a localhost -p 6001 -su koha -sp koha -l CPL --patron 23529000126806 -s " Y " -m patron_information And see the "AU" field is empty: 64 00120181004 110729000000000001000000000000AOCPL|AA23529000126806|AEBrent Hopkins|BLY|CC5|AU|BD6692 Library Rd. Santa Cruz, CA 21234|BF(212) 555-1212|PB19771113|PCT|PIY|AFGreetings from Koha. | This is because commit bc001c2352fee419a2bbe20c0cf707afd9e5bd78 Bug 19935: Replace GetPendingIssues - SIP -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 39

[Bug 24117] New: Patron does not get debarred upon returning overdue item if syspref item-level_itypes is set to biblio and item does not have type information
by bugzilla-daemon＠bugs.koha-community.org 10 Dec '19

10 Dec '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24117 Bug ID: 24117 Summary: Patron does not get debarred upon returning overdue item if syspref item-level_itypes is set to biblio and item does not have type information Change sponsored?: --- Product: Koha Version: 19.05 Hardware: All OS: All Status: NEW Severity: minor Priority: P5 - low Component: Circulation Assignee: koha-bugs(a)lists.koha-community.org Reporter: pjamorim91(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com To reproduce: 1) Have item-level_itypes sys pref set to "biblio" 2) Return an overdue item which biblio record has correct type information but item itself does not (which should be fine because 1)) 3) Notice that the item is returned just fine, but the patron does not get debarred, respecting circulation rules correctly configured. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 7

[Bug 23029] New: OPAC Authorities Search. Internal Server Error. Free-floating subdivisions imported from LOC
by bugzilla-daemon＠bugs.koha-community.org 07 Dec '19

07 Dec '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23029 Bug ID: 23029 Summary: OPAC Authorities Search. Internal Server Error. Free-floating subdivisions imported from LOC Change sponsored?: --- Product: Koha Version: 18.11 Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Searching Assignee: koha-bugs(a)lists.koha-community.org Reporter: cbutosi(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org Target Milestone: --- Koha 18.11 on Ubuntu 16.04 (MariaDb) with Plack. ================================================ I recently discovered that the Library of Congress released their 2014 authorities as a free, open-access dataset in Marc8, xml, and Utf8 formats. This is great! (https://www.loc.gov/cds/products/MDSConnect-subject_authorities.html) I have completed batch uploading the file successfully into Koha (about 320,000 records) and reindexed Zebra. Part of the authority file includes free-floating subdivisions, identified by the presence of a MARC21 authority tag 180. I discovered an "Internal Server Error" page if I attempted to click on the Details button of any of these sub-divisions' records in the OPAC authority browse results page. My Plack error log reported the following error each time I attempted to access the authorities details page from the OPAC: "Can't call method "authtypetext" on an undefined value at /usr/share/koha/opac/cgi-bin/opac/opac-authoritiesdetail.pl line 89." I corrected this error by creating a new Authority Type using the pre-populated value found in field 942 within these free-floating subdivision records (i.e., "GEN_SUBDIV") and assigning tag 180 as the "authority field to copy" Once created, I was able to access the OPAC details page, as expected, and all free-floating subdivisions were re-indexed as free-floating subdivisions. They also became selectable as an authority type from the drop-down menu in the Authority Search. For a detailed explanation of the above, see: http://craigbutosi.ca/2019/05/31/plack-error-authority-file-free-floating-s… The Authority Type GEN_SUBDIV should be defined in order to prevent the Plack error from occurring. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 8