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

[Bug 20500] New: koha-create fails to connect to mysql
by bugzilla-daemon＠bugs.koha-community.org 05 Apr '20

05 Apr '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20500 Bug ID: 20500 Summary: koha-create fails to connect to mysql Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Packaging Assignee: koha-bugs(a)lists.koha-community.org Reporter: synapse.ova(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org CC: mirko(a)abunchofthings.net On VPS server (used Debian 8 and Ubuntu 16.04) installed Vesta CP, then installed Koha (17.11). MySQL version 5.5.59-0+deb8u1 (Debian). Everything was fine until I tried to create koha db: # sudo koha-create --create-db lib ERROR 1045 (28000): Access denied for user 'debian-sys-maint'@'localhost' (using password: YES) I found out that user debian-sys-maint is present on DB. Password, that is written in config file is the right one. The db user has enough privileges. The same problem was happening even if I tried to connect to MySQL with code, written in koha-create script: # mysql --defaults-extra-file=/etc/mysql/koha-common.cnf ERROR 1045 (28000): Access denied for user 'debian-sys-maint'@'localhost' (using password: YES) I tried wrapping options with quote marks, removing extra spaces in .cnf file but with no result. But somehow everything was fine after I changed option "defaults-extra-file" to "defaults-file". Just in case, these lines are contained in files: • koha-create • koha-remove • koha-reset-passwd • koha-restore (3 times) On installed system you can find them in the /usr/sbin/ folder -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 4

[Bug 20381] New: Multiple copy of barcode/label printing option
by bugzilla-daemon＠bugs.koha-community.org 04 Apr '20

04 Apr '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20381 Bug ID: 20381 Summary: Multiple copy of barcode/label printing option Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Tools Assignee: koha-bugs(a)lists.koha-community.org Reporter: mishravk79(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org Created attachment 72729 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=72729&action=ed… multiple lebel/barcode Some of the library used to paste 2 or more copy of barcode/label in a book/item but at present Koha provide option of printing only one barcode/label at a time i.e. if we wish to print again same copy of the barcode/label than print command needs to be executed. The problems: 1. The print command needs to be given again and again 2. If there is many barcode/label of several items than same item barcode may scatter in many pages of sheet/roll. 3. Staff may have confusion while pasting barcode/label from different label sheet which is scattered due to printing of multiple copy. Solution: We have already an option "Starting label position (In PDF) as shown in attached screenshot so similarly we may have "Number of copy" option adjacent to it. The multiple number of copy of a barcode/label should be printed adjacent to each other in pdf/sheet than next label followed by its multiple copy and so on. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 2

[Bug 20353] New: Get rid of CurrencyFormat
by bugzilla-daemon＠bugs.koha-community.org 04 Apr '20

04 Apr '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20353 Bug ID: 20353 Summary: Get rid of CurrencyFormat Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: koha-bugs(a)lists.koha-community.org Reporter: josef.moravec(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org The syspref CurrencyFormat should be removed and the funcionality should be moved to administration -> currency management as discussed on bug 4078. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 5

[Bug 20337] New: Add modification templates to Batch item modification
by bugzilla-daemon＠bugs.koha-community.org 04 Apr '20

04 Apr '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20337 Bug ID: 20337 Summary: Add modification templates to Batch item modification Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Tools Assignee: koha-bugs(a)lists.koha-community.org Reporter: verolencinas(a)yahoo.com.ar QA Contact: testopia(a)bugs.koha-community.org Batch item modification allows adding o deleting data, but not modification of existing data, for example change dashes to spaces in signatures. It should be possible to use also MARC Modification Template on items. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 1

[Bug 23888] New: Incorrect vendor id in subscription creation causes internal server error
by bugzilla-daemon＠bugs.koha-community.org 04 Apr '20

04 Apr '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23888 Bug ID: 23888 Summary: Incorrect vendor id in subscription creation causes internal server error Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: minor Priority: P5 - low Component: Serials Assignee: koha-bugs(a)lists.koha-community.org Reporter: joonas.kylmala(a)helsinki.fi QA Contact: testopia(a)bugs.koha-community.org CC: colin.campbell(a)ptfs-europe.com When adding a new subscription on the page /cgi-bin/koha/serials/subscription-add.pl and typing in the vendor field a non-existing vendor id "9999999999" and other fields correctly we get the following internal server error when clicking on the second page ”Save subscription”: DBIx::Class::Storage::DBI::_dbh_execute(): Out of range value for column 'aqbooksellerid' at row 1 at /kohadevbox/koha/Koha/Object.pm line 156 at /usr/share/perl5/DBIx/Class/Exception.pm line 77 When such incorrect vendor id is typed it should not allow us to go to the next page by clicking ”Next” but instead complain the vendor info is not correct. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 35

[Bug 24475] New: Reword FinesMode system preference
by bugzilla-daemon＠bugs.koha-community.org 03 Apr '20

03 Apr '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24475 Bug ID: 24475 Summary: Reword FinesMode system preference Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: System Administration Assignee: koha-bugs(a)lists.koha-community.org Reporter: andrew(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com The text for FinesMode reads: (Don't Calculate / Calculate and Charge / Calculate but only for mailing to the admin) fines (when misc/cronjobs/fines.pl is being run). NOTE: Fines can also be charged by the CalculateFinesOnReturn system preference. NOTE: This system preference requires the misc/cronjobs/fines.pl cronjob. Ask your system administrator to schedule it. This gives the impression that CalculateFinesOnReturn is an alternative to FinesMode -- that one could set FinesMode to "Don't calculate" and turn on CalculateFinesOnReturn in order to only calculate fines when an item is checked in. However, CalculateFinesOnReturn only works when FinesMode is set to "Calculate and charge." CalculateFinesOnReturn is an alternative to the fines cron, not to FinesMode. I'll think on better wording here and get back to this. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 30

[Bug 24829] New: ClaimReturnedWarningThreshold is always triggered if patron has one or more claims
by bugzilla-daemon＠bugs.koha-community.org 03 Apr '20

03 Apr '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24829 Bug ID: 24829 Summary: ClaimReturnedWarningThreshold is always triggered if patron has one or more claims Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: minor 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 ClaimReturnedWarningThreshold is supposed to display a warning if a patron has more than the number of claims specified in the system preference. Currently the warning is displayed for any number of claims over zero. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 12

[Bug 24959] New: Fix id/label pairs in saved reports table
by bugzilla-daemon＠bugs.koha-community.org 03 Apr '20

03 Apr '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24959 Bug ID: 24959 Summary: Fix id/label pairs in saved reports table Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: ASSIGNED Severity: trivial Priority: P5 - low Component: Reports Assignee: koha-bugs(a)lists.koha-community.org Reporter: oleonard(a)myacpl.org QA Contact: testopia(a)bugs.koha-community.org Depends on: 24886 In the table of saved reports the number in the 'ID' column is wrapped in a <label> tag, but clicking it doesn't check the corresponding checkbox because the "for" attribute doesn't match the ID of the checkbox. Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24886 [Bug 24886] Reindent reports template -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 12

[Bug 24745] New: OPAC news block plugin should evaluate as false if there are no items
by bugzilla-daemon＠bugs.koha-community.org 03 Apr '20

03 Apr '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24745 Bug ID: 24745 Summary: OPAC news block plugin should evaluate as false if there are no items Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: ASSIGNED Severity: normal Priority: P5 - low Component: OPAC Assignee: oleonard(a)myacpl.org Reporter: oleonard(a)myacpl.org QA Contact: testopia(a)bugs.koha-community.org Blocks: 23796 In the OPAC we do this to get a news block for display: [% SET OpacHeader = KohaNews.get( location => "opacheader", lang => lang, library => branchcode, blocktitle => 0 ) %] >From this we're supposed to be able to check for the existence of [% OpacHeader %], but the way the data is returned from KohaNews.pm it evaluates as true. Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23796 [Bug 23796] Convert OpacCustomSearch system preference to news block -- You are receiving this mail because: You are watching all bug changes.

1 23

[Bug 24754] New: UserEnv not set for ISLDI requests
by bugzilla-daemon＠bugs.koha-community.org 03 Apr '20

03 Apr '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24754 Bug ID: 24754 Summary: UserEnv not set for ISLDI requests Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: koha-bugs(a)lists.koha-community.org Reporter: nick(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org This was discovered via Renewals where no branch of the wrong branch was set in statistics. When making ILSDI requests the scripts do no set the userenv. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 49