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

[Bug 21603] New: Remove Group by clause in SearchCourses
by bugzilla-daemon＠bugs.koha-community.org 28 Nov '18

28 Nov '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21603 Bug ID: 21603 Summary: Remove Group by clause in SearchCourses Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: Course reserves Assignee: koha-bugs(a)lists.koha-community.org Reporter: nick(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org I am not certain we can simply remove here, but the GROUP by seems to stem form adding course instructors, though we fetch the instructors for each course after this query 971 $query .= " 972 LEFT JOIN course_instructors ci 973 ON ( c.course_id = ci.course_id ) 974 LEFT JOIN borrowers b 975 ON ( ci.borrowernumber = b.borrowernumber ) 976 LEFT JOIN authorised_values av 977 ON ( c.department = av.authorised_value ) 978 WHERE 979 ( av.category = 'DEPARTMENT' OR av.category = 'TERM' ) 980 AND 981 ( 982 department LIKE ? OR 983 course_number LIKE ? OR 984 section LIKE ? OR 985 course_name LIKE ? OR 986 term LIKE ? OR 987 public_note LIKE ? OR 988 CONCAT(surname,' ',firstname) LIKE ? OR 989 CONCAT(firstname,' ',surname) LIKE ? OR 990 lib LIKE ? OR 991 lib_opac LIKE ? 992 ) 993 AND 994 c.enabled LIKE ? 995 GROUP BY c.course_id 996 "; -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 17

[Bug 21612] New: Incorrect GROUP BY in Koha::Virtualshelves
by bugzilla-daemon＠bugs.koha-community.org 28 Nov '18

28 Nov '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21612 Bug ID: 21612 Summary: Incorrect GROUP BY in Koha::Virtualshelves Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: ASSIGNED Severity: major 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 Same as commit 7e220e0d8f107cce63f32bfaa1919c04b4dea6e2 Bug 20179: [sql_modes] Remove GROUP BY in get_shelves_containing_record for get_private_shelves, get_public_shelves and get_some_shelves -- You are receiving this mail because: You are watching all bug changes.

1 12

[Bug 20758] New: Typo in BrowseResultSelection syspref description
by bugzilla-daemon＠bugs.koha-community.org 28 Nov '18

28 Nov '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20758 Bug ID: 20758 Summary: Typo in BrowseResultSelection syspref description Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Searching Assignee: koha-bugs(a)lists.koha-community.org Reporter: caroline.cyr-la-rose(a)inlibro.com QA Contact: testopia(a)bugs.koha-community.org The description goes like this : Disable/Enable browsing search results **fromt** the bibliographic record detail page in staff client. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 13

[Bug 21505] New: Box around 'Additional fields' does not contain the fields
by bugzilla-daemon＠bugs.koha-community.org 28 Nov '18

28 Nov '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21505 Bug ID: 21505 Summary: Box around 'Additional fields' does not contain the fields Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: trivial Priority: P5 - low Component: Serials Assignee: koha-bugs(a)lists.koha-community.org Reporter: caroline.cyr-la-rose(a)inlibro.com QA Contact: testopia(a)bugs.koha-community.org CC: colin.campbell(a)ptfs-europe.com Created attachment 80147 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=80147&action=ed… Additional fields box When you have additional fields in your subscription, the 'Additional fields' title appears in a blue box, but the fields themselves are outside the box.(See attached screen capture) To reproduce: 1) Go to Serials 2) Click on 'Add subscription fields' 3) Click on 'New fields' 4) Fill in the form and click 'Save' 5) Search for a subscription 6) Click on the title to see the subscription detail page 7) In the 'Information' tab, there is the 'Additional fields' title in its box followed by the additional field -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 23

[Bug 21625] New: Fix wording and typo in SMSSendDriver system preference description
by bugzilla-daemon＠bugs.koha-community.org 28 Nov '18

28 Nov '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21625 Bug ID: 21625 Summary: Fix wording and typo in SMSSendDriver system preference description Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: trivial Priority: P5 - low Component: System Administration Assignee: koha-bugs(a)lists.koha-community.org Reporter: katrin.fischer(a)bsz-bw.de QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 12

[Bug 21531] New: Subscription "New fields" button should read "New field"
by bugzilla-daemon＠bugs.koha-community.org 28 Nov '18

28 Nov '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21531 Bug ID: 21531 Summary: Subscription "New fields" button should read "New field" Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: ASSIGNED Severity: trivial Priority: P5 - low Component: Templates Assignee: oleonard(a)myacpl.org Reporter: oleonard(a)myacpl.org QA Contact: testopia(a)bugs.koha-community.org CC: testopia(a)bugs.koha-community.org Depends on: 21519 Action buttons for any "New" operation use singular, so the "New fields" button on the "Add subscription fields" should read "New field." Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21519 [Bug 21519] Switch two-column templates to Bootstrap grid: Serials part 1 -- You are receiving this mail because: You are watching all bug changes.

1 10

[Bug 21590] New: "send list" email uses the term "virtual shelf", this should be "list".
by bugzilla-daemon＠bugs.koha-community.org 28 Nov '18

28 Nov '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21590 Bug ID: 21590 Summary: "send list" email uses the term "virtual shelf", this should be "list". Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: trivial Priority: P5 - low Component: OPAC Assignee: oleonard(a)myacpl.org Reporter: barton(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org The text of an email sent via the OPAC 'send shelves' menu item reads "Hi, George sent you from our online catalog, the virtual shelf called ..." Per https://wiki.koha-community.org/wiki/Terminology, we should use 'list' instead of 'virtual shelf'. To re-create 1) Choose a public list from the 'lists' menu in the OPAC. 2) Click 'Send list' 3) Log in as necessary 4) Fill in your own email address 5) Click 'send' 6) Check your email, the sent email will contain the text "sent you from our online catalog, the virtual shelf called". This is hard coded in koha-tmpl/opac-tmpl/bootstrap/en/modules/opac-sendshelf.tt -- You are receiving this mail because: You are watching all bug changes.

1 11

[Bug 20592] New: updateitem.pl causes database errors when empty non-public item notes updated
by bugzilla-daemon＠bugs.koha-community.org 28 Nov '18

28 Nov '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20592 Bug ID: 20592 Summary: updateitem.pl causes database errors when empty non-public item notes updated Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: minor Priority: P5 - low Component: Cataloging Assignee: koha-bugs(a)lists.koha-community.org Reporter: dcook(a)prosentient.com.au QA Contact: testopia(a)bugs.koha-community.org CC: m.de.rooy(a)rijksmuseum.nl If you go to /cgi-bin/koha/catalogue/moredetail.pl?biblionumber=1&itemnumber=1#item1, and click "Update" next to an empty "Non-public note" field, it will generate a database error. Typically, this is hidden in your Apache logs, but if you have DEBUG turned on, the database error will be fatal. Example logs: [Tue Apr 17 12:43:48.607368 2018] [cgi:error] [pid 1992] [client ...:22158] AH01215: [Tue Apr 17 12:43:48 2018] updateitem.pl: DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE itemnumber='1'' at line 1 [for Statement "UPDATE items SET WHERE itemnumber=?" with ParamValues: 0="1"] at ../git/C4/Items.pm line 2038.: ../git/catalogue/updateitem.pl, referer: http://koha/cgi-bin/koha/catalogue/moredetail.pl?biblionumber=1&itemnumber=1 [Tue Apr 17 12:43:48.607852 2018] [cgi:error] [pid 1992] [client ...:22158] AH01215: [Tue Apr 17 12:43:48 2018] updateitem.pl: DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE itemnumber='1'' at line 1 [for Statement "UPDATE items SET WHERE itemnumber=?" with ParamValues: 0="1"] at ../git/C4/Items.pm line 2038.: ../git/catalogue/updateitem.pl, referer: http://koha/cgi-bin/koha/catalogue/moredetail.pl?biblionumber=1&itemnumber=1 -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 27

[Bug 21617] New: statistics.ccode is not long enough (see also dbrev 18.06.00.032)
by bugzilla-daemon＠bugs.koha-community.org 28 Nov '18

28 Nov '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21617 Bug ID: 21617 Summary: statistics.ccode is not long enough (see also dbrev 18.06.00.032) Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Database Assignee: koha-bugs(a)lists.koha-community.org Reporter: m.de.rooy(a)rijksmuseum.nl QA Contact: testopia(a)bugs.koha-community.org Warn from a test: DBD::mysql::st execute failed: Data too long for column 'ccode' at row 1 [for Statement "INSERT INTO statistics (datetime, branch, type, value, other, itemnumber, itemtype, location, borrowernumber, proccode, ccode) VALUES (now(),?,?,?,?,?,?,?,?,?,?)" with ParamValues: 0="z8LIyIV", 1='issue', 2=undef, 3='', 4='2584', 5='E_QkzaV5Ay', 6='oDnFRZyog2CS2_XoUB_MB2sBxyI3elbFPC_AekxLPrduGTXKnlNoLKEdQrXzpAw5zD1pGbZshV9ydZup', 7='2000005168', 8='', 9='j9ZDn74omZAoZrTOdC4a05SpWRSHPR2apfss7y5V6QJuQnBEk32XWXCfMp7'] at C4/Stats.pm line 138. The dbrev 18.06.00.032 did not change it from 10 to 80 as in other tables. We should either truncate to 10 chars in Stats.pm or increase to varchar(80). Since it is varchar and not char, we should not be afraid about size. I choose for the latter here. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 14

[Bug 21497] New: Correctly format dates for ILL requests in OPAC
by bugzilla-daemon＠bugs.koha-community.org 28 Nov '18

28 Nov '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21497 Bug ID: 21497 Summary: Correctly format dates for ILL requests in OPAC Change sponsored?: --- Product: Koha Version: 16.11 Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: ILL Assignee: koha-bugs(a)lists.koha-community.org Reporter: katrin.fischer(a)bsz-bw.de In the OPAC the dates for ill requests are shown unformatted. Dates shoudl be displayed according to the datefomat system preference. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 11