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

[Bug 17292] New: Use of DBIx in updatedatabase.pl broke upgrade ( from bug 8956)
by bugzilla-daemon＠bugs.koha-community.org 11 Dec '17

11 Dec '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17292 Bug ID: 17292 Summary: Use of DBIx in updatedatabase.pl broke upgrade (from bug 8956) Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: Installation and upgrade (command-line installer) Assignee: gmcharlt(a)gmail.com Reporter: tomascohen(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org -- You are receiving this mail because: You are watching all bug changes.

1 23

[Bug 19651] New: SIP/ILS/Item missing title
by bugzilla-daemon＠bugs.koha-community.org 11 Dec '17

11 Dec '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19651 Bug ID: 19651 Summary: SIP/ILS/Item missing title 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: stefan.berndtsson(a)ub.gu.se QA Contact: testopia(a)bugs.koha-community.org CC: colin.campbell(a)ptfs-europe.com In 17.05 of C4/SIP/ILS/Item.pm (sub new) $item is fetched via GetBiblioFromItemNumber(). I assume this means that "title" was available as a property on the $item object. In master however, $item is fetched using Koha::Item->find() which means it is a pure Item object, and does not contain biblio data. $item->{title} is therefor lost. The "title" property has to be reinserted from $biblio explicitly. Looking at the %fields hash in the same file, "author" is probably another field that needs fixing too. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 15

[Bug 18431] New: Import hangs when SearchEngine is set to ElasticSearch
by bugzilla-daemon＠bugs.koha-community.org 07 Dec '17

07 Dec '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18431 Bug ID: 18431 Summary: Import hangs when SearchEngine is set to ElasticSearch Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Searching Assignee: gmcharlt(a)gmail.com Reporter: barton(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org Marc record import hangs when SearchEngine is set to ElasticSearch. To replicate: Make sure that ElasticSearch is running, and the SearchEngine syspref is set to ElasticSearch. Go to tools > stage marc records. Choose file, upload file, Click Stage Records for import. Click Import this batch into the catalog. The import hangs at 0%. I was able to import all records when SearchEngine was set to Zebra. -- You are receiving this mail because: You are watching all bug changes.

1 3

[Bug 19425] New: Adding orders from order file with multiple budgets per record triggers error
by bugzilla-daemon＠bugs.koha-community.org 07 Dec '17

07 Dec '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19425 Bug ID: 19425 Summary: Adding orders from order file with multiple budgets per record triggers error Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: Acquisitions Assignee: koha-bugs(a)lists.koha-community.org Reporter: kyle(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org If you import an order file ( using MarcItemFieldsToOrder ) that has a different budget for each item to be ordered, you will get an error and a partially created basket. This is because Koha attempts to add the item to each order *for each budget*. This is clearly incorrect. Instead, we should be grouping items by budget and for each budget only adding those items that have a matching budget. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 19

[Bug 19058] New: Move C4::Reserves::GetReserveId to Koha::Holds
by bugzilla-daemon＠bugs.koha-community.org 06 Dec '17

06 Dec '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19058 Bug ID: 19058 Summary: Move C4::Reserves::GetReserveId to Koha::Holds Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: ASSIGNED Severity: enhancement Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: jonathan.druart(a)bugs.koha-community.org Reporter: jonathan.druart(a)bugs.koha-community.org QA Contact: testopia(a)bugs.koha-community.org Depends on: 19057 Blocks: 17728 GetReserveId can easily be replaced with a call to Koha::Holds->search->next->reserve_id It will ease next changes to use Koha::Hold objects Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17728 [Bug 17728] Move C4::Reserves code to the Koha namespace https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19057 [Bug 19057] Move C4::Reserves::GetReserve to the Koha namespace -- You are receiving this mail because: You are watching all bug changes.

1 14

[Bug 19374] New: CircSidebar overlapping transferred items table
by bugzilla-daemon＠bugs.koha-community.org 05 Dec '17

05 Dec '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19374 Bug ID: 19374 Summary: CircSidebar overlapping transferred items table Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Circulation Assignee: koha-bugs(a)lists.koha-community.org Reporter: lari.taskula(a)jns.fi QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com Created attachment 67395 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=67395&action=ed… CircSidebar overlapping transferred items table When CircSidebar is activated, "Transferred items" table at Circulation -> Transfers goes under the sidebar. See attachment. To reproduce: 1. Activate CircSidebar system preference 2. Go to cgi-bin/koha/circ/branchtransfers.pl 3. Enter a barcode and click submit 4. Observe transferred items table under the circulation side bar -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 18

[Bug 19675] New: Cannot save notices when setting the TranslateNotices preference
by bugzilla-daemon＠bugs.koha-community.org 05 Dec '17

05 Dec '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19675 Bug ID: 19675 Summary: Cannot save notices when setting the TranslateNotices preference Change sponsored?: --- Product: Koha Version: 17.05 Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: Notices Assignee: koha-bugs(a)lists.koha-community.org Reporter: andreas.jonsson(a)kreablo.se QA Contact: testopia(a)bugs.koha-community.org The lang parameter is missing in the where clause of the update statement. The below patch fixes the problem. diff --git a/tools/letter.pl b/tools/letter.pl index 5920a8437f..f89930472c 100755 --- a/tools/letter.pl +++ b/tools/letter.pl @@ -303,11 +303,11 @@ sub add_validate { q{ UPDATE letter SET branchcode = ?, module = ?, name = ?, is_html = ?, title = ?, content = ?, lang = ? - WHERE branchcode = ? AND module = ? AND code = ? AND message_transport_type = ? + WHERE branchcode = ? AND module = ? AND code = ? AND message_transport_type = ? AND lang = ? }, undef, $branchcode || '', $module, $name, $is_html || 0, $title, $content, $lang, - $branchcode, $oldmodule, $code, $mtt + $branchcode, $oldmodule, $code, $mtt, $lang ); } else { $dbh->do( To reproduce: 1. Enable TranslateNotices global preference. 2. Edit any notice message and save a translation. 3. Try updating any translation. The save will fail and the log-file will contain errors such as this: DBIx::Class::Storage::DBI::select_single(): Query returned more than one row. SQL that returns multiple rows is DEPRECATED for ->find and ->single at /usr/share/koha/lib/Koha/Objects.pm line 92 DBIx::Class::Storage::DBI::select_single(): Query returned more than one row. SQL that returns multiple rows is DEPRECATED for ->find and ->single at /usr/share/koha/lib/Koha/Objects.pm line 92 DBD::mysql::db do failed: Duplicate entry 'circulation-ODUE--email-sv-SE' for key 'PRIMARY' [for Statement " UPDATE letter SET branchcode = ?, module = ?, name = ?, is_html = ?, title = ?, content = ?, lang = ? WHERE branchcode = ? AND module = ? AND code = ? AND message_transport_type = ? "] at /usr/share/koha/intranet/cgi-bin/tools/letter.pl line 302. DBD::mysql::db do failed: Duplicate entry 'circulation-ODUE--email-en' for key 'PRIMARY' [for Statement " UPDATE letter SET branchcode = ?, module = ?, name = ?, is_html = ?, title = ?, content = ?, lang = ? WHERE branchcode = ? AND module = ? AND code = ? AND message_transport_type = ? "] at /usr/share/koha/intranet/cgi-bin/tools/letter.pl line 302. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 11

[Bug 19516] New: can' t save changes on notices if letter is already created
by bugzilla-daemon＠bugs.koha-community.org 05 Dec '17

05 Dec '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19516 Bug ID: 19516 Summary: can't save changes on notices if letter is already created Change sponsored?: --- Product: Koha Version: 17.05 Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Notices Assignee: koha-bugs(a)lists.koha-community.org Reporter: hagud(a)orex.es QA Contact: testopia(a)bugs.koha-community.org we have seen a problem modifying notices in koha 17.05.04, the issue is that you can not modify notices if they're already created, when you try to modify you get an error in plack as these one. DBD::mysql::db do failed: Duplicate entry 'circulation-PREDUE--email-ca-ES' for key 'PRIMARY' [for Statement " UPDATE letter SET branchcode = ?, module = ?, name = ?, is_html = ?, title = ?, content = ?, lang = ? WHERE branchcode = ? AND module = ? AND code = ? AND message_transport_type = ? "] at /usr/share/koha/intranet/cgi-bin/tools/letter.pl line 302. DBD::mysql::db do failed: Duplicate entry 'circulation-PREDUE--sms-ca-ES' for key 'PRIMARY' [for Statement " UPDATE letter SET branchcode = ?, module = ?, name = ?, is_html = ?, title = ?, content = ?, lang = ? WHERE branchcode = ? AND module = ? AND code = ? AND message_transport_type = ? "] at /usr/share/koha/intranet/cgi-bin/tools/letter.pl line 302. DBD::mysql::db do failed: Duplicate entry 'circulation-PREDUE--email-es-ES' for key 'PRIMARY' [for Statement " UPDATE letter SET branchcode = ?, module = ?, name = ?, is_html = ?, title = ?, content = ?, lang = ? WHERE branchcode = ? AND module = ? AND code = ? AND message_transport_type = ? "] at /usr/share/koha/intranet/cgi-bin/tools/letter.pl line 302. DBD::mysql::db do failed: Duplicate entry 'circulation-PREDUE--sms-es-ES' for key 'PRIMARY' [for Statement " UPDATE letter SET branchcode = ?, module = ?, name = ?, is_html = ?, title = ?, content = ?, lang = ? WHERE branchcode = ? AND module = ? AND code = ? AND message_transport_type = ? "] at /usr/share/koha/intranet/cgi-bin/tools/letter.pl line 302. DBD::mysql::db do failed: Duplicate entry 'circulation-PREDUE--email-default' for key 'PRIMARY' [for Statement " UPDATE letter SET branchcode = ?, module = ?, name = ?, is_html = ?, title = ?, content = ?, lang = ? WHERE branchcode = ? AND module = ? AND code = ? AND message_transport_type = ? "] at /usr/share/koha/intranet/cgi-bin/tools/letter.pl line 302. DBD::mysql::db do failed: Duplicate entry 'circulation-PREDUE--sms-default' for key 'PRIMARY' [for Statement " UPDATE letter SET branchcode = ?, module = ?, name = ?, is_html = ?, title = ?, content = ?, lang = ? WHERE branchcode = ? AND module = ? AND code = ? AND message_transport_type = ? "] at /usr/share/koha/intranet/cgi-bin/tools/letter.pl line 302. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 4

[Bug 18447] New: Datepicker only shows -10/+10 years
by bugzilla-daemon＠bugs.koha-community.org 04 Dec '17

04 Dec '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18447 Bug ID: 18447 Summary: Datepicker only shows -10/+10 years Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Patrons Assignee: koha-bugs(a)lists.koha-community.org Reporter: nick(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com When entering patrons they are often more than 10 years old - entering a birth date requires constantly clicking back 10 years on the date picker - we should load a few more years in the past This was fixed in bug 12342 but that code is no longer used -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 58

[Bug 16239] New: Upgrade Bootstrap in the staff client
by bugzilla-daemon＠bugs.koha-community.org 04 Dec '17

04 Dec '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16239 Bug ID: 16239 Summary: Upgrade Bootstrap in the staff client Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: ASSIGNED Severity: enhancement Priority: P5 - low Component: Templates Assignee: oleonard(a)myacpl.org Reporter: oleonard(a)myacpl.org QA Contact: testopia(a)bugs.koha-community.org Depends on: 15883 Blocks: 14546 Now that we are on a path to getting a jQuery upgrade, it's time to start working on an upgrade to Bootstrap in the staff client. I propose that this upgrade be done as a precursor to (rather than simultaneously with) a full conversion of the staff client to a Bootstrap grid (Bug 14546). Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14546 [Bug 14546] Make staff client templates responsive https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15883 [Bug 15883] Upgrade jQuery from v1.7.2 in the staff client -- You are receiving this mail because: You are watching all bug changes.

1 119