November 2016 - Koha-bugs - lists.koha-community.org

[Bug 15889] New: Login with LDAP deletes extended attributes
by bugzilla-daemon＠bugs.koha-community.org 30 Jan '17

30 Jan '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15889 Bug ID: 15889 Summary: Login with LDAP deletes extended attributes Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: critical Priority: P5 - low Component: Authentication Assignee: gmcharlt(a)gmail.com Reporter: alex.arnaud(a)biblibre.com QA Contact: testopia(a)bugs.koha-community.org CC: dpavlin(a)rot13.org Authentication on Koha using LDAP deletes all *non-mapped* extended attributes. -- You are receiving this mail because: You are watching all bug changes.

1 14

[Bug 17652] New: opac-account.pl does not include login branchcode
by bugzilla-daemon＠bugs.koha-community.org 29 Jan '17

29 Jan '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17652 Bug ID: 17652 Summary: opac-account.pl does not include login branchcode Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: OPAC Assignee: oleonard(a)myacpl.org Reporter: chris.kirby(a)ilsleypubliclibrary.org QA Contact: testopia(a)bugs.koha-community.org opac-account.pl does not include login branchcode, whereas the other pages (opac-user, opac-memberentry, opac-passwd, opac-readingrecord, opac-suggestions, opac-messaging, opac-shelves)available to users on login DO provide the login branchode. Having the login branchcode available on opac-account.pl would facilitate customization of the OPAC for individual branches. -- You are receiving this mail because: You are watching all bug changes.

1 14

[Bug 17681] New: Some typos
by bugzilla-daemon＠bugs.koha-community.org 29 Jan '17

29 Jan '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17681 Bug ID: 17681 Summary: Some typos Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: trivial Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: gmcharlt(a)gmail.com Reporter: m.de.rooy(a)rijksmuseum.nl QA Contact: testopia(a)bugs.koha-community.org -- You are receiving this mail because: You are watching all bug changes.

1 17

[Bug 17547] New: (MARC21) Chronological term field 648 not indexed
by bugzilla-daemon＠bugs.koha-community.org 29 Jan '17

29 Jan '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17547 Bug ID: 17547 Summary: (MARC21) Chronological term field 648 not indexed Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: MARC Bibliographic data support Assignee: gmcharlt(a)gmail.com Reporter: tomascohen(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org Even though the authority search in the OPAC allows searching Chronological term authority records, the 'usage' column is always 0, because searching for linked bibliographical records always returns 0. This is because 648$9 is not being added in the Koha-Auth-Number index -- You are receiving this mail because: You are watching all bug changes.

1 17

[Bug 16376] New: Koha::Calendar->is_holiday date truncation creates fatal errors for TZ America/Santiago
by bugzilla-daemon＠bugs.koha-community.org 29 Jan '17

29 Jan '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16376 Bug ID: 16376 Summary: Koha::Calendar->is_holiday date truncation creates fatal errors for TZ America/Santiago Change sponsored?: --- Product: Koha Version: 3.20 Hardware: All OS: All Status: NEW Severity: critical Priority: P5 - low Component: Circulation Assignee: koha-bugs(a)lists.koha-community.org Reporter: dcook(a)prosentient.com.au QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com Koha::Calendar->is_holiday calls the following DateTime truncate method: $localdt->truncate( to => 'day' ); This will truncate 2015-09-06 12:00:00 down to 2015-09-06 00:00:00. This causes major problems in Santiago, Chile, because 2015-09-06 is an invalid local time due to DST. I can't explain why it's a problem in 2015 because DST is weird in Chile in 2015, but it's obviously a problem for every other year as well: http://www.timeanddate.com/time/change/chile/santiago?year=2015 Consider 2014: 2014 Sunday, 27 April, 12:00 Midnight Sunday, 7 September, 12:00 Midnight You shouldn't have a problem on 27 April, because when 27 April 12:00 midnight hits (relative to UTC), local time is changed to 27 April 11:00pm. While UTC marches on, local time has been magically moved back an hour. You will have a problem on 7 September 12:00 midnight though, because that time doesn't exist. As soon as we roll over from 6 September 11:59pm to the next minute... we're actually on to 7 September 01:00:00am. Midnight doesn't exist on that day, which creates the following error in DateTime.pm: "Invalid local time for date in time zone: America/Santiago" This is a problem that the DateTime writer predicted. You can see their comments here: http://cpansearch.perl.org/src/DROLSKY/DateTime-1.26/lib/DateTime.pm https://rt.cpan.org/Public/Bug/Display.html?id=93347 We should probably do something like: eval { $dt->truncate(to => 'day'); } || warn "Eval failed with '$@'\n"; Why are we even doing this day truncation? -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 41

[Bug 17513] New: koha-create does not set GRANTS correctly
by bugzilla-daemon＠bugs.koha-community.org 29 Jan '17

29 Jan '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17513 Bug ID: 17513 Summary: koha-create does not set GRANTS correctly Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: ASSIGNED Severity: normal Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: jonathan.druart(a)bugs.koha-community.org Reporter: jonathan.druart(a)bugs.koha-community.org QA Contact: testopia(a)bugs.koha-community.org There is a behavior change between MySQL and MariaDB: With: CREATE DATABASE koha_kohadev; CREATE USER koha_kohadev@localhost IDENTIFIED BY 'password'; CREATE USER koha_kohadev@'%' IDENTIFIED BY 'password'; GRANT ALL PRIVILEGES ON koha_kohadev.* TO koha_kohadev; Using Mysql, as admin user: mysql> SHOW GRANTS FOR koha_kohadev@'localhost'; GRANT USAGE ON *.* TO 'koha_kohadev'@'localhost' IDENTIFIED BY PASSWORD '*2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19' mysql> SHOW GRANTS FOR koha_kohadev; GRANT USAGE ON *.* TO 'koha_kohadev'@'%' IDENTIFIED BY PASSWORD '*2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19' GRANT ALL PRIVILEGES ON `koha_kohadev`.* TO 'koha_kohadev'@'%' Using Mysql, as koha_user user: mysql> SHOW GRANTS FOR koha_kohadev@'localhost'; GRANT USAGE ON *.* TO 'koha_kohadev'@'localhost' IDENTIFIED BY PASSWORD <secret> mysql> SHOW GRANTS FOR koha_kohadev; GRANT USAGE ON *.* TO 'koha_kohadev'@'%' IDENTIFIED BY PASSWORD <secret> GRANT ALL PRIVILEGES ON `koha_kohadev`.* TO 'koha_kohadev'@'%' Using MariaDB, as admin user: MariaDB [(none)]> SHOW GRANTS FOR kohaçkohadev@localhost; GRANT USAGE ON *.* TO 'koha_kohadev'@'%' IDENTIFIED BY PASSWORD '*'2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19 MariaDB [(none)]> SHOW GRANTS FOR kohaçkohadev; GRANT USAGE ON *.* TO 'koha_kohadev'@'%' IDENTIFIED BY PASSWORD '*'2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19 GRANT ALL PRIVILEGES ON `koha_kohadev`.* TO 'koha_kohadev'@'%' So all the same so far :) But, Using MariaDB, as koha_user user: MariaDB [(none)]> SHOW GRANTS FOR kohaçkohadev@localhost; GRANT USAGE ON *.* TO 'koha_kohadev'@'%' IDENTIFIED BY PASSWORD '*'2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19 MariaDB [(none)]> SHOW GRANTS FOR kohaçkohadev; ERROR 1044 (42000): Access denied for user 'koha_kohadev'@'localhost' to database 'mysql' BOOM! The installer does not parse the expected output and then raise an error. -- You are receiving this mail because: You are watching all bug changes.

1 17

[Bug 17660] New: Field 773 $t not editable in any framework
by bugzilla-daemon＠bugs.koha-community.org 29 Jan '17

29 Jan '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17660 Bug ID: 17660 Summary: Field 773 $t not editable in any framework Change sponsored?: --- Product: Koha Version: 16.05 Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Cataloging Assignee: gmcharlt(a)gmail.com Reporter: mik(a)adminkuhn.ch QA Contact: testopia(a)bugs.koha-community.org CC: m.de.rooy(a)rijksmuseum.nl Trying to change a copy of the standard framework. To catalogue sets with volumes MARC field 773 needs to be unhided in the framework. It is no problem to unhide 773 $w by clicking on "Advanced constraints" and marking the field "Editor", the click "Save changes". But also $t (for the title) is needed. There, when clicking on "Advanced constraints", nothing happens, so the tab will not open to mark the field "Editor". Instead, if "Basic constraints" is open, it will close "Basic constraints", but still "Advanced constraints" will not open. It was possible to export the framework and edit the XML file... in the part of the XML file decribing field 773 $t I found some characters like this: <ss:Data ss:Type="Number">-6</ss:Data> and I replaced them by <ss:Data ss:Type="Number">0</ss:Data> Now the behaviour while editing of the framework is still as described above (tab "Advanced constraints" won't open). But when actually using the framework during catalogueing, the MARC field 773 is there with both configured subfields $t and $w. I don't know why the exported XML file has around 4.4 million characters but only 28 lines - this makes it VERY painful to edit this file with an editor like vi. I would prefer a more structured file with more lines that are actually editable. -- You are receiving this mail because: You are watching all bug changes.

1 14

[Bug 17310] New: Broken URLs in 'Item renewed' / 'Cannot renew' messages
by bugzilla-daemon＠bugs.koha-community.org 27 Jan '17

27 Jan '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17310 Bug ID: 17310 Summary: Broken URLs in 'Item renewed' / 'Cannot renew' messages Change sponsored?: --- Product: Koha Version: 16.05 Hardware: All OS: All Status: NEW Severity: minor Priority: P5 - low Component: Circulation Assignee: koha-bugs(a)lists.koha-community.org Reporter: arouss1980(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com Description of the problem: In the Staff client, under Circulation > Renew, the message shown after successful renewal of an item contains broken URLs like these: /cgi-bin/koha/catalogue/detail.pl?biblionumber=Koha::Schema::Result::Biblio=HASH(0x7714d88) /cgi-bin/koha/catalogue/moredetail.pl?itemnumber=7&biblionumber=Koha::Schema::Result::Biblio=HASH(0x7714d88)&bi=1286#item7 This is also true for the message shown when you try to renew an item that is not checked out. Valid in latest stable (v16.05.03) and in the current master (0254fd7). -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 12

[Bug 17469] New: fr-CA web installer is missing some sample notices
by bugzilla-daemon＠bugs.koha-community.org 27 Jan '17

27 Jan '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17469 Bug ID: 17469 Summary: fr-CA web installer is missing some sample notices Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Installation and upgrade (web-based installer) Assignee: koha-bugs(a)lists.koha-community.org Reporter: katrin.fischer(a)bsz-bw.de QA Contact: testopia(a)bugs.koha-community.org CC: francois.charbonnier(a)inlibro.com, gmcharlt(a)gmail.com xt/sample_notice.t fails when you add fr-CA to it, because the file is missing some of the sample notices: Sample notices to add in fr-CA/obligatoire/sample_notices.sql: HOLD_SLIP, MEMBERSHIP_EXPIRY, PASSWORD_RESET Sample notices to delete in fr-CA/obligatoire/sample_notices.sql: RESERVESLIP (was renamed to be HOLD_SLIP!) The file and the test should be fixed! -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 49

[Bug 17265] New: Make koha-create-defaults less greedy
by bugzilla-daemon＠bugs.koha-community.org 27 Jan '17

27 Jan '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17265 Bug ID: 17265 Summary: Make koha-create-defaults less greedy Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Packaging Assignee: koha-bugs(a)lists.koha-community.org Reporter: magnus(a)libriotech.no QA Contact: testopia(a)bugs.koha-community.org CC: mirko(a)abunchofthings.net koha-dump-defaults runs mysqldump and then pipes the result to sed, to replace every occurence of the site name with the placeholder __KOHASITE__ mysqldump --databases --host="$mysqlhost" --user="$mysqluser" \ --password="$mysqlpass" "$mysqldb" | sed "s/$name/__KOHASITE__/g" I had used the silly name "data" as the site name for my "template instance", and this resulted in innocent things like -- Dumping __KOHASITE__ for table `zebraqueue` and bad things like 'Edit catalog (Modify bibliographic/holdings __KOHASITE__)' or this, in biblioitems.marcxml: <__KOHASITE__field> All told there were 7235 occurences of __KOHASITE__ in my rather small SQL file. As suggested by drojf on IRC, I *think* this would be fixed if we replaced "koha_$name" __INSTANCENAME__, instead of just $name. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 15