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

[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 5424] New: Intranet interface references intranet/htdocs/opac-tmpl which does not exist
by bugzilla-daemon＠bugs.koha-community.org 05 Dec '12

05 Dec '12

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5424 Summary: Intranet interface references intranet/htdocs/opac-tmpl which does not exist Change sponsored?: --- Product: Koha Version: rel_3_2 Platform: All OS/Version: All Status: NEW Severity: normal Priority: P5 Component: Searching AssignedTo: gmcharlt(a)gmail.com ReportedBy: dpk(a)randomnotes.org QAContact: koha-bugs(a)lists.koha-community.org Estimated Hours: 0.0 A number of different searches appear to generate references to intranet/htdocs/opac-tmpl which does not exist. Example: Home > Authorities Authority search for "England" => get a hit with 611 biblios. Select biblios to see the first 20 => a list of biblio entries This was the URL: http://kohaadmin.efdss.org/cgi-bin/koha/catalogue/search.pl?type=intranet&o… This was logged in koha-error_log: [Sun Nov 21 13:48:59 2010] [error] [client 92.234.0.16] File does not exist: /usr/share/koha/intranet/htdocs/opac-tmpl, referer: http://kohaadmin.efdss.org/cgi-bin/koha/catalogue/search.pl?type=intranet&o… -- 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 4

[Bug 7439] New: Mailmap for 3.6.x not complete
by bugzilla-daemon＠bugs.koha-community.org 03 Dec '12

03 Dec '12

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7439 Bug #: 7439 Summary: Mailmap for 3.6.x not complete Classification: Unclassified Change sponsored?: --- Product: Koha Version: rel_3_6 Platform: All OS/Version: All Status: NEW Severity: enhancement Priority: P5 - low Component: Developer documentation AssignedTo: gmcharlt(a)gmail.com ReportedBy: jcamins(a)cpbibliography.com QAContact: ian.walls(a)bywatersolutions.com The mailmap for 3.6.x is not complete. This bug is for tracking patches to fill in missing information. -- 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 24

[Bug 7475] New: Option to overlay authorities
by bugzilla-daemon＠bugs.koha-community.org 03 Dec '12

03 Dec '12

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7475 Bug #: 7475 Summary: Option to overlay authorities Classification: Unclassified Change sponsored?: Seeking cosponsors Product: Koha Version: master Platform: All OS/Version: All Status: NEW Severity: enhancement Priority: P5 - low Component: MARC Authority data support AssignedTo: jcamins(a)cpbibliography.com ReportedBy: jcamins(a)cpbibliography.com QAContact: koha.sekjal(a)gmail.com Depends on: 7284 Right now it is impossible to overlay existing records when importing new authority records. There needs to be a script that handles the following overlay options: * Overlay (or discard) based on matching preferred headings (1xx in MARC21, 2xx in UNIMARC) * Overlay (or discard) based on matching LCCNs (010 in MARC21) * Overlay (or discard) based on matching control numbers (001 for both MARC21 and UNIMARC) * Overlay (or discard) based on matching an earlier form of the heading (4xx$w/2=[aeo] in MARC21, 4xx$5=a in UNIMARC) * Select which record to keep based on the date last modified (003 in MARC21) This script will enable libraries to keep their authority records up to date with the latest national authority files, without polluting the local authority file with numerous copies of authority records (every time they are updated). -- 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 19

[Bug 7698] New: Add ICU option to Koha out of the box
by bugzilla-daemon＠bugs.koha-community.org 03 Dec '12

03 Dec '12

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7698 Priority: P5 - low Change sponsored?: --- Bug ID: 7698 Assignee: frederic(a)tamil.fr Blocks: 3216 Summary: Add ICU option to Koha out of the box QA Contact: koha.sekjal(a)gmail.com Severity: enhancement Classification: Unclassified OS: All Reporter: jcamins(a)cpbibliography.com Hardware: All Status: NEW Version: master Component: I18N/L10N Product: Koha Word search with multi-part facets works properly only with Zebra ICU tokenization. This patch add a new question to Koha command line installer: Zebra has two methods to perform records tokenization and characters normalization: CHR and ICU. ICU is recommended for catalogs containing non-Latin characters. (chr, icu) [chr] How to test: - perl ./Makefile.PL - Try each possible value for new parameter - Take a look at zebradb/etc/default.idx file. Depending of the parameter you get this line: icuchain words-icu.xml or this one: charmap word-phrase-utf.chr (copied from bug 3216) -- You are receiving this mail because: You are watching all bug changes.

1 6

[Bug 6800] New: Koha authentication should handle proxies better
by bugzilla-daemon＠bugs.koha-community.org 03 Dec '12

03 Dec '12

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6800 Bug #: 6800 Summary: Koha authentication should handle proxies better Classification: Unclassified Change sponsored?: --- Product: Koha Version: rel_3_6 Platform: All OS/Version: All Status: NEW Severity: enhancement Priority: P5 Component: Authentication AssignedTo: jcamins(a)cpbibliography.com ReportedBy: jcamins(a)cpbibliography.com QAContact: koha-bugs(a)lists.koha-community.org CC: dpavlin(a)rot13.org At the moment, Koha's authentication/session feature uses the remote address for its sessions. In situations with load balancers or other proxies, the REMOTE_ADDRESS will be the proxy address rather than the client address. In order to handle proxied clients (or any clients when behind a load balancer), Koha needs to use the X-Forwarded-For header to identify the ultimate client. This problem can be seen by configuring Koha to listen on 127.0.0.1 and setting up a Squid proxy with the following configuration options on the same server: # BEGIN SQUID CONFIGURATION # The next two lines must go at the top of the squid configuration file: http_port ${PUBLIC_IP}:80 accel defaultsite=${YOUR_DOMAIN} vhost cache_peer 127.0.0.1 parent 80 0 no-query originserver name=myAccel # The next four lines must go AFTER the line "acl CONNECT method CONNECT acl our_sites dstdomain .${YOUR_DOMAIN} http_access allow our_sites cache_peer_access myAccel allow our_sites cache_peer_access myAccel deny all # END SQUID CONFIGURATION If you view the session log after connecting via ${PUBLIC_IP}:80, you will see an entry for 127.0.0.1. Although X-Forwarded-For can be spoofed, in situations where all clients would have the same immediate REMOTE_ADDRESS (e.g. load balancing, reverse proxy, corporate firewall), using X-Forwarded-For seems the lesser of two evils (if you're running the proxy, you can guarantee that the most recent entry in X-Forwarded-For is accurate). -- 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 13

[Bug 6602] New: Reports dictionary doesn't properly recognize text columns
by bugzilla-daemon＠bugs.koha-community.org 02 Dec '12

02 Dec '12

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6602 Bug #: 6602 Summary: Reports dictionary doesn't properly recognize text columns Classification: Unclassified Change sponsored?: --- Product: Koha Version: master Platform: All URL: /cgi-bin/koha/reports/dictionary.pl OS/Version: All Status: ASSIGNED Severity: normal Priority: P5 Component: Reports AssignedTo: oleonard(a)myacpl.org ReportedBy: oleonard(a)myacpl.org QAContact: koha-bugs(a)lists.koha-community.org When defining a dictionary definition the script checks the type of the table column you have selected. If you've chosen a DATE column it displays date limiters, if you've chosen a VARCHAR column it shows a <select> of choices. If you choose a TEXT column you'll get a free text input to specify the comparison. However, the script doesn't check for MEDIUMTEXT. This means if you choose one of several MEDIUMTEXT columns you won't be able to input any string for comparison. -- 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 25

[Bug 5801] New: C4::Circulation::_GetCircControlBranch doesn't work in opac-reserve.pl
by bugzilla-daemon＠bugs.koha-community.org 30 Nov '12

30 Nov '12

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5801 Bug #: 5801 Summary: C4::Circulation::_GetCircControlBranch doesn't work in opac-reserve.pl Classification: Unclassified Change sponsored?: --- Product: Koha Version: rel_3_2 Platform: All OS/Version: All Status: NEW Severity: normal Priority: P5 Component: OPAC AssignedTo: oleonard(a)myacpl.org ReportedBy: fridolyn.somers(a)gmail.com QAContact: koha-bugs(a)lists.koha-community.org In opac-reserve.pl : my $branch = C4::Circulation::_GetCircControlBranch($itemLoopIter, $borr); This doesn't work because _GetCircControlBranch looks for homebranch nor holdingbranch. But $itemLoopIter doesn't contain those. I propose : my $branch = C4::Circulation::_GetCircControlBranch( $itemInfo , $borr); -- 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 23

[Bug 7687] New: Remove problematic CSS gradient declarations targeting Internet Explorer
by bugzilla-daemon＠bugs.koha-community.org 30 Nov '12

30 Nov '12

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7687 Priority: P5 - low Change sponsored?: --- Bug ID: 7687 Assignee: oleonard(a)myacpl.org Summary: Remove problematic CSS gradient declarations targeting Internet Explorer QA Contact: koha.sekjal(a)gmail.com Severity: minor Classification: Unclassified OS: All Reporter: oleonard(a)myacpl.org Hardware: All Status: ASSIGNED Version: master Component: Browser compatibility Product: Koha Compatibility of CSS gradients in Internet Explorer is looking worse than I expected. I propose to remove the gradient from these elements in favor of a solid background: - Cart and Lists buttons : Applying a background gradient to these elements causes the background to "bleed" out of the rounded corners in IE9 creating an ugly halo. - Lists menu and patron menu items : These elements use gradients which in standards-compliant browsers accept several "steps" (color 1 blended with color 2 blended with color 3). IE only understands two colors. Better to have a solid background than the inferior fallback IE ends up with. -- You are receiving this mail because: You are watching all bug changes.

1 10