October 2020 - Koha-bugs - lists.koha-community.org

[Bug 23585] New: Hide Item Information tab when adding to basket from file without creating items
by bugzilla-daemon＠bugs.koha-community.org 16 Dec '22

16 Dec '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23585 Bug ID: 23585 Summary: Hide Item Information tab when adding to basket from file without creating items Change sponsored?: --- Product: Koha Version: 19.05 Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Acquisitions Assignee: koha-bugs(a)lists.koha-community.org Reporter: andrew(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org To Test: - Create a basket set to create items either at receiving or at cataloging - Add to basket from a MARC file - On addorderiso2709.pl, observe that the Item Information tab is present but only contains the words "Import all the checked items in the basket with the following parameters:" with no additional content It makes sense that we can't enter anything else here -- we're not creating items and therefore don't have anything to enter. But it would be less confusing to just hide this tab entirely. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 2

[Bug 26648] New: Prevent internal server error if item attached to old checkout has been removed
by bugzilla-daemon＠bugs.koha-community.org 14 Dec '22

14 Dec '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26648 Bug ID: 26648 Summary: Prevent internal server error if item attached to old checkout has been removed Change sponsored?: --- Product: Koha Version: master 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: martin.renvoize(a)ptfs-europe.com QA Contact: testopia(a)bugs.koha-community.org Whilst playing with notices to see if we could calculate a running total of savings for a library user to add to their issueslip notice I found that if an item relating to an old checkout has been deleted, then the relation accessor can explode -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 30

[Bug 24971] New: Select invoice currency from vendor on receive
by bugzilla-daemon＠bugs.koha-community.org 13 Dec '22

13 Dec '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24971 Bug ID: 24971 Summary: Select invoice currency from vendor on receive Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Acquisitions Assignee: koha-bugs(a)lists.koha-community.org Reporter: katrin.fischer(a)bsz-bw.de QA Contact: testopia(a)bugs.koha-community.org Depends on: 24158 With the new feature from bug 24158 you can enter the price of the items you receive in a different currency than your active one. At the moment, the currency pull down preselects the active currency. I think it would be a nice enhancement to select it to the currency from the vendor for 'invoice prices'. At the moment, it appears this setting has no effect, but this way it would have a useful purpose. Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24158 [Bug 24158] Receive items in multiple currencies -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 4

[Bug 26860] New: Add search limit for records without items
by bugzilla-daemon＠bugs.koha-community.org 12 Dec '22

12 Dec '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26860 Bug ID: 26860 Summary: Add search limit for records without items Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement 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 May libraries ask for a way to search biblio records without items. In order to clean the catalogue or acquire items. I propose to add a search limit and facet. Only in staff interface for start. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 46

[Bug 16261] New: System preference noissuecharge should take account of the amount "greater than or equal to"
by bugzilla-daemon＠bugs.koha-community.org 12 Dec '22

12 Dec '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16261 Bug ID: 16261 Summary: System preference noissuecharge should take account of the amount "greater than or equal to" Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: System Administration Assignee: koha-bugs(a)lists.koha-community.org Reporter: marjorie.barry-vila(a)ccsr.qc.ca QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com Hi, Noissuecharge takes into account the amounts of fines "greater than" to what is written in the preference system. Example: noissuecharge filled with 5 Patron has $ 5 in fines, it will not be blocked to check-out. We have to write 4.99 to block patron with 5 $ in fines. Noissuecharge should take account of the amount "greater than or equal to" Regards, Marjorie -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 2

[Bug 19008] New: More database cleanups
by bugzilla-daemon＠bugs.koha-community.org 09 Dec '22

09 Dec '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19008 Bug ID: 19008 Summary: More database cleanups Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Command-line Utilities Assignee: koha-bugs(a)lists.koha-community.org Reporter: fridolin.somers(a)biblibre.com QA Contact: testopia(a)bugs.koha-community.org CC: robin(a)catalyst.net.nz misc/cronjobs/cleanup_database.pl provides some database cleanup. Yet some tables that could need cleanup are not in this script. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 85

[Bug 20078] New: Indexes 'arl' (Accelerated reading level) and 'arp' (Accelerated reading point) not usable in search menus.
by bugzilla-daemon＠bugs.koha-community.org 07 Dec '22

07 Dec '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20078 Bug ID: 20078 Summary: Indexes 'arl' (Accelerated reading level) and 'arp' (Accelerated reading point) not usable in search menus. Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Searching - Zebra Assignee: koha-bugs(a)lists.koha-community.org Reporter: barton(a)bywatersolutions.com The indexes 'arl' (Accelerated reading level) and 'arp' (Accelerated reading point) are not listed in C4::Search::getIndexes, and therefore cannot be used in the koha drop down menus. To re-create: Find a bib with 526$c and 526$d populated, e.g. +---------------+--------------+-------------+-------------+ | title | biblionumber | 526$c (arl) | 526$d (arp) | +---------------+--------------+-------------+-------------+ | Star flight / | 1347 | 5.5 | 14 | +---------------+--------------+-------------+-------------+ Entering the following in the search bar works: arl:5.5 as does arp:14 However entering the following in intranetuserjs: $(document).ready(function(){ // Add Accelerated Reading Level to advanced search if (window.location.href.indexOf("catalogue/search.pl") > -1) { $(".advsearch").append('<option value="arl">Accelerated Reading Level</option>'); } // Add Accelerated Reading Point to advanced search if (window.location.href.indexOf("catalogue/search.pl") > -1) { $(".advsearch").append('<option value="arp">Accelerated Reading Point</option>'); } }); Then running an advanced search using the respective values of Accelerated Reading Level and Accelerated Reading Point will fail. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 20

[Bug 18309] New: UNIMARC update from IFLA
by bugzilla-daemon＠bugs.koha-community.org 07 Dec '22

07 Dec '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18309 Bug ID: 18309 Summary: UNIMARC update from IFLA Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: MARC Bibliographic data support Assignee: gmcharlt(a)gmail.com Reporter: fridolin.somers(a)biblibre.com QA Contact: testopia(a)bugs.koha-community.org IFLA Federation published new recommendations for UNIMARC standard. Will impact pré-installed biblio and authorities frameworks. -- You are receiving this mail because: You are watching all bug changes.

1 183

[Bug 19963] New: ethnicity and ethnicity tables and columns survived update
by bugzilla-daemon＠bugs.koha-community.org 07 Dec '22

07 Dec '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19963 Bug ID: 19963 Summary: ethnicity and ethnicity tables and columns survived update Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: minor Priority: P5 - low Component: Database Assignee: koha-bugs(a)lists.koha-community.org Reporter: katrin.fischer(a)bsz-bw.de QA Contact: testopia(a)bugs.koha-community.org The database update for 3.21.00.033 should have removed the ethnicity table and the ethnicity and ethnotes columns from borrowers, deletedborrowers and borrower_modifications. This didn't work right in all cases. I just noticed that all those survived in our older databases. The reason is that the database update only checked for NULL when counting existing data, but not for "": 11054 $DBversion = "3.21.00.033"; 11055 if ( CheckVersion($DBversion) ) { 11056 11057 my $done = 0; 11058 my $count_ethnicity = $dbh->selectrow_arrayref(q| 11059 SELECT COUNT(*) FROM ethnicity 11060 |); 11061 my $count_borrower_modifications = $dbh->selectrow_arrayref(q| 11062 SELECT COUNT(*) 11063 FROM borrower_modifications 11064 WHERE ethnicity IS NOT NULL 11065 OR ethnotes IS NOT NULL 11066 |); 11067 my $count_borrowers = $dbh->selectrow_arrayref(q| 11068 SELECT COUNT(*) 11069 FROM borrowers 11070 WHERE ethnicity IS NOT NULL 11071 OR ethnotes IS NOT NULL 11072 |); 11073 # We don't care about the ethnicity of the deleted borrowers, right? 11074 if ( $count_ethnicity->[0] == 0 11075 and $count_borrower_modifications->[0] == 0 11076 and $count_borrowers->[0] == 0 11077 ) { 11078 $dbh->do(q| 11079 DROP TABLE ethnicity 11080 |); 11081 $dbh->do(q| 11082 ALTER TABLE borrower_modifications 11083 DROP COLUMN ethnicity, 11084 DROP COLUMN ethnotes 11085 |); 11086 $dbh->do(q| 11087 ALTER TABLE borrowers 11088 DROP COLUMN ethnicity, 11089 DROP COLUMN ethnotes 11090 |); 11091 $dbh->do(q| 11092 ALTER TABLE deletedborrowers 11093 DROP COLUMN ethnicity, 11094 DROP COLUMN ethnotes 11095 |); 11096 $done = 1; 11097 } 11098 if ( $done ) { 11099 print "Upgrade to $DBversion done (Bug 10020: Drop table ethnicity and columns ethnicity and ethnotes)\n"; 11100 } 11101 else { 11102 print "Upgrade to $DBversion done (Bug 10020: This database contains data related to 'ethnicity'. No change will be done on the DB structure but note that the Koha codebase does not use it)\n"; 11103 } 11104 11105 SetVersion ($DBversion); -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 4

[Bug 20591] New: DBI->last_insert_id does not work as expected
by bugzilla-daemon＠bugs.koha-community.org 06 Dec '22

06 Dec '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20591 Bug ID: 20591 Summary: DBI->last_insert_id does not work as expected Change sponsored?: --- Product: Koha Version: unspecified 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: jonathan.druart(a)bugs.koha-community.org QA Contact: testopia(a)bugs.koha-community.org Try the following code: use Koha::Database; use Koha::Cities; use Koha::AuthorisedValues; my $schema = Koha::Database->schema; $schema->storage->txn_begin; my $dbh = C4::Context->dbh; my $city = Koha::City->new({ city_name => 'name' })->store; say $city->cityid; say $dbh->last_insert_id( undef, undef, 'cities', undef ); say $dbh->last_insert_id( undef, undef, 'not_exist', undef ); say "==="; my $av = Koha::AuthorisedValue->new({category => 'LOC', authorised_value => 'just_a_test'})->store; say $av->id; say $dbh->last_insert_id( undef, undef, 'authorised_values', undef ); say $dbh->last_insert_id( undef, undef, 'cities', undef ); say $dbh->last_insert_id( undef, undef, 'not_exist', undef ); It will display: 12 12 12 === 401 401 401 401 -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 7