December 2018 - Koha-bugs - lists.koha-community.org

[Bug 21906] New: WHERE clause doesn't like % in CONCAT
by bugzilla-daemon＠bugs.koha-community.org 08 Dec '18

08 Dec '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21906 Bug ID: 21906 Summary: WHERE clause doesn't like % in CONCAT Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Reports Assignee: koha-bugs(a)lists.koha-community.org Reporter: cbrannon(a)cdalibrary.org QA Contact: testopia(a)bugs.koha-community.org In previous versions of Koha, I have been able to create a field that could have some information or be left blank in the WHERE clause, such as: WHERE itemcallnumber LIKE CONCAT(<<Start of call number>>,'%') Starting with 18.05, Koha will give me results, but it will give me blank results with the header if I download. If I use something else, it will populate in the download just fine. The % seems to be interfering with the download process. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 8

[Bug 9634] Allow for parameters re-use on SQL reports
by bugzilla-daemon＠bugs.koha-community.org 08 Dec '18

08 Dec '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9634 Jonathan Druart <jonathan.druart(a)bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Blocks| |21906 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21906 [Bug 21906] WHERE clause doesn't like % in CONCAT -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 21977] New: Add ability to transmit shelving location via SIP
by bugzilla-daemon＠bugs.koha-community.org 07 Dec '18

07 Dec '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21977 Bug ID: 21977 Summary: Add ability to transmit shelving location via SIP Change sponsored?: --- Product: Koha Version: unspecified 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 libraries use bin sorters that communicate via SIP2. To sort the items correctly, it is necessary for these sorters to know the shelving location code assigned to the item. For this to function correctly we need to transmit the shelving location via the item information and checkin responses. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 5

[Bug 21951] New: Patron import fails if matching on cardnumber and userid also matches
by bugzilla-daemon＠bugs.koha-community.org 07 Dec '18

07 Dec '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21951 Bug ID: 21951 Summary: Patron import fails if matching on cardnumber and userid also matches Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Patrons Assignee: koha-bugs(a)lists.koha-community.org Reporter: kyle(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com If a patron CSV file has both cardnumber and userid, and cardnumber is used as a matchpoint, the patron import will fail with an error like -- Userid kyle.hall is already used by another patron. -- even though that userid is used by the very same patron! Matching on userid does not generate this error. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 8

[Bug 7556] Use "preventDoubleFormSubmit()" more in the OPAC and Intranet to prevent duplicate data
by bugzilla-daemon＠bugs.koha-community.org 07 Dec '18

07 Dec '18

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

1 0

[Bug 21823] New: Cannot update or create translations
by bugzilla-daemon＠bugs.koha-community.org 07 Dec '18

07 Dec '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21823 Bug ID: 21823 Summary: Cannot update or create translations Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: blocker Priority: P5 - low Component: I18N/L10N Assignee: koha-bugs(a)lists.koha-community.org Reporter: tomascohen(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org CC: frederic(a)tamil.fr Bug 15395 broke the translations handling process. Steps to reproduce: - Run: $ kshell k$ cd misc/translator k$ perl translate update fr-FR => FAIL: You get an error: system call failed: /bin/sed --in-place /home/vagrant/kohaclone/misc/translator/Koha.pot --expression='s/charset=CHARSET/charset=UTF-8/' at /home/vagrant/kohaclone/misc/translator/LangInstaller.pm line 655. - Create a new set of language translation files: k$ perl translate create xx-YY => FAIL: You get an error: /bin/sed: can't read /home/vagrant/kohaclone/misc/translator/Koha.pot: No such file or directory system call failed: /bin/sed --in-place /home/vagrant/kohaclone/misc/translator/Koha.pot --expression='s/charset=CHARSET/charset=UTF-8/' at /home/vagrant/kohaclone/misc/translator/LangInstaller.pm line 655. Note: the translation files get updated/generated, but the error breaks any automatic pipeline. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 14

[Bug 21839] New: Fix capitalization for "Print Label"
by bugzilla-daemon＠bugs.koha-community.org 07 Dec '18

07 Dec '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21839 Bug ID: 21839 Summary: Fix capitalization for "Print Label" Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: trivial Priority: P5 - low Component: Templates Assignee: katrin.fischer(a)bsz-bw.de Reporter: katrin.fischer(a)bsz-bw.de QA Contact: testopia(a)bugs.koha-community.org -- You are receiving this mail because: You are watching all bug changes.

1 10

[Bug 14334] DBI fighting DBIx over Autocommit in tests
by bugzilla-daemon＠bugs.koha-community.org 07 Dec '18

07 Dec '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14334 Jonathan Druart <jonathan.druart(a)bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |jonathan.druart(a)bugs.koha-c | |ommunity.org --- Comment #27 from Jonathan Druart <jonathan.druart(a)bugs.koha-community.org> --- (In reply to Jonathan Druart from comment #23) > Created attachment 40184 [details] [review] > [ FOR DISCUSSION ] Bug 14334: Add a Database module for db dependent tests > > What about something like that to avoid c/p? That was wrong, sorry. Sometimes we need to rollback before END. -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 14334] DBI fighting DBIx over Autocommit in tests
by bugzilla-daemon＠bugs.koha-community.org 07 Dec '18

07 Dec '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14334 Jonathan Druart <jonathan.druart(a)bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #39874|0 |1 is obsolete| | Attachment #39875|0 |1 is obsolete| | Attachment #39876|0 |1 is obsolete| | Attachment #39877|0 |1 is obsolete| | Attachment #39879|0 |1 is obsolete| | Attachment #39880|0 |1 is obsolete| | Attachment #39881|0 |1 is obsolete| | Attachment #39882|0 |1 is obsolete| | Attachment #39883|0 |1 is obsolete| | Attachment #39884|0 |1 is obsolete| | Attachment #39885|0 |1 is obsolete| | Attachment #40080|0 |1 is obsolete| | Attachment #40086|0 |1 is obsolete| | Attachment #40184|0 |1 is obsolete| | --- Comment #26 from Jonathan Druart <jonathan.druart(a)bugs.koha-community.org> --- Created attachment 82989 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=82989&action=ed… Bug 14334: Remove AutoCommit from tests And use a DBIx transaction instead. Test plan: prove that the test files modified by this patch are passing -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 14334] DBI fighting DBIx over Autocommit in tests
by bugzilla-daemon＠bugs.koha-community.org 07 Dec '18

07 Dec '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14334 Jonathan Druart <jonathan.druart(a)bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|ASSIGNED |Needs Signoff -- You are receiving this mail because: You are watching all bug changes.

1 0