July 2021 - Koha-bugs - lists.koha-community.org

[Bug 28328] New: Editing a record can cause an ISE if data too long for column
by bugzilla-daemon＠bugs.koha-community.org 18 Jun '23

18 Jun '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28328 Bug ID: 28328 Summary: Editing a record can cause an ISE if data too long for column Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: Cataloging Assignee: koha-bugs(a)lists.koha-community.org Reporter: nick(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org CC: m.de.rooy(a)rijksmuseum.nl Like bug 26518, but for ModBiblio To recreate: 1 - Edit a record in the staff client 2 - In MARC21 edit the 010a/LCCN field wih: ThisisgoingtobetoomanycharactersfortheLCCNfield 3 - Save the record 4 - ISE: C4::Biblio::_koha_modify_biblioitem_nonmarc(): DBI Exception: DBD::mysql::st execute failed: Data too long for column 'lccn' at row 1 [for Statement "UPDATE biblioitems SET biblionumber = ?, volume = ?, number = ?, itemtype = ?, isbn = ?, issn = ?, publicationyear = ?, publishercode = ?, volumedate = ?, volumedesc = ?, collectiontitle = ?, collectionissn = ?, collectionvolume= ?, editionstatement= ?, editionresponsibility = ?, illus = ?, pages = ?, notes = ?, size = ?, place = ?, lccn = ?, url = ?, cn_source = ?, cn_class = ?, cn_item = ?, cn_suffix = ?, cn_sort = ?, totalissues = ?, ean = ?, agerestriction = ? where biblioitemnumber = ? " with ParamValues: 0="4239", 1=undef, 2=undef, 3="BK", 4="0887080189", 5=undef, 6=undef, 7="Neugebauer Press USA ; | Distributed by Alphabet Press,", 8=undef, 9=undef, 10=undef, 11=undef, 12=undef, 13=undef, 14=undef, 15="col. ill. ;", 16="[30] p. :", 17=undef, 18="30 cm.", 19="[S.l.] : | Natick, MA :", 20="83181009sdhgaethq45y245y24thsadhgahq", 21=undef, 22="ddc", 23=undef, 24=undef, 25=undef, 26='', 27=undef, 28=undef, 29=undef, 30='4239'] at /kohadevbox/koha/C4/Biblio.pm line 384 at /usr/share/perl5/DBIx/Class/Exception.pm line 77 This also kills the linker script if a bib with too long lccn is encountered -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 26

[Bug 22211] New: In-built offline circulation shows incomplete information for checkouts
by bugzilla-daemon＠bugs.koha-community.org 17 Jun '23

17 Jun '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22211 Bug ID: 22211 Summary: In-built offline circulation shows incomplete information for checkouts Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Circulation Assignee: koha-bugs(a)lists.koha-community.org Reporter: katrin.fischer(a)bsz-bw.de QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com Target Milestone: --- The checkouts table on a patron account in the in-built offline circulation is missing some important information. Columns suggest that this used to work, so filing as a bug. To test: - Switch on AllowOfflineCirculation - Go to: /cgi-bin/koha/circ/offline.pl - Synchronize (make sure you have some accounts with checkouts - Check out - Open the account by entering the cardnumber in field on top - View checkouts shown - Verify: - item type shows as undefined - checkout location shows as undefined - empty call number shows as undef -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 2

[Bug 27663] New: statistics table should have some way to include items.permanent_location
by bugzilla-daemon＠bugs.koha-community.org 16 Jun '23

16 Jun '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27663 Bug ID: 27663 Summary: statistics table should have some way to include items.permanent_location Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Database Assignee: koha-bugs(a)lists.koha-community.org Reporter: george(a)nekls.org QA Contact: testopia(a)bugs.koha-community.org statistics.location currently uses items.location at the time an item is checked out. This means that for a library using the CART and PROC locations, accurate data about an item's permanent location at the time of check-out can only be gathered through a report linking to the item record. It would be more efficient for items that are using the PROC and CART locations if the statistics table also included the item's permanent location or if there were a system preference that allowed users to specify whether they want statisitcs.location to use an item's items.location or items.permanent_location at the time of check-out. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 11

[Bug 25379] New: HTML tags visible in Returns.pl
by bugzilla-daemon＠bugs.koha-community.org 15 Jun '23

15 Jun '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25379 Bug ID: 25379 Summary: HTML tags visible in Returns.pl Change sponsored?: --- Product: Koha Version: 19.11 Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Patrons Assignee: koha-bugs(a)lists.koha-community.org Reporter: kelly(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com Created attachment 104375 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=104375&action=e… on returns.pl page With the introduction of this bug: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23409. ( Show circulation note and OPAC note with line feeds ), the ability to add HTML was included. However, when a patron note with HTML is seen during circulation (check-in)- the HTML tags are visible. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 26

[Bug 22375] New: Due dates should be formatted consistantly
by bugzilla-daemon＠bugs.koha-community.org 15 Jun '23

15 Jun '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22375 Bug ID: 22375 Summary: Due dates should be formatted consistantly Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Templates Assignee: oleonard(a)myacpl.org Reporter: josef.moravec(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org Target Milestone: --- Now we have some due dates formatted as datetime, and some shows time part only when it is hourly loan (as_due_date = 1 param of KohaDates filter is used) This should be same for all due dates across whole system, as_due_date should be used everywhere -- You are receiving this mail because: You are watching all bug changes.

1 21

[Bug 26899] New: Pick up location defaults to first choice if patron
by bugzilla-daemon＠bugs.koha-community.org 15 Jun '23

15 Jun '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26899 Bug ID: 26899 Summary: Pick up location defaults to first choice if patron Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Hold requests Assignee: koha-bugs(a)lists.koha-community.org Reporter: cbrannon(a)cdalibrary.org QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 6

[Bug 22827] New: Automatic item modifications by age: add age depencency on other field(s) than dateaccessioned
by bugzilla-daemon＠bugs.koha-community.org 14 Jun '23

14 Jun '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22827 Bug ID: 22827 Summary: Automatic item modifications by age: add age depencency on other field(s) than dateaccessioned Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Tools Assignee: koha-bugs(a)lists.koha-community.org Reporter: black23(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org Target Milestone: --- Some libraries needs automatic modification based on other date that dateaccessioned. For example: copyright rules allow start borrow some kind of materials x months after release date. In this case must be age modification based on other field than dateaccessioned. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 34

[Bug 22262] New: text/javascript responses should be compressed by Apache
by bugzilla-daemon＠bugs.koha-community.org 14 Jun '23

14 Jun '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22262 Bug ID: 22262 Summary: text/javascript responses should be compressed by Apache Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Web services Assignee: koha-bugs(a)lists.koha-community.org Reporter: gmcharlt(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org Target Milestone: --- Neither the vanilla Apache configuration nor the Debian one includes text/javascript in the list of MIME types of responses that get compressed by mod_deflate. Since some APIs under /svc/ happen to use that MIME type in their responses, a bit of bandwidth can be unnecessarily wasted. However, the lack of compression is of more import for svc/cataloguing/framework, which transfers a megabyte or so whenever it is invoked to fetch the default MARC21 framework (and presumably a similar amount of data for other MARC frameworks). Since that API is invoked when Rancor initializes, it's been observed that over a slow connection a RequireJS "define" call can time out, leading to the MARC editor never fully initializing and an error like this appearing in the browser debug console: "error" load timeout for modules: /cgi-bin/koha/svc/cataloguing/framework?frameworkcode=&callback=define" onscripterror https://HOST/intranet-tmp1/lib/require_18.0504000.js -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 4

[Bug 23068] New: Add ability for Koha to handle X-Forwarded-For headers so REMOTE_ADDR features work behind a proxy
by bugzilla-daemon＠bugs.koha-community.org 13 Jun '23

13 Jun '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23068 Bug ID: 23068 Summary: Add ability for Koha to handle X-Forwarded-For headers so REMOTE_ADDR features work behind a proxy Change sponsored?: --- Product: Koha Version: unspecified 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: kyle(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org Target Milestone: --- Koha has a number of features that rely on knowing the IP address of the connecting client. If that server is behind a proxy these features do not work. We can use Plack::Middleware::RealIP to automatically convert the X-Forwarded-For header into the REMOTE_ADDR environment variable so no Koha code need be modified. A future enhancement could be to take advantage of the module's trusted_proxy setting to allow Koha to use these feature even after going through *multiple* proxies. This would require being able to read configuration from the plack.psgi file and is beyond the scope of this enhancement. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 77

[Bug 27452] New: Create GUI for patron_emailer cron
by bugzilla-daemon＠bugs.koha-community.org 13 Jun '23

13 Jun '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27452 Bug ID: 27452 Summary: Create GUI for patron_emailer cron Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Staff Client Assignee: koha-bugs(a)lists.koha-community.org Reporter: andrew(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, katrin.fischer(a)bsz-bw.de, nick(a)bywatersolutions.com Depends on: 16149 It would be nice to have a GUI for this cron so folks don't need to install the plugin (https://github.com/bywatersolutions/koha-plugin-patron-emailer) Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16149 [Bug 16149] Generate and send custom notices based on report output -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 7