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

[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 17817] New: Repeat this Tag (cloning) not working
by bugzilla-daemon＠bugs.koha-community.org 27 Jan '17

27 Jan '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17817 Bug ID: 17817 Summary: Repeat this Tag (cloning) not working Change sponsored?: --- Product: Koha Version: 16.11 Hardware: All OS: Linux Status: NEW Severity: critical Priority: P5 - low Component: Cataloging Assignee: gmcharlt(a)gmail.com Reporter: joseanjos(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org CC: m.de.rooy(a)rijksmuseum.nl Full details here: http://koha.1045719.n5.nabble.com/Repeat-this-Tag-not-working-td5914615.html Description: I've setup a completely new VM: Debian GNU/Linux 8.6 (jessie) MariaDB Ver 14.14 Distrib 5.5.53 Apache/2.4.10 (Debian) Installed the defaults in fr-FR Choose Cataloging -> New Record -> Default Framework Filed the mandatory fields. If I try to duplicate 701 it will jump to the top of the page If I try to duplicate 711 I have no problem. Conclusion is: If I try to duplicate any field that contains a Drop Menu (with authorized values) it will jump to the top of page. If there is no Drop Menu it will clone ok. If I choose a value from the Authorized Values, than In can duplicate it. But, when I save it, that fields are not saved. -- You are receiving this mail because: You are watching all bug changes.

1 43

[Bug 17808] New: String change, message showing for confirm edit rule
by bugzilla-daemon＠bugs.koha-community.org 27 Jan '17

27 Jan '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17808 Bug ID: 17808 Summary: String change, message showing for confirm edit rule Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Circulation Assignee: koha-bugs(a)lists.koha-community.org Reporter: bouzid.fergani(a)inlibro.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com very easy, just change string showing when edit rule for reproduce: 1- Administration 2- Circulation and fines rules 3- When try to edit any rule, you have the message : Are you sure you want to edit another rule? The new message is : Are you sure you want to edit this rule ? -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 18

[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 17794] New: 'Comments' in Tools sidebar menu is not bold (active) when it should be
by bugzilla-daemon＠bugs.koha-community.org 27 Jan '17

27 Jan '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17794 Bug ID: 17794 Summary: 'Comments' in Tools sidebar menu is not bold (active) when it should be Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Tools Assignee: gmcharlt(a)gmail.com Reporter: aleishaamohia(a)hotmail.com QA Contact: testopia(a)bugs.koha-community.org The 'Comments' menu item in the Tools menu takes you to the 'Comments awaiting moderation' tab by default, and the menu item is bolded (looks active). When you click the 'Approved comments' tab, the menu item is not bold, but it should be. -- You are receiving this mail because: You are watching all bug changes.

1 20

[Bug 17778] New: Make "Earliest Registered Date" in OAI-PMH dynamic
by bugzilla-daemon＠bugs.koha-community.org 27 Jan '17

27 Jan '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17778 Bug ID: 17778 Summary: Make "Earliest Registered Date" in OAI-PMH dynamic Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: minor Priority: P5 - low Component: Web services Assignee: koha-bugs(a)lists.koha-community.org Reporter: magnus(a)libriotech.no QA Contact: testopia(a)bugs.koha-community.org The value of earliestDatestamp is hardcoded on line 37 of Koha/OAI/Server/Identify.pm: earliestDatestamp => '0001-01-01', http://git.koha-community.org/gitweb/?p=koha.git;a=blob;f=Koha/OAI/Server/I… It should not be too hard to replace this with the output of something like this: SELECT DATE(MIN(timestamp)) FROM biblio; -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 13

[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

[Bug 15711] New: Deleting patroncard images has unexpected behaviour and is broken
by bugzilla-daemon＠bugs.koha-community.org 27 Jan '17

27 Jan '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15711 Bug ID: 15711 Summary: Deleting patroncard images has unexpected behaviour and is broken Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Label/patron card printing Assignee: cnighswonger(a)foundations.edu Reporter: aleishaamohia(a)hotmail.com QA Contact: testopia(a)bugs.koha-community.org To reproduce: 1) Go to Tools -> Patron Card Creator -> Manage Images. Upload an image if you do not already have something uploaded 2) Without checking any boxes, click the 'Delete selected' box 3) A box will pop up saying 'Please select image(s) to delete', as expected. Click 'OK' 4) Another pop-up saying 'Are you sure you want to delete image(s): undefined?' This is unexpected and shouldn't be showing up if nothing has been selected. 5) Click 'OK' - This also doesn't work (image isn't deleted) and gives an error 'WARNING: An error has occurred. Please ask your system administrator to check the error log for more details.' 6) Check the box next to an image and click 'Delete selected', then 'OK'. You get the WARNING error again and the image isn't deleted. This is broken. -- You are receiving this mail because: You are watching all bug changes.

1 26