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

[Bug 2479] New: MARC21 440 not linking to authority records
by bugzilla-daemon＠pippin.metavore.com 06 Aug '08

06 Aug '08

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=2479 Summary: MARC21 440 not linking to authority records Product: Koha Version: rel_3_0 Platform: All OS/Version: All Status: NEW Severity: normal Priority: PATCH-Sent Component: Cataloging AssignedTo: galen.charlton(a)liblime.com ReportedBy: galen.charlton(a)liblime.com QAContact: koha-bugs(a)lists.koha.org MARC21 440 fields (series statement/added entry) were not being linked to applicable uniform title authority records when link_bibs_to_authorities.pl was run. Patch submitted to correct this. ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 2084] Warn staff about resource hogging scripts
by bugzilla-daemon＠pippin.metavore.com 06 Aug '08

06 Aug '08

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=2084 ------- Comment #7 from Andrew.moore(a)liblime.com 2008-08-06 09:17 ------- I sent in two patches: http://markmail.org/message/debim3iyj3hghrkh These add warnings to: staff interface circulation page concerning circ/overdues.pl system preferences: OPACShelfBrowser, NoZebra, and CataloguingLog This does not address the possible need for something to be done about ysearch.pl that may cause a problem for patron name completion in the circulation search box. This also does not actually make these features work better. It just warns of the shortcomings. ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 1433] 'Add Subscription' should populate biblionumber if done from the subscriptions view of a biblio
by bugzilla-daemon＠pippin.metavore.com 06 Aug '08

06 Aug '08

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=1433 jmf(a)liblime.com changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution| |FIXED ------- Comment #9 from jmf(a)liblime.com 2008-08-06 08:32 ------- fixed, thanks Galen! ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 2478] New: Nothing is output to the .csv file for the "Overdues" circulation report
by bugzilla-daemon＠pippin.metavore.com 06 Aug '08

06 Aug '08

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=2478 Summary: Nothing is output to the .csv file for the "Overdues" circulation report Product: Koha Version: rel_3_0 Platform: PC OS/Version: All Status: NEW Severity: major Priority: P3 Component: Circulation AssignedTo: galen.charlton(a)liblime.com ReportedBy: debra.denault(a)liblime.com QAContact: koha-bugs(a)lists.koha.org When a library runs the "Overdues" circulation report (overdue.pl) and wishes to download the file of all overdues, when the .csv file is saved and opened it is empty no matter what one uses to open up the file. ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 2287] Patron Import CSV far too strict
by bugzilla-daemon＠pippin.metavore.com 06 Aug '08

06 Aug '08

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=2287 ------- Comment #4 from joe.atzberger(a)liblime.com 2008-08-06 07:58 ------- Sent a patch incorporating MJ's with some other niceties thrown in. ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 2477] New: Improve Speed of the Shelf Browser
by bugzilla-daemon＠pippin.metavore.com 06 Aug '08

06 Aug '08

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=2477 Summary: Improve Speed of the Shelf Browser Product: Koha Version: rel_3_2 Platform: PC OS/Version: All Status: NEW Severity: normal Priority: P3 Component: OPAC AssignedTo: jmf(a)liblime.com ReportedBy: jmf(a)liblime.com QAContact: koha-bugs(a)lists.koha.org >From Clay: Going into shelf browsing mode elicits two queries in the form of: SELECT * FROM items WHERE CONCAT(cn_sort,itemnumber) <= ? AND homebranch=? AND location=? ORDER BY CONCAT(cn_sort,itemnumber) DESC LIMIT 3; SELECT * FROM items WHERE CONCAT(cn_sort,itemnumber) >= ? AND homebranch=? AND location=? ORDER BY CONCAT(cn_sort,itemnumber) ASC LIMIT 3; Several problems with this. First, the CONCAT in the ordering statement is superfluous. There's no difference between the results of the above query and one sort with "ORDER BY cn_sort, itemnumber", yet the CONCAT() takes more time. Next, the cn_sort and location columns are not indexed. Third, the CONCAT() in the WHERE clause will kill any benefit gleaned from the indexing of cn_sort and itemnumber. I don't understand the koha schema very well, but is there any difference between the output from the above queries and ones like: SELECT * FROM items WHERE cn_sort <= ? AND itemnumber < ? AND homebranch=? AND location=? ORDER BY cn_sort,itemnumber DESC LIMIT 3; SELECT * FROM items WHERE cn_sort >= ? AND itemnumber > ? AND homebranch=? AND location=? ORDER BY cn_sort,itemnumber ASC LIMIT 3; This is just a further observation. I haven't empirically tested to see how much more efficient these changes would actually be. All I know for sure is that these queries comprise the bulk of the slow query log. >From Ryan: The concat is to make sure the shelf browser references the correct items. cn_sort is not unique, but should be unique for a title. Then the itemnumbers are unique within that title. By doing the concats, we can pick the unique items on either side of the physical shelf, and be sure that the specific copy of the book that is showing a link to the shelf browser will be the one in the middle of the displayed set. So 1/ index location column 2/ consider implementing shelfbrowser as a separate table for the moment, since we shouldn't really be adding columns to the items table at this point. >From Galen: Might something like this work? SELECT * FROM items WHERE ((cn_sort = ? AND itemnumber >= ?) OR (cn_sort > ?)) AND homebranch = ? AND location = ? ORDER BY cn_sort, itemnumber ASC LIMIT 3 >From Joe: I think we can change the ORDER BY clauses as recommended at the very least. >From Clay: Unfortunately, because concat() evaluates to a string and ordering evaluates itemnumber as an integer, it doesn't work as expected because itemnumber rendered as string doesn't have a constant length. If there a way to zero pad an integer before squeezing it into a WHERE clause? ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 2451] when recieving (with item creation), Koha always complaint for barcode exist
by bugzilla-daemon＠pippin.metavore.com 06 Aug '08

06 Aug '08

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=2451 ------- Comment #5 from jmf(a)liblime.com 2008-08-06 07:45 ------- Here's the patch notes from HDL's recent submission of this patch; If barcode already exists, then return an error. making some checks on values passed through the code. Duplicated serialid and subscriptionid are displayed only once. This manage multiple errors on barcode and displays them. ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 2361] Serials Add Items Missing Important Data
by bugzilla-daemon＠pippin.metavore.com 06 Aug '08

06 Aug '08

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=2361 Bug 2361 depends on bug 2470, which changed state. Bug 2470 Summary: Serials Editing Forgetting Library http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=2470 What |Old Value |New Value ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution| |FIXED ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 2470] Serials Editing Forgetting Library
by bugzilla-daemon＠pippin.metavore.com 06 Aug '08

06 Aug '08

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=2470 nicole.engard(a)liblime.com changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution| |FIXED ------- Comment #7 from nicole.engard(a)liblime.com 2008-08-06 07:25 ------- Tested again and it works ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 2361] Serials Add Items Missing Important Data
by bugzilla-daemon＠pippin.metavore.com 06 Aug '08

06 Aug '08

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=2361 nicole.engard(a)liblime.com changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution| |FIXED ------- Comment #7 from nicole.engard(a)liblime.com 2008-08-06 06:11 ------- Awesome - tested & works!! ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0