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

[Bug 17049] New: Plack: Handle multiple paths in PERL5LIB
by bugzilla-daemon＠bugs.koha-community.org 16 May '17

16 May '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17049 Bug ID: 17049 Summary: Plack: Handle multiple paths in PERL5LIB Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement 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 12

[Bug 17324] New: branchcode is NULL in letter triggers red upgrade message
by bugzilla-daemon＠bugs.koha-community.org 15 May '17

15 May '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17324 Bug ID: 17324 Summary: branchcode is NULL in letter triggers red upgrade message Change sponsored?: --- Product: Koha Version: master 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: mtompset(a)hotmail.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com I suspect there is probably relevant discussion on bug 14839. However, I just want a clean upgrade for MySQL 5.7 on Ubuntu 16.04 LTS. [Tue Sep 20 19:08:10 2016] updatedatabase.pl: DBD::mysql::db do failed: Invalid use of NULL value [for Statement " [Tue Sep 20 19:08:10 2016] updatedatabase.pl: ALTER TABLE letter MODIFY COLUMN branchcode varchar(10) NOT NULL DEFAULT '' [Tue Sep 20 19:08:10 2016] updatedatabase.pl: "] at /home/mtompset/kohaclone/installer/data/mysql/updatedatabase.pl line 12638. Reproduce: on an ubuntu 16.04 LTS machine with MySQL 5.7 install git koha development environment. ... git checkout -b my_3.18.x origin/3.18.x drop database koha_library; create database koha_library; quit; web install all sample data (ignore some issues with sample data, and one with mandatory) git checkout -b bug_17234 origin/master git bz apply 17292 git bz apply 17320 git bz apply 17260 git bz apply 17234 web install Two warning messages are expected output from upgrade process, but the above message is not. repeat the above, but git bz apply this patch before running the second web install. The message should be not there. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 25

[Bug 17260] New: updatedatabase.pl fails on invalid entries in ENUM and BOOLEAN columns
by bugzilla-daemon＠bugs.koha-community.org 15 May '17

15 May '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17260 Bug ID: 17260 Summary: updatedatabase.pl fails on invalid entries in ENUM and BOOLEAN columns Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: Installation and upgrade (command-line installer) Assignee: gmcharlt(a)gmail.com Reporter: philippe.blouin(a)inlibro.com QA Contact: testopia(a)bugs.koha-community.org See also Bug 17234 The loading of file admin/searchengine/elasticsearch/mappings.yaml specifies 'type' as empty, which fails with Mysql 5.7+ which is more stringent. Also, forcing an empty value into a boolean also fails. Both issues arise when updatedatabase.pl hit 3.23.00.050. -- You are receiving this mail because: You are watching all bug changes.

1 28

[Bug 17813] New: Table borrower_attributes needs a primary key
by bugzilla-daemon＠bugs.koha-community.org 15 May '17

15 May '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17813 Bug ID: 17813 Summary: Table borrower_attributes needs a primary key Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: gmcharlt(a)gmail.com Reporter: tomascohen(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org In order to be used correctly on DBIC the table needs a primary key. Otherwise calls to ->delete would fail. -- You are receiving this mail because: You are watching all bug changes.

1 22

[Bug 17914] New: The installer process tries to create borrowers.updated_on twice
by bugzilla-daemon＠bugs.koha-community.org 15 May '17

15 May '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17914 Bug ID: 17914 Summary: The installer process tries to create borrowers.updated_on twice 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 Depends on: 17234, 10459 Bug 10459 has been backported and the DB entry (add borrowers.updated_on and deletedborrower.updated_on) is now played in - 16.06.00.027 - 16.05.00.002 - 3.22.08.001 This will raise a MySQL warning if the column already exists. DBD::mysql::db do failed: Duplicate column name 'updated_on' Since bug 17234 we have now a subroutine (C4::Installer::column_exists) to test if a column exists. When a DB entry modifying the DB structure is backported, it HAS TO check if the column, constraint or table exists before executing the query. Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10459 [Bug 10459] borrowers should have a timestamp https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17234 [Bug 17234] ALTER IGNORE TABLE is invalid in mysql 5.7. This breaks updatedatabase.pl -- You are receiving this mail because: You are watching all bug changes.

1 12

[Bug 17356] New: Add atomic update .perl skeleton file
by bugzilla-daemon＠bugs.koha-community.org 15 May '17

15 May '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17356 Bug ID: 17356 Summary: Add atomic update .perl skeleton file Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: gmcharlt(a)gmail.com Reporter: jonathan.druart(a)bugs.koha-community.org QA Contact: testopia(a)bugs.koha-community.org -- You are receiving this mail because: You are watching all bug changes.

1 20

[Bug 16554] New: Web installer fails to load i18n sample data on MySQL 5.6+
by bugzilla-daemon＠bugs.koha-community.org 15 May '17

15 May '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16554 Bug ID: 16554 Summary: Web installer fails to load i18n sample data on MySQL 5.6+ Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: critical Priority: P5 - low Component: Installation and upgrade (web-based installer) Assignee: koha-bugs(a)lists.koha-community.org Reporter: bgkriegel(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com Followup to bug 13669 -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 91

[Bug 18307] New: Branchname is no more displayed in subscription tab wiew
by bugzilla-daemon＠bugs.koha-community.org 14 May '17

14 May '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18307 Bug ID: 18307 Summary: Branchname is no more displayed in subscription tab wiew 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: jean-manuel.broust(a)univ-lyon2.fr QA Contact: testopia(a)bugs.koha-community.org Created attachment 61354 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=61354&action=ed… library name not displayed in opac detail subscription tab The library name is no more displayed in opac-detail.pl's subscription tab. See screenshot attached. -- You are receiving this mail because: You are watching all bug changes.

1 19

[Bug 18350] New: Moving call number in subscriptions tab in OPAC biblio detail
by bugzilla-daemon＠bugs.koha-community.org 14 May '17

14 May '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18350 Bug ID: 18350 Summary: Moving call number in subscriptions tab in OPAC biblio detail Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: OPAC Assignee: oleonard(a)myacpl.org Reporter: aleishaamohia(a)hotmail.com QA Contact: testopia(a)bugs.koha-community.org >From Bug 10357 Comment 7: We have: - At Library: (Branch name missing, is fixed with Bug 18307) - Public note - Subscription details (date range) - Email notification handling (Subscribe, Unsubscribe, Note if not logged in) - Call number - Info about x latest issues (table) Can we move Call number up? (e.g. after "At library:", would be the same as in Staff client) -- You are receiving this mail because: You are watching all bug changes.

1 12

[Bug 17465] New: Add a System Preference to control number of Saved Reports displayed
by bugzilla-daemon＠bugs.koha-community.org 14 May '17

14 May '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17465 Bug ID: 17465 Summary: Add a System Preference to control number of Saved Reports displayed Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Reports Assignee: gmcharlt(a)gmail.com Reporter: bob(a)calyx.net.au QA Contact: testopia(a)bugs.koha-community.org The Saved Reports page lists 20 reports by default. A drop-down enables this to be changed to 10, 50, 100 or 'all' but this selection does not persist. Where a library has a large number of reports with frequent access, the need to constantly reset this can be quite annoying. We propose to add a system preference 'numSavedReports'. The description would be something like: 'By default, show 20 reports on the Saved Reports page. Other allowed values are 10, 50, 100 and All' The number chosen will also apply when a category tab is selected. -- You are receiving this mail because: You are watching all bug changes.

1 9