August 2015 - Koha-bugs - lists.koha-community.org

[Bug 13812] New: Facet links broken when shelf location limit is used.
by bugzilla-daemon＠bugs.koha-community.org 25 Aug '15

25 Aug '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13812 Bug ID: 13812 Summary: Facet links broken when shelf location limit is used. Change sponsored?: --- Product: Koha Version: unspecified 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 This bug is analogous to Bug 13442, but it affects shelf location rather than collection code: Limiting a search by shelf location is broken, because it wraps double-quotes around the "value" part of the key-value pair in the URL. This breaks the href= part of the anchor tag. The anchor tag generated for the shelf location faced is <a href="/cgi-bin/koha/opac-search.pl?&limit=mc-loc%3A"100100ADFICCF"&limit=mc-loc%3A"100200ADFIC"&limit=mc-loc%3A"100250ADFICGN"&limit=mc-loc%3A"100300ADFICHF"&limit=yr%2Cst-numeric%3D2014-&sort_by=acqdate_dsc&limit=au:Paetro%2C%20Maxine%2C" title="Paetro, Maxine,">Paetro, Maxine,</a> Once again, double-quotes inside the URL are causing a premature close of the href, which results in a broken link. I think that we need to take a look for code duplication inside C4::Search::buildQuery -- if there's more than one section of code where we're wrapping quotes around the 'value' part of the query, these should be consolidated -- shouldn't we be using URL encoding for URL reserved characters anyway? -- You are receiving this mail because: You are watching all bug changes.

1 10

[Bug 14708] New: The patron set as the anonymous patron should not be deletable.
by bugzilla-daemon＠bugs.koha-community.org 25 Aug '15

25 Aug '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14708 Bug ID: 14708 Summary: The patron set as the anonymous patron should not be deletable. 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.m.hall(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com Right now it's possible to delete the anonymous patron at any time. When this happens the system will break just as if anonymouspatron was unset but patrons still have an "always anonymize" privacy setting. This issue occurs more frequently than one would expect. We should make it so that the patron set in AnonymousPatron is not deletable. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 2

[Bug 13980] New: Can't call method "fields" on an undefined value at /usr/share/koha/intranet/cgi-bin/cataloguing/additem.pl
by bugzilla-daemon＠bugs.koha-community.org 25 Aug '15

25 Aug '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13980 Bug ID: 13980 Summary: Can't call method "fields" on an undefined value at /usr/share/koha/intranet/cgi-bin/cataloguing/additem.p l Change sponsored?: --- Product: Koha Version: 3.18 Hardware: PC OS: Linux Status: NEW Severity: major Priority: P5 - low Component: Cataloging Assignee: gmcharlt(a)gmail.com Reporter: bob-ewart(a)bobsown.com QA Contact: testopia(a)bugs.koha-community.org CC: m.de.rooy(a)rijksmuseum.nl Created attachment 37680 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=37680&action=edit excerpt from /var/log/koha/koha-error_log This error occurs when trying to save the following MARC record from the Amicus Z39.50 server: 01800cam 2200349 a 4500 001 000042344666 003 CaOOAMICUS 005 20140203 .0 008 110402s2011 ohu 000 1 eng d 020 $a 9781609282066 (pbk.) 020 $a 160928206X (pbk.) 040 $a CaBVA $b eng 043 $a n-us-ma 100 1 $a Lanyon, Josh. 245 10 $a All she wrote / $c Josh Lanyon. 260 $a Cincinnati, OH : $b Samhain Pub., $c c2011. 300 $a 270 p. ; $c 22 cm. 490 1 $a Holmes & Moriarity ; $v book 2 520 $a A murderous fall down icy stairs is nearly the death of Anna Hitchcock, the much-beloved "American Agatha Christie" and Christopher Holmes' former mentor. Anna's plea for him to host her annual winter writing retreat touches all Kit's sore spots-- traveling, teaching writing classes, and separation from his new lover, J.X. Moriarity. For J.X., Kit's cancellation of yet another romantic weekend is the death knell of a relationship that has been limping along for months. Soon Kit is snooping around Anna's elegant, snowbound mansion in the Berkshires for clues as to who's trying to kill her. Unfortunately, a clever killer is one step ahead. And it may be too late for J.X. to ride to the rescue. 650 0 $a Holmes, Christopher (Fictitious character) $v Fiction. 650 0 $a Moriarity, J. X. (Fictitious character) $v Fiction. 650 0 $a Private investigators $v Fiction. 650 0 $a Authors $v Fiction. 650 00 $a Ex-police officers as detectives $v Fiction. 650 0 $a Gay men $v Fiction. 650 0 $a Murderers $v Fiction. 651 0 $a Berkshire Hills (Mass.) $v Fiction. 655 4 $a Mystery fiction. 655 4 $a Gay fiction. 655 4 $a Erotic stories. 800 1 $a Lanyon, Josh. $t Holmes & Moriarity ; $v bk. 2 ; $v bk. 2. 852 $9 1 $a CaBVA $z ILL: yes Do a Z39.50 search on author 'lanyon, josh' and import the record for 'All she wrote'. It fails when trying to save the record on Koha 3.18.05 running on openSUSE built from a tarball. It works on Koha 3.18.04 running on Debian 7 installed from koha-common. -- You are receiving this mail because: You are watching all bug changes.

1 9

[Bug 11894] New: Funds toolbar menu items greyed out without explanation
by bugzilla-daemon＠bugs.koha-community.org 25 Aug '15

25 Aug '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11894 Bug ID: 11894 Summary: Funds toolbar menu items greyed out without explanation Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: ASSIGNED Severity: normal Priority: P5 - low Component: Acquisitions Assignee: oleonard(a)myacpl.org Reporter: oleonard(a)myacpl.org QA Contact: testopia(a)bugs.koha-community.org Under some circumstances items in the budgets/funds toolbar menu are greyed out without explanation. Either an explanatory tooltip should be added or the menu items should be hidden from those without the correct permissions. -- You are receiving this mail because: You are watching all bug changes.

1 1

[Bug 8797] New: can't delete quote of the day
by bugzilla-daemon＠bugs.koha-community.org 25 Aug '15

25 Aug '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8797 Priority: P5 - low Change sponsored?: --- Bug ID: 8797 Assignee: cnighswonger(a)foundations.edu Summary: can't delete quote of the day Severity: normal Classification: Unclassified OS: All Reporter: nengard(a)gmail.com Hardware: All Status: NEW Version: master Component: Tools Product: Koha I am documenting the QOTD feature and trying to delete a quote, but it's not letting me do it. I click on the quote id number and nothing happens - the row isn't highlighted or anything and so I can't delete. I'm on FF on Mac. If I click to add a new quote and don't enter any data then I can click on the ID column of the new empty quote and delete it. -- You are receiving this mail because: You are watching all bug changes.

1 9

[Bug 14724] New: Manage Staged MARC Records stuck at 0% on Koha 3.12.04.000
by bugzilla-daemon＠bugs.koha-community.org 25 Aug '15

25 Aug '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14724 Bug ID: 14724 Summary: Manage Staged MARC Records stuck at 0% on Koha 3.12.04.000 Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: MARC Bibliographic record staging/import Assignee: gmcharlt(a)gmail.com Reporter: jesus(a)medios.es QA Contact: testopia(a)bugs.koha-community.org Created attachment 41920 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=41920&action=edit Screenshot job progress stuck at 0% Using no matchig rule while importing a staged batch, the Manage Staged MARC Records gets stuck at 0%. I can see a www-data owned background job running but the browser is stuck at 0% and no entries in the db. Tried leaving it overnight with no progress. Tried with ie and chrome. Same MARC file is imported fine in EOS.web. See attached records (only 8) in MARC21 format causing the issue. See attached screenshot for rules used during this import. -- You are receiving this mail because: You are watching all bug changes.

1 2

[Bug 11493] New: Batch Item Modification not handling unicode characters
by bugzilla-daemon＠bugs.koha-community.org 25 Aug '15

25 Aug '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11493 Bug ID: 11493 Summary: Batch Item Modification not handling unicode characters Change sponsored?: --- Product: Koha Version: 3.14 Hardware: All OS: All Status: NEW Severity: critical Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: gmcharlt(a)gmail.com Reporter: karamqubsi(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org Hi, Today while trying to make a batch modification for 10 items related to one bib record , we entered an Arabic characters (ق ك و ) in the -o subfield and we get bad results :Ù Ù Ù you can try this by open a bib record with more than 1 item , select all items chose Modify selected items try to enter some Arabic character in any sub-field like in (x - Non-public note) you can put any letters from the Arabic alphabetic ( أ ب ت ث ج ح ...) save . and you will see the results . -- You are receiving this mail because: You are watching all bug changes.

1 12

[Bug 14664] New: Harvesting records of an non-existent set, instead of an error return all the records
by bugzilla-daemon＠bugs.koha-community.org 25 Aug '15

25 Aug '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14664 Bug ID: 14664 Summary: Harvesting records of an non-existent set, instead of an error return all the records Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: minor Priority: P5 - low Component: Web services Assignee: koha-bugs(a)lists.koha-community.org Reporter: pablo.bianchi(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org Steps: - Enable syspref OAI-PMH and leave OAI-PMH:ConfFile empty. - Set an OAI set on Home › Administration › OAI sets configuration - Remember the setSpec you choose (the real set primary key), for example setSpec==THESIS - Fetch with set=THESIS, you will get records on that set. - Now fetch records with set=bananas. Expected result: A badArgument error like this one: http://digital.bl.fcen.uba.ar/gsdl-282/cgi-bin/oaiserver.cgi?verb=ListRecor… (Greenstone v2.82) Actual result: List ALL records, like here: http://catalog.bywatersolutions.com/cgi-bin/koha/oai.pl?verb=ListRecords&fr… Reference: https://www.openarchives.org/OAI/2.0/guidelines-harvester.htm#Sets https://www.openarchives.org/OAI/openarchivesprotocol.html#ErrorConditions -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 1

[Bug 14704] New: members/statistics.pl crashes because the SQL 'return'-keyword might be reserved at 'return FROM ('
by bugzilla-daemon＠bugs.koha-community.org 25 Aug '15

25 Aug '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14704 Bug ID: 14704 Summary: members/statistics.pl crashes because the SQL 'return'-keyword might be reserved at 'return FROM (' Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Patrons Assignee: koha-bugs(a)lists.koha-community.org Reporter: olli-antti.kivilahti(a)jns.fi QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com At Ubuntu 14.04 using MariaDB, the following SQL doesn't work: SELECT COUNT(*) as count_precedent_state,issues,onloan,return FROM ( SELECT it.* FROM issues i, items it WHERE i.borrowernumber = 1234 AND i.itemnumber = it.itemnumber AND DATE(i.issuedate) < CAST(now() AS date) UNION SELECT it.* FROM old_issues oi, items it WHERE oi.borrowernumber = 1234 AND oi.itemnumber = it.itemnumber AND DATE(oi.issuedate) < CAST(now() AS date) AND DATE(oi.returndate) = CAST(now() AS date) ) tmp GROUP BY issues,onloan,return; We get "Syntax error near 'return FROM ('" This patch changes the SQL to prefix the selected columns with a table name prefix, so we get: SELECT COUNT(*) as count_precedent_state,tmp.issues,tmp.onloan,tmp.return FROM ( SELECT it.* FROM issues i, items it WHERE i.borrowernumber = 1234 AND i.itemnumber = it.itemnumber AND DATE(i.issuedate) < CAST(now() AS date) UNION SELECT it.* FROM old_issues oi, items it WHERE oi.borrowernumber = 1234 AND oi.itemnumber = it.itemnumber AND DATE(oi.issuedate) < CAST(now() AS date) AND DATE(oi.returndate) = CAST(now() AS date) ) tmp GROUP BY tmp.issues,tmp.onloan,tmp.return; Which is more formal and less implicit. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 6

[Bug 14712] New: Feature for controlling cron jobs/cmd line scripts from staff client
by bugzilla-daemon＠bugs.koha-community.org 25 Aug '15

25 Aug '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14712 Bug ID: 14712 Summary: Feature for controlling cron jobs/cmd line scripts from staff client Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: new feature Priority: P5 - low Component: Command-line Utilities Assignee: gmcharlt(a)gmail.com Reporter: eivin(a)sysmystic.com QA Contact: testopia(a)bugs.koha-community.org CC: robin(a)catalyst.net.nz This feature will add an admin page to the staff client enabling superusers to trigger cron or other scripts without having to rely on a server admin. -- You are receiving this mail because: You are watching all bug changes.

1 3