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

[Bug 8329] New: GetLostItems in C4::Items.pm has a SELECT *
by bugzilla-daemon＠bugs.koha-community.org 29 Aug '12

29 Aug '12

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8329 Priority: P5 - low Change sponsored?: --- Bug ID: 8329 Assignee: gmcharlt(a)gmail.com Summary: GetLostItems in C4::Items.pm has a SELECT * Severity: major Classification: Unclassified OS: All Reporter: mtompset(a)hotmail.com Hardware: All Status: NEW Version: unspecified Component: Reports Product: Koha my $query = " SELECT * FROM items LEFT JOIN biblio ON (items.biblionumber = biblio.biblionumber) LEFT JOIN biblioitems ON (items.biblionumber = biblioitems.biblionumber) LEFT JOIN authorised_values ON (items.itemlost = authorised_values.authorised_value) WHERE authorised_values.category = 'LOST' AND itemlost IS NOT NULL AND itemlost <> 0 "; We're using 3.6.3, and I comfirmed this is in 3.6.6. This problem would only be obvious if there are many lost items. It is a hellish query as we have 39,000+ "lost" items. We're in the midst of doing data entry/cleanup on a new system. my $query = " SELECT title, author, lib, itemlost, authorised_value, barcode, datelastseen, price, replacementprice, homebranch, itype, itemtype, holdingbranch, location, itemnotes, items.biblionumber as biblionumber FROM items LEFT JOIN biblio ON (items.biblionumber = biblio.biblionumber) LEFT JOIN biblioitems ON (items.biblionumber = biblioitems.biblionumber) LEFT JOIN authorised_values ON (items.itemlost = authorised_values.authorised_value) WHERE authorised_values.category = 'LOST' AND itemlost IS NOT NULL AND itemlost <> 0 "; This is functional, though it can probably be trimmed. The SELECT * includes XML and MARC fields which are sizable and eat system memory! -- You are receiving this mail because: You are watching all bug changes.

1 10

[Bug 8162] New: koha-restore creates user incorrectly
by bugzilla-daemon＠bugs.koha-community.org 29 Aug '12

29 Aug '12

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8162 Priority: P5 - low Change sponsored?: --- Bug ID: 8162 Assignee: jcamins(a)cpbibliography.com Summary: koha-restore creates user incorrectly Severity: critical Classification: Unclassified OS: All Reporter: jcamins(a)cpbibliography.com Hardware: All Status: NEW Version: master Component: Packaging Product: Koha For reasons that are unclear, the user created by koha-restore will not allow Koha to log into MySQL (oddly, an identical script worked fine for me on my 3.6.3-based install). The result is that after running koha-restore on a new system (and possibly even when just restoring a backup), Koha is entirely nonfunctional. Patch forthcoming. -- You are receiving this mail because: You are watching all bug changes.

1 16

[Bug 8172] New: Missing dereference marker for buildQuery parameter in addbooks.pl
by bugzilla-daemon＠bugs.koha-community.org 29 Aug '12

29 Aug '12

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8172 Priority: P5 - low Change sponsored?: --- Bug ID: 8172 Assignee: gmcharlt(a)gmail.com Summary: Missing dereference marker for buildQuery parameter in addbooks.pl Severity: major Classification: Unclassified OS: All Reporter: mtompset(a)hotmail.com Hardware: All Status: NEW Version: unspecified Component: Searching Product: Koha my ( $builterror,$builtquery,$simple_query,$query_cgi,$query_desc,$limit,$limit_cgi,$limit_desc,$stopwords_removed,$query_type) = buildQuery(\@operators,\@operands,\@indexes,@limits,\@sort_by,undef,undef); Which is roughly line 75 of addbooks.pl likely should have a \ on the @limits. Because C4::Search.pm around line 1044 shows the parameters being treated the same. I was hoping this would solve my Lingua::Stem::Snowball error, but I will have to continue to hunt deeper. -- You are receiving this mail because: You are watching all bug changes.

1 12

[Bug 8501] New: I am encountered a problem when I want to edit an item from the "edit Item" menu. It gives the message "Software error: Can't call method "subfield" on an undefined value at /usr/share/koha/intranet/cgi-bin/cataloguing/additem.pl line 607."
by bugzilla-daemon＠bugs.koha-community.org 29 Aug '12

29 Aug '12

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8501 Priority: P5 - low Change sponsored?: --- Bug ID: 8501 CC: m.de.rooy(a)rijksmuseum.nl Assignee: gmcharlt(a)gmail.com Summary: I am encountered a problem when I want to edit an item from the "edit Item" menu. It gives the message "Software error: Can't call method "subfield" on an undefined value at /usr/share/koha/intranet/cgi-bin/cataloguing/additem.p l line 607." Severity: critical Classification: Unclassified OS: Linux Reporter: irfan.a.mirza(a)gmail.com Hardware: All Status: NEW Version: rel_3_2 Component: Cataloging Product: Koha -- You are receiving this mail because: You are watching all bug changes.

1 8

[Bug 8356] New: moveitem.tt and linkitem.tt have cataloging typo
by bugzilla-daemon＠bugs.koha-community.org 27 Aug '12

27 Aug '12

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8356 Priority: P5 - low Change sponsored?: --- Bug ID: 8356 Assignee: oleonard(a)myacpl.org Summary: moveitem.tt and linkitem.tt have cataloging typo Severity: major Classification: Unclassified OS: All Reporter: mtompset(a)hotmail.com Hardware: All Status: NEW Version: unspecified Component: Templates Product: Koha There is no .../cataloging/addbooks.pl Need to fix a typographical error in these two files. -- You are receiving this mail because: You are watching all bug changes.

1 9

[Bug 6423] New: permission for editing other library's stuff
by bugzilla-daemon＠bugs.koha-community.org 24 Aug '12

24 Aug '12

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6423 Bug #: 6423 Summary: permission for editing other library's stuff Classification: Unclassified Change sponsored?: --- Product: Koha Version: master Platform: All OS/Version: All Status: NEW Severity: enhancement Priority: P5 Component: Patrons AssignedTo: kyle.m.hall(a)gmail.com ReportedBy: nengard(a)gmail.com QAContact: koha-bugs(a)lists.koha-community.org CC: gmcharlt(a)gmail.com Right now there is a preference to control if people from one library can edit things from another library, it would be nice if there was a permission (other than superlibrarian) that allowed certain staff members the ability to edit stuff from all libraries regardless of this preference's setting. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.

1 1

[Bug 7943] New: Untranslatable strings in OPAC's authority search
by bugzilla-daemon＠bugs.koha-community.org 24 Aug '12

24 Aug '12

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7943 Priority: P5 - low Change sponsored?: --- Bug ID: 7943 Assignee: frederic(a)tamil.fr Summary: Untranslatable strings in OPAC's authority search QA Contact: koha.sekjal(a)gmail.com Severity: normal Classification: Unclassified OS: All Reporter: katrin.fischer(a)bsz-bw.de URL: cgi-bin/koha/opac-authorities-home.pl?... Hardware: All Status: NEW Version: master Component: I18N/L10N Product: Koha Created attachment 9111 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=9111&action=edit screenshot used for/see from: is not translatable as is the "Default" name for the default framework. I think the problem is the way the display is built: http://git.koha-community.org/gitweb/?p=koha.git;a=blob;f=C4/AuthoritiesMar… Another issue with the display is, that all authorities show up as Default, while they are correct in the database. -- You are receiving this mail because: You are watching all bug changes.

1 18

[Bug 6599] New: Don't show dictionary definition table if there are no definitions
by bugzilla-daemon＠bugs.koha-community.org 23 Aug '12

23 Aug '12

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6599 Bug #: 6599 Summary: Don't show dictionary definition table if there are no definitions Classification: Unclassified Change sponsored?: --- Product: Koha Version: master Platform: All URL: /cgi-bin/koha/reports/dictionary.pl?phase=View Dictionary OS/Version: All Status: ASSIGNED Severity: minor Priority: P5 Component: Reports AssignedTo: oleonard(a)myacpl.org ReportedBy: oleonard(a)myacpl.org QAContact: koha-bugs(a)lists.koha-community.org If there are no definitions, don't show the "filter by" form or the table header. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.

1 8

[Bug 6768] New: Two unused include files can be removed: error-top.inc and error-bottom.inc
by bugzilla-daemon＠bugs.koha-community.org 23 Aug '12

23 Aug '12

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6768 Bug #: 6768 Summary: Two unused include files can be removed: error-top.inc and error-bottom.inc Classification: Unclassified Change sponsored?: --- Product: Koha Version: master Platform: All OS/Version: All Status: ASSIGNED Severity: minor Priority: P5 Component: Templates AssignedTo: oleonard(a)myacpl.org ReportedBy: oleonard(a)myacpl.org QAContact: koha-bugs(a)lists.koha-community.org error-top.inc and error-bottom.inc do not appear to be used anywhere and should be removed. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.

1 6

[Bug 4988] New: password field in change password form should not display
by bugzilla-daemon＠bugs.koha-community.org 23 Aug '12

23 Aug '12

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=4988 Summary: password field in change password form should not display Change sponsored?: --- Product: Koha Version: rel_3_4 Platform: All OS/Version: All Status: NEW Severity: enhancement Priority: P5 Component: Patrons AssignedTo: kyle.m.hall(a)gmail.com ReportedBy: irma(a)calyx.net.au QAContact: koha-bugs(a)lists.koha-community.org CC: gmcharlt(a)gmail.com Estimated Hours: 0.0 Patrons do not wish their new password visible to bystanders. Type of HTML input field should be password, not text. However this interacts with the "suggested password" feature so either this would be deprecated, or provided in some other way. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA contact for the bug.

1 2