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

[Bug 13766] biblioitems.ean field is too short
by bugzilla-daemon＠bugs.koha-community.org 09 Jun '17

09 Jun '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13766 Colin Campbell <colin.campbell(a)ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |colin.campbell@ptfs-europe. | |com --- Comment #6 from Colin Campbell <colin.campbell(a)ptfs-europe.com> --- (In reply to Frédéric Demians from comment #4) > (In reply to Jonathan Druart from comment #3) > > Frédéric, I got an error on executing the updatedb entry: > > > > DBD::mysql::db do failed: BLOB/TEXT column 'ean' used in key specification > > without a key length at installer/data/mysql/updatedatabase.pl line 9798. > > Thanks testing. I also can get this error. I don't have it on recent DB. I > get it on older. > > In updatedatebase.pl, line 5323: > > $dbh->do("CREATE INDEX `ean` ON biblioitems (`ean`) "); > > So a DB which was on Koha 3.8, and earlier, has an index on biblioitems.ean. > > A fresh DB, hasn't such an index. kohastructre.sql, line 186 and after, > there are index defined for isbn but not for ean. > > Do you think that an index is required on ean field? Yes it should, like isbn, issn be indexed. It could be an important field if the library (like most publics) has a large dvd collection. The short size and lack of key is a problem if trying to do checks against this field -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 14570] Make it possible to add multiple guarantors to a record
by bugzilla-daemon＠bugs.koha-community.org 09 Jun '17

09 Jun '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14570 --- Comment #57 from Kyle M Hall <kyle(a)bywatersolutions.com> --- Created attachment 64126 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=64126&action=ed… Bug 14570 - Update Schema -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 14570] Make it possible to add multiple guarantors to a record
by bugzilla-daemon＠bugs.koha-community.org 09 Jun '17

09 Jun '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14570 --- Comment #56 from Kyle M Hall <kyle(a)bywatersolutions.com> --- Created attachment 64125 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=64125&action=ed… Bug 14570 - Followup Fix small errors in update child script Signed-off-by: Kim Peine <kmpeine(a)gmail.com> Signed-off-by: Kyle M Hall <kyle(a)bywatersolutions.com> -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 14570] Make it possible to add multiple guarantors to a record
by bugzilla-daemon＠bugs.koha-community.org 09 Jun '17

09 Jun '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14570 Kyle M Hall <kyle(a)bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #62450|0 |1 is obsolete| | Attachment #62451|0 |1 is obsolete| | Attachment #62452|0 |1 is obsolete| | --- Comment #55 from Kyle M Hall <kyle(a)bywatersolutions.com> --- Created attachment 64124 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=64124&action=ed… Bug 14570 - Make it possible to add multiple guarantors to a record This patch adds the ability to set an unlimited number of guarantors for a given patron. As before, each guarantor may be linked to another Koha patron, and all the behavior that applies to a given guarantor remains the same. Test Plan: 1) Apply this patch 2) Run updatedatabase.pl 3) Find some patrons with guarantors, verify the still have their guarantor 4) Test adding and removing guarantors on a patron record, both Koha users and not 5) Verify the "Add child" button works 6) Verify NoIssuesChargeGuarantees still works 7) Verify tools/cleanborrowers.pl will not delete a guarantor 8) Verify the guarantors are displayed on moremember.pl 9) Verify the guarantor is removed by members/update-child.pl 10) Verify the guarantor is removed by misc/cronjobs/j2a.pl 11) Verify import patrons converts guarantor_id, relationship, contactfirstname, and contactsurname into a guarantor 12) prove t/Patron.t 13) prove t/db_dependent/Circulation.t 14) prove t/db_dependent/Circulation/NoIssuesChargeGuarantees.t 15) prove t/db_dependent/Items.t 16) prove t/db_dependent/Koha/Patrons.t 17) prove t/db_dependent/Members.t 18) prove t/db_dependent/Patron/Relationships.t Signed-off-by: Kim Peine <kmpeine(a)gmail.com> Signed-off-by: Kyle M Hall <kyle(a)bywatersolutions.com> -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 18764] New: AFA-Quickbooks-Tech-Support-Phone-Number-1-888-513-5978-Quickbooks-Tech-Support-Phone-Number
by bugzilla-daemon＠bugs.koha-community.org 09 Jun '17

09 Jun '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18764 Bug ID: 18764 Summary: AFA-Quickbooks-Tech-Support-Phone-Number-1-888-513-597 8-Quickbooks-Tech-Support-Phone-Number Change sponsored?: --- Product: Koha Version: 17.05 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: salognedposgeorgei(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org AFA-Quickbooks-Tech-Support-Phone-Number-1-888-513-5978-Quickbooks-Tech-Support-Phone-Number -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 2

[Bug 15644] City dropdown default selection when modifying a patron matches only on city
by bugzilla-daemon＠bugs.koha-community.org 08 Jun '17

08 Jun '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15644 --- Comment #3 from Owen Leonard <oleonard(a)myacpl.org> --- Created attachment 64111 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=64111&action=ed… Bug 15644 - City dropdown default selection when modifying a patron matches only on city This patch modifies the include files which contain the form fields for city, state, zipcode, etc. shown on the patron entry screen. The files are modified so that the city/state/zip <select> preselects a value based on city, state, and zipcode matching the values in the corresponding text fields. To test, confirm that the bug's steps to reproduce are fixed: - Enter two cities via Administration -> Patrons and circulation -> Cities and towns: Springfield, MA 01101 Springfield, VT 05156 - Edit a patron choosing, Springfield VT, and save. - Edit the patron again and confirm that the correct city is pre-selected. - Confirm this result with all three different settings of the "AddressFormat" system preference. -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 15644] City dropdown default selection when modifying a patron matches only on city
by bugzilla-daemon＠bugs.koha-community.org 08 Jun '17

08 Jun '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15644 Owen Leonard <oleonard(a)myacpl.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Patch complexity|--- |Trivial patch Status|ASSIGNED |Needs Signoff -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 15644] City dropdown default selection when modifying a patron matches only on city
by bugzilla-daemon＠bugs.koha-community.org 08 Jun '17

08 Jun '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15644 Owen Leonard <oleonard(a)myacpl.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |ASSIGNED Assignee|koha-bugs(a)lists.koha-commun |oleonard(a)myacpl.org |ity.org | -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 0

[Bug 14438] RTF / CSV /ODS format in Download cart option
by bugzilla-daemon＠bugs.koha-community.org 08 Jun '17

08 Jun '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14438 Katrin Fischer <katrin.fischer(a)bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |katrin.fischer(a)bsz-bw.de --- Comment #1 from Katrin Fischer <katrin.fischer(a)bsz-bw.de> --- CSV export can be added easily by crating a CSV profile in tools. -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 18753] New: t/00-testcritic.t fails Perl::Critic on test 221
by bugzilla-daemon＠bugs.koha-community.org 08 Jun '17

08 Jun '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18753 Bug ID: 18753 Summary: t/00-testcritic.t fails Perl::Critic on test 221 Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Test Suite Assignee: chris(a)bigballofwax.co.nz Reporter: ldjamison(a)marywood.edu QA Contact: gmcharlt(a)gmail.com Unit Test t/00-testcritic.t fails to pass Perl::Critic on Test 221. -- You are receiving this mail because: You are watching all bug changes.

1 11