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

[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 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

[Bug 16402] New: Web Installation fails - Step 3 Importing the Database Structure
by bugzilla-daemon＠bugs.koha-community.org 14 May '17

14 May '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16402 Bug ID: 16402 Summary: Web Installation fails - Step 3 Importing the Database Structure Change sponsored?: --- Product: Koha Version: unspecified Hardware: PC OS: Linux Status: NEW Severity: critical Priority: P5 - low Component: About Assignee: nengard(a)gmail.com Reporter: gk.bmsit(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org Created attachment 51046 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=51046&action=ed… Web Installation Error OS: Ubuntu 16.04 Type: Ubuntu package installation Koha: Current Stable Version on 29th April 2016 Blank Database creation was successful. Very first login prompted for password. At Step 3 persistent error: The following error occurred while importing the database structure: mysql: [Warning] Using a password on the command line interface can be insecure. ERROR 1171 (42000) at line 1385: All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead Please contact your system administrator On second instance creation - did not appear Login Page at all. -- You are receiving this mail because: You are watching all bug changes.

1 40

[Bug 17955] New: Remove the sql code and unnecessary use pragmas from the onboarding.pl script
by bugzilla-daemon＠bugs.koha-community.org 13 May '17

13 May '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17955 Bug ID: 17955 Summary: Remove the sql code and unnecessary use pragmas from the onboarding.pl script Change sponsored?: --- Product: Koha Version: 17.05 Hardware: All OS: All Status: ASSIGNED Severity: minor Priority: P5 - low Component: Installation and upgrade (web-based installer) Assignee: alexbuckley(a)catalyst.net.nz Reporter: alexbuckley(a)catalyst.net.nz QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com Depends on: 17855 The purpose of this bug is to remove the sql code and unnecessary use pragmas from the onboarding.pl script thereby aligning it with the Koha coding guidelines. Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17855 [Bug 17855] Updated Koha web installer and new onboarding tool feature to guide users through setting up Koha -- You are receiving this mail because: You are watching all bug changes.

1 13

[Bug 17083] New: Remove more event attributes from tools templates
by bugzilla-daemon＠bugs.koha-community.org 11 May '17

11 May '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17083 Bug ID: 17083 Summary: Remove more event attributes from tools templates Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: ASSIGNED Severity: enhancement Priority: P5 - low Component: Templates Assignee: oleonard(a)myacpl.org Reporter: oleonard(a)myacpl.org QA Contact: testopia(a)bugs.koha-community.org This patch will remove event attributes from some tools-related templates: labels/label-edit-layout.tt tools/cleanborrowers.tt tools/inventory.tt tools/letter.tt tools/upload.tt -- You are receiving this mail because: You are watching all bug changes.

1 11

[Bug 17847] New: Move C4::Koha::GetAuthvalueDropbox to Koha:: AuthorisedValues
by bugzilla-daemon＠bugs.koha-community.org 10 May '17

10 May '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17847 Bug ID: 17847 Summary: Move C4::Koha::GetAuthvalueDropbox to Koha::AuthorisedValues Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: ASSIGNED Severity: enhancement 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 -- You are receiving this mail because: You are watching all bug changes.

1 15

[Bug 17781] New: Improper branchcode set during renewal
by bugzilla-daemon＠bugs.koha-community.org 10 May '17

10 May '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17781 Bug ID: 17781 Summary: Improper branchcode set during renewal Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Circulation Assignee: koha-bugs(a)lists.koha-community.org Reporter: kyle(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com For no discernable reason, when AddIssue calls AddRenewal, it passes the branchcode generated from _GetCircControlBranch. Assume _GetCircControlBranch is set to return items.homebranch. So: 1) If an item owned by LibraryA is checked out at LibraryB, the statistic line branchcode will be LibraryB 2) If an item is renewed via the ajax datatables renewal function, the statistic line branchcode will be LibraryB 3) If an item is renewed via scanning the item into the checkout again, the statistic line branchcode will be *LibraryA* This is clearly improper behavior. The renewal is taking place at LibraryB, so the branchcode passed to AddRenewal should be LibraryB, the logged in library. This also jives with the documentation for the subroutine. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 14