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

[Bug 17031] New: Use delimeter system preference for Overdues report download
by bugzilla-daemon＠bugs.koha-community.org 09 Feb '18

09 Feb '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17031 Bug ID: 17031 Summary: Use delimeter system preference for Overdues report download Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Circulation 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, kyle.m.hall(a)gmail.com The delimiter system preference should be used to choose the separator to be used for the data exported from circulation > overdues (overdue.pl). -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 2

[Bug 19076] New: Renewal via Checkout screen is logged as both a renewal and a checkout
by bugzilla-daemon＠bugs.koha-community.org 09 Feb '18

09 Feb '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19076 Bug ID: 19076 Summary: Renewal via Checkout screen is logged as both a renewal and a checkout Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Circulation Assignee: koha-bugs(a)lists.koha-community.org Reporter: nick(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com Depends on: 17708 To recreate: 1 - Enable both issue and renewal logs 2 - Checkout an item to a patron 3 - View the logs - the issue is captured 4 - Checkout the item to the patron again and confirm renewal 5 - Both an issue and a renewal are logged Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17708 [Bug 17708] Renewal log seems empty -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 27

[Bug 18477] New: AR_PENDING notice does not populate values from article_requests table.
by bugzilla-daemon＠bugs.koha-community.org 08 Feb '18

08 Feb '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18477 Bug ID: 18477 Summary: AR_PENDING notice does not populate values from article_requests table. Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Notices Assignee: koha-bugs(a)lists.koha-community.org Reporter: barton(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org The default AR_PENDING letter does not print populate <<article_requests.*>> fields. To replicate: 1) Enable article requests ( syspref: ArticleRequests => Enable, Circ and fine rules ALL/ALL (or a given category/itemtype): Article requests => Yes ) 2) Search for a title, click in to catalog detail, click 'Request Article' button. 3) Select Patron 4) Fill out request information 5) Click 'Pplace request' 6) Go to notices in patron record, inspect 'Article Request Received' notice. You should see the request information from step 4, but it doesn't display. Examples below: AR_PENDING =================================== <<borrowers.firstname>> <<borrowers.surname>> (<<borrowers.cardnumber>>) We have received your request for an article from <<biblio.title>>. Article requested: Title: <<article_requests.title>> Author: <<article_requests.author>> Volume: <<article_requests.volume>> Issue: <<article_requests.issue>> Date: <<article_requests.date>> Pages: <<article_requests.pages>> Chapters: <<article_requests.chapters>> Notes: <<article_requests.patron_notes>> =================================== Displays as =================================== Barton Chittenden (barton) We have received your request for an article from Bws test record 2 (). Article requested: Title: Author: Volume: Issue: Date: Pages: Chapters: Notes: Thank you! =================================== The 'processing' and 'completed' notices work work, here's the output from 'Article Request Completed' =================================== Barton Chittenden (barton) We are have completed your request for an article from Bws test record 2 (). Article requested: Title: TEST TEST TEST Author: asdfsadf Volume: foo Issue: bar Date: baz Pages: 123234 Chapters: 9 Notes: Raaaaaagh! You may pick your article up at Midway. Thank you! =================================== -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 29

[Bug 19106] New: Pop up MARC preview window appears when searching in Chrome, cannot be closed
by bugzilla-daemon＠bugs.koha-community.org 07 Feb '18

07 Feb '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19106 Bug ID: 19106 Summary: Pop up MARC preview window appears when searching in Chrome, cannot be closed Change sponsored?: --- Product: Koha Version: 17.05 Hardware: PC OS: Windows Status: NEW Severity: normal Priority: P5 - low Component: Browser compatibility Assignee: oleonard(a)myacpl.org Reporter: librarian(a)rawenelibrary.org QA Contact: testopia(a)bugs.koha-community.org In Chrome Version 60.0.3112.101 (64-bit) when going to the Koha admin Web UI > Search the Catalog > Search terms and Enter > Click on a title > a MARC preview pop up window appears and blocks access to the page with an endless loading animation that can't be closed. Some other actions also prompt similar pop up window behaviour. The same task in Edge works fine. -- You are receiving this mail because: You are watching all bug changes.

1 4

[Bug 18919] New: "Transaction Branch" select field broken in Cash register statistics
by bugzilla-daemon＠bugs.koha-community.org 07 Feb '18

07 Feb '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18919 Bug ID: 18919 Summary: "Transaction Branch" select field broken in Cash register statistics Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Reports Assignee: koha-bugs(a)lists.koha-community.org Reporter: baptiste.wojtkowski(a)biblibre.com QA Contact: testopia(a)bugs.koha-community.org To reproduce: domain/cgi-bin/koha/reports/cash_register_stats.pl transaction branch all => you can see every cashing any branch => you can see every or no cashing (I don't know exactly on what it depends) -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 13

[Bug 17883] New: Manage Patron Lists Permission incorrectly displaying hidden columns
by bugzilla-daemon＠bugs.koha-community.org 07 Feb '18

07 Feb '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17883 Bug ID: 17883 Summary: Manage Patron Lists Permission incorrectly displaying hidden columns Change sponsored?: --- Product: Koha Version: 3.22 Hardware: All OS: All Status: NEW Severity: minor Priority: P5 - low Component: Staff Client Assignee: koha-bugs(a)lists.koha-community.org Reporter: christian.stelzenmueller(a)bsz-bw.de QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com Users who do NOT have the permission “Manage Patron Lists” are able to see and edit columns in a patron search result list which have been set to “hidden” by default. This should not be the case. To reproduce: 1. Go to > Administration > Column Settings > Patrons 2. In member (id = memberresultst) set “library” to “hidden by default” and “cannot be toggled”. 3. Log in as user with permission “manage patron lists”. Perform patron search – “library” column is hidden and cannot be toggled. 4. Log in as user without permission “manage patron lists”. Perform same patron search – “library” column is visible and can be toggled. - written by my dear colleague Claire, thanks :-) -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 7

[Bug 18836] New: Patron login is erroring out after failing to find table
by bugzilla-daemon＠bugs.koha-community.org 06 Feb '18

06 Feb '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18836 Bug ID: 18836 Summary: Patron login is erroring out after failing to find table Change sponsored?: --- Product: Koha Version: 17.05 Hardware: Macintosh OS: Linux Status: NEW Severity: normal Priority: P5 - low Component: Patrons Assignee: koha-bugs(a)lists.koha-community.org Reporter: CJSH(a)CJSHayward.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com (Checked the Wiki, tried chat, and searched bugs before reporting.) I tried to log in as a user and got: Software error: Template process failed: undef error - DBIx::Class::Storage::DBI::_dbh_execute(): Table 'koha_library.club_enrollments' doesn't exist at /usr/share/koha/lib/Koha/Objects.pm line 260 For help, please send mail to the webmaster ([no address given]), giving this error message and the time and date of the error. The VirtualHost below is the only one listening on its special port: Listen 7026 # OPAC <VirtualHost *:7026> <IfVersion >= 2.4> Define instance "library" </IfVersion> Include /etc/koha/apache-shared.conf # Include /etc/koha/apache-shared-disable.conf # Include /etc/koha/apache-shared-opac-plack.conf Include /etc/koha/apache-shared-opac.conf ServerName library.myDNSname.org SetEnv KOHA_CONF "/etc/koha/sites/library/koha-conf.xml" AssignUserID library-koha library-koha ErrorLog /var/log/koha/library/opac-error.log # TransferLog /var/log/koha/library/opac-access.log # RewriteLog /var/log/koha/library/opac-rewrite.log </VirtualHost> What can I do to either create missing tables like koha_libary.club_enrollments, or mark them as not needed for the patron screen to do its work? Thanks, C.J.S. Hayward https://CJSHayward.com -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 20

[Bug 17860] New: MARC records will stage, but Manage for import shows ' no data in table'
by bugzilla-daemon＠bugs.koha-community.org 06 Feb '18

06 Feb '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17860 Bug ID: 17860 Summary: MARC records will stage, but Manage for import shows 'no data in table' Change sponsored?: --- Product: Koha Version: 16.11 Hardware: PC OS: Linux Status: NEW Severity: major Priority: P5 - low Component: MARC Bibliographic record staging/import Assignee: gmcharlt(a)gmail.com Reporter: gale(a)rabbat.net QA Contact: testopia(a)bugs.koha-community.org I have no difficulty staging bibliographic or authority records, but using management, yields 'no data in table'. Have tried the files on demo systems and they work. Don't understand what the trouble is. Have deleted and reinstalled Koha, have dumped mysql data and recreated database. -- You are receiving this mail because: You are watching all bug changes.

1 12

[Bug 19492] New: Field 'lowestPriority' doesn't have a default value ( MariaDB)
by bugzilla-daemon＠bugs.koha-community.org 06 Feb '18

06 Feb '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19492 Bug ID: 19492 Summary: Field 'lowestPriority' doesn't have a default value (MariaDB) Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Hold requests Assignee: koha-bugs(a)lists.koha-community.org Reporter: magnus(a)libriotech.no QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com Running Koha with MariaDB on Ubuntu 16.04, I get an "internal server error" when I try to add a hold. The Plack log says: DBD::mysql::st execute failed: Field 'lowestPriority' doesn't have a default value [for Statement "INSERT INTO `reserves` ( `biblionumber`, `borrowernumber`, `branchcode`, `expirationdate`, `found`, `itemnumber`, `itemtype`, `priority`, `reservedate`, `reservenotes`, `waitingdate`) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )" with ParamValues: 0="16303", 1='1', 2="LIB", 3=undef, 4=undef, 5=undef, 6=undef, 7="1", 8='2017-10-19', 9="", 10=undef] at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1834. DBIx::Class::Storage::DBI::_dbh_execute(): Field 'lowestPriority' doesn't have a default value at /home/kohaadmin/kohaclone/Koha/Object.pm line 121 And reserves.lowestPriority does indeed not have a default value (from installer/data/mysql/kohastructure.sql): `lowestPriority` tinyint(1) NOT NULL, Adding a default value of 0 makes the "internal server error" go away: ALTER TABLE reserves ALTER COLUMN lowestPriority SET DEFAULT 0; -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 4

[Bug 19248] New: install.pl: DBD::mysql::st execute failed
by bugzilla-daemon＠bugs.koha-community.org 06 Feb '18

06 Feb '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19248 Bug ID: 19248 Summary: install.pl: DBD::mysql::st execute failed Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Installation and upgrade (web-based installer) Assignee: koha-bugs(a)lists.koha-community.org Reporter: k.shivaswamy(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com Created attachment 66795 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=66795&action=ed… Koha>Web Insteller> error The following error occurred while importing the database structure: [Mon Sep 4 13:12:33 2017] install.pl: DBD::mysql::st execute failed: Invalid default value for 'date_created' at /usr/share/perl5/DBIx/RunSQL.pm line 273. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 5