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

[Bug 8843] New: Cannot export bibliographic records by call number
by bugzilla-daemon＠bugs.koha-community.org 13 Dec '12

13 Dec '12

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8843 Priority: P5 - low Change sponsored?: --- Bug ID: 8843 Assignee: oleonard(a)myacpl.org Summary: Cannot export bibliographic records by call number Severity: normal Classification: Unclassified OS: All Reporter: oleonard(a)myacpl.org Hardware: All Status: ASSIGNED Version: master Component: Tools Product: Koha The logic is wrong when building the query: if ($start_callnumber) { $sql_query .= " AND itemcallnumber <= ? "; push @sql_params, $start_callnumber; } if ($end_callnumber) { $sql_query .= " AND itemcallnumber >= ? "; push @sql_params, $end_callnumber; } The query must include items with call numbers *greater than* the starting call number and *less than* the ending call number, not vice versa. -- You are receiving this mail because: You are watching all bug changes.

1 14

[Bug 8039] New: Self Checkout/SIP: Allow authentication with userid and password
by bugzilla-daemon＠bugs.koha-community.org 13 Dec '12

13 Dec '12

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8039 Priority: P5 - low Change sponsored?: --- Bug ID: 8039 Assignee: katrin.fischer(a)bsz-bw.de Summary: Self Checkout/SIP: Allow authentication with userid and password Severity: enhancement Classification: Unclassified OS: All Reporter: katrin.fischer(a)bsz-bw.de Hardware: All Status: NEW Version: master Component: SIP2 Product: Koha Currently only cardnumber + password can be used to authenticate via SIP. This is ok for self check stations where you scan the patron card, but can be a problem if you want to use SIP2 for authentication with other services. If the username does not exist as cardnumber in the system, the userid field should be checked next. -- You are receiving this mail because: You are watching all bug changes.

1 17

[Bug 5709] New: Adding the ability to translate HTML5 text in an input field
by bugzilla-daemon＠bugs.koha-community.org 13 Dec '12

13 Dec '12

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5709 Summary: Adding the ability to translate HTML5 text in an input field Change sponsored?: Sponsored Product: Koha Version: rel_3_2 Platform: All OS/Version: All Status: ASSIGNED Severity: enhancement Priority: P5 Component: I18N/L10N AssignedTo: brice.sanchez(a)sys-tech.net ReportedBy: brice.sanchez(a)sys-tech.net QAContact: koha-bugs(a)lists.koha-community.org Estimated Hours: 0.0 In our version of Koha, we use a placeholder text in the main search box (with jquery effects if the browser doesn't support placeholder). So we need to patch the translator in order to be able to translate the sentence in placeholder. It would be a great feature for the translator script. -- 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 12

[Bug 7271] New: Change sort on detail.pl to be by home library instead of holding branch
by bugzilla-daemon＠bugs.koha-community.org 11 Dec '12

11 Dec '12

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7271 Bug #: 7271 Summary: Change sort on detail.pl to be by home library instead of holding branch Classification: Unclassified Change sponsored?: --- Product: Koha Version: rel_3_8 Platform: All OS/Version: All Status: NEW Severity: enhancement Priority: P5 - low Component: Staff Client AssignedTo: paul.poulain(a)biblibre.com ReportedBy: wizzyrea(a)gmail.com QAContact: ian.walls(a)bywatersolutions.com CC: gmcharlt(a)gmail.com The fix to bug 6600 changed the default sort order of the items display - it used to order by home branch and now it orders by holding branch, a source of confusion for our libraries. There are a couple of ways to fix this problem - 1. tablesort items and set the default sort 2. change the default ORDER BY in Items.pm I have a patch for 2, but am worried about ramifications of that change. 1 might cause problems for bibs with many items. What do you think, which is better? -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are watching all bug changes.

1 14

[Bug 8527] New: enter patron that suggestions is for
by bugzilla-daemon＠bugs.koha-community.org 11 Dec '12

11 Dec '12

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8527 Priority: P5 - low Change sponsored?: --- Bug ID: 8527 Assignee: koha-bugs(a)lists.koha-community.org Summary: enter patron that suggestions is for Severity: enhancement Classification: Unclassified OS: All Reporter: nengard(a)gmail.com Hardware: All Status: NEW Version: master Component: Acquisitions Product: Koha When entering a purchase suggestion on the staff client it should let you link it to a patron account. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 1

[Bug 7896] New: Acquisition statistics wizard: add filters and cell values
by bugzilla-daemon＠bugs.koha-community.org 10 Dec '12

10 Dec '12

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7896 Priority: P5 - low Change sponsored?: Sponsored Bug ID: 7896 Assignee: julian.maurice(a)biblibre.com Summary: Acquisition statistics wizard: add filters and cell values QA Contact: koha.sekjal(a)gmail.com Severity: enhancement Classification: Unclassified OS: All Reporter: julian.maurice(a)biblibre.com Hardware: All Status: ASSIGNED Version: master Component: Reports Product: Koha This development, sponsored by Aix-Marseille university, add the following changes: - Possibility to select for line and column: items.homebranch and items.ccode - Possibility to filter on these fields - Possibility to count unique biblios (count(distinct biblionumber)), ordered amount and spent amount (based on aqorders.datereceived) -- You are receiving this mail because: You are watching all bug changes.

1 19

[Bug 7443] New: Change the mysql commands in the INSTALL.* files
by bugzilla-daemon＠bugs.koha-community.org 09 Dec '12

09 Dec '12

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7443 Bug #: 7443 Summary: Change the mysql commands in the INSTALL.* files Classification: Unclassified Change sponsored?: --- Product: Koha Version: master Platform: All OS/Version: All Status: NEW Severity: enhancement Priority: P5 - low Component: Documentation AssignedTo: nengard(a)gmail.com ReportedBy: magnus(a)enger.priv.no QAContact: ian.walls(a)bywatersolutions.com Currently the instructions in INSTALL.debian, INSTALL.ubuntu and INSTALL.ubuntu.lucid for setting up the database looks like this: 103 $ mysqladmin -uroot -p<password> create <kohadatabasename> 104 $ mysql -uroot -p<password> 105 106 Welcome to the MySQL monitor. Commands end with ; or \g. 107 Your MySQL connection id is 22 108 Server version: 5.0.51a-24 (Debian) 109 110 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. 111 112 mysql> grant all on <kohadatabasename>.* to '<kohadatabaseuser>'@'localhost' identified by '<kohadatabaseuserpassword>'; 113 Query OK, 0 rows affected (0.00 sec) 114 115 mysql> flush privileges; 116 Query OK, 0 rows affected (0.00 sec) Speaking as a not overly experienced Linux user, I think this would be slightly easier to understand: -------------------------------------------------------- $ mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 22 Server version: 5.0.51a-24 (Debian) Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> create database <kohadatabasename>; mysql> grant all on <kohadatabasename>.* to '<kohadatabaseuser>'@'localhost' identified by '<kohadatabaseuserpassword>'; Query OK, 0 rows affected (0.00 sec) mysql> flush privileges; Query OK, 0 rows affected (0.00 sec) -------------------------------------------------------- This would: - avoid the constrct -uroot, which might be mistaken for a long option with one dash - use the mysql command for everything, and not drag mysqladmin into it - avoid putting the password on the commandline and thence potentially into the output of commands like top and ps, and the bash history file Opinions? Not so sure about these: - INSTALL.fedora7 has "mysql-u root-p" which i assume is a typo for "mysql -u root -p"? - INSTALL.opensuse has "mysqladmin -uroot create koha -p" which i think might be re-written in the way i suggest above? -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are watching all bug changes.

1 1

[Bug 8588] New: Duplicate field IDs cause problems with SQL report parameter entry
by bugzilla-daemon＠bugs.koha-community.org 08 Dec '12

08 Dec '12

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8588 Priority: P5 - low Change sponsored?: --- Bug ID: 8588 Assignee: oleonard(a)myacpl.org Summary: Duplicate field IDs cause problems with SQL report parameter entry Severity: normal Classification: Unclassified OS: All Reporter: oleonard(a)myacpl.org Hardware: All Status: ASSIGNED Version: master Component: Reports Product: Koha When the SQL repots template displays form fields for entering runtime parameters the fields do not have unique ids. This prevents correct label+input markup from being possible and causes buggy behavior by the jQueryUI datepicker widget. -- You are receiving this mail because: You are watching all bug changes.

1 13

[Bug 8874] New: export_borrowers.pl : add a separator parameter
by bugzilla-daemon＠bugs.koha-community.org 07 Dec '12

07 Dec '12

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8874 Priority: P5 - low Change sponsored?: --- Bug ID: 8874 Assignee: adrien.saurat(a)biblibre.com Summary: export_borrowers.pl : add a separator parameter Severity: enhancement Classification: Unclassified OS: All Reporter: adrien.saurat(a)biblibre.com Hardware: All Status: ASSIGNED Version: master Component: Command-line Utilities Product: Koha The patron export is now creating CSV files with a comma separator. It's sometimes useful to be able to use another character as a separator. Adding a --separator for this would help. -- You are receiving this mail because: You are watching all bug changes.

1 11

[Bug 8545] New: ZOOM is silent on connection errors
by bugzilla-daemon＠bugs.koha-community.org 06 Dec '12

06 Dec '12

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8545 Priority: P5 - low Change sponsored?: --- Bug ID: 8545 Assignee: gmcharlt(a)gmail.com Summary: ZOOM is silent on connection errors Severity: enhancement Classification: Unclassified OS: All Reporter: starsid(a)gmail.com Hardware: All Status: NEW Version: unspecified Component: Searching Product: Koha In file Context.pm, # forge to server $Zconn->connect($host, 0); # check for errors and warn if ($Zconn->errcode() !=0) { warn "something wrong with the connection: ". $Zconn->errmsg(); } the error checking code does not warn when I change $host to something garbage. The subsequent search query just returns an empty set without any errors. OS: Ubuntu 12.04 Koha: 3.9-1~git+20120524174206.f9352e89 Zoom: 1.26-1build2 I also checked this on CentOS 6.2 with Koha 3.08.03 and ZOOM installed as the latest version from the latest CPAN (I can check exact version numbers if needed). -- You are receiving this mail because: You are watching all bug changes.

1 4