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

[Bug 10517] koha-restore fails to create mysqluser@mysql_hostname so zebra update fails
by bugzilla-daemon＠bugs.koha-community.org 14 May '20

14 May '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10517 --- Comment #33 from Victor Grousset/tuxayo <victor(a)tuxayo.net> --- (In reply to Martin Renvoize from comment #16) > I'm afraid we cannot yet use the 'IF EXISTS' syntax here as we are > maintaining support for Jessie up to the end of it's LTS date (2020-06-30). > I intend to drop support for that Debian version at the release of 20.05 (at > which time I believe we should also drop support for it from 19.11 at > 19.11.06 and 19.05 at 19.05.12). > > However, even once we have dropped such support, unless I am mistaken, > stretch is still stuck at MySQL 5.5 (though it recommends MariaDB instead. > As such, we'll need a clear deprecation of mysql 5.5 support outlined and > publicised before we can make this change. My second test of the above comment seems to show that MySQL 5.5 is already not supported in our case. I'm just spinning up a Koha with MySQL 5.5 and run koha-remove then it fails on a syntax error mentioning IF EXISTS. So, should we still avoid IF EXISTS?(I don't have the big picture) In this case it doesn't look like it will break anything new for anyone. "Just" breaking a second thing when using koha-remove. -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 10517] koha-restore fails to create mysqluser@mysql_hostname so zebra update fails
by bugzilla-daemon＠bugs.koha-community.org 14 May '20

14 May '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10517 --- Comment #32 from Victor Grousset/tuxayo <victor(a)tuxayo.net> --- == 1 == I might had issues related to bug 25482 because my dev env was Debian 10 (koha-testing-docker ku-md10) Which could explain cause koha-plack to not work which would cause issue to stop the instance. Actually only Apache processes are still there when doing koha-remove. With koha-disable, no errors and starman and Apache processes are still there. == 2 == So I tried with Debian 9 + MySQL 5.5 (koha-testing-docker ku) And now I get this issue. > root@b92acf73a243:kohadevbox$ koha-remove kohadev > Removing Koha instance kohadev > ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; > check the manual that corresponds to your MySQL server version for > the right syntax to use near 'IF EXISTS `koha_kohadev`@`%`' at line 1 == 3 == So I tried with Debian 9 + MariaDB (from it's repos) (koha-testing-docker ku-md9) Same error as with Debian 10. Processes still here. > userdel: user kohadev-koha is currently used by process 839 > /usr/sbin/deluser: `/usr/sbin/userdel kohadev-koha' returned error code 8. > Exiting. -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 8338] Fines not cleared with dropbox mode
by bugzilla-daemon＠bugs.koha-community.org 14 May '20

14 May '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8338 Andrew Fuerste-Henry <andrew(a)bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #104842|0 |1 is obsolete| | --- Comment #23 from Andrew Fuerste-Henry <andrew(a)bywatersolutions.com> --- Created attachment 104901 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=104901&action=e… Bug 8338: Remove zero amount overdues on backdated returns where appropriate This patch removes any overdues which would be reversed on a backdated return if CalcFineOnBackdate is enabled and the user has not already attempted to pay off the accruing fine. Signed-off-by: Andrew Fuerste-Henry <andrew(a)bywatersolutions.com> -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 8338] Fines not cleared with dropbox mode
by bugzilla-daemon＠bugs.koha-community.org 14 May '20

14 May '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8338 Andrew Fuerste-Henry <andrew(a)bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #104841|0 |1 is obsolete| | --- Comment #22 from Andrew Fuerste-Henry <andrew(a)bywatersolutions.com> --- Created attachment 104900 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=104900&action=e… Bug 8338: Unit Tests Signed-off-by: Andrew Fuerste-Henry <andrew(a)bywatersolutions.com> -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 8338] Fines not cleared with dropbox mode
by bugzilla-daemon＠bugs.koha-community.org 14 May '20

14 May '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8338 Andrew Fuerste-Henry <andrew(a)bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Needs Signoff |Signed Off -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 8338] Fines not cleared with dropbox mode
by bugzilla-daemon＠bugs.koha-community.org 14 May '20

14 May '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8338 --- Comment #21 from Andrew Fuerste-Henry <andrew(a)bywatersolutions.com> --- This looks good except for one extremely minor quibble -- the acount_offsets entry for the credit created in test 2 shows type "Manual credit," which is misleading on a credit generated automatically by the system. Signing off anyway, but would love to see that changed to "system-generated credit" or something more accurate. -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 24750] New: Instructor Search Results
by bugzilla-daemon＠bugs.koha-community.org 14 May '20

14 May '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24750 Bug ID: 24750 Summary: Instructor Search Results Change sponsored?: --- Product: Koha Version: 19.05 Hardware: All OS: All Status: NEW Severity: minor Priority: P5 - low Component: Course reserves Assignee: koha-bugs(a)lists.koha-community.org Reporter: joe(a)flo.org QA Contact: testopia(a)bugs.koha-community.org There are two problems with the instructor search when entering a new course in Course Reserves: 1. The autofill box only displays up to 10 names so it is difficult to find an instructor who has a common last name. Is there a better way to handle this? 2. If the user enters a comma between the last name and first name it will often not find the instructor. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 21

[Bug 15234] Gateway Timeout in z3950_search.pl when a Z39.50 query is performed against a large group of targets.
by bugzilla-daemon＠bugs.koha-community.org 14 May '20

14 May '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15234 Katrin Fischer <katrin.fischer(a)bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |martin.renvoize@ptfs-europe | |.com, tomascohen(a)gmail.com --- Comment #6 from Katrin Fischer <katrin.fischer(a)bsz-bw.de> --- What I meant is that there is no setting in Koha - this is probably more about your server configuration. I'll add some others in hope they will be able to give more insight. -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 25211] New: Missing share icon on OPAC lists page
by bugzilla-daemon＠bugs.koha-community.org 14 May '20

14 May '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25211 Bug ID: 25211 Summary: Missing share icon on OPAC lists page Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: ASSIGNED Severity: enhancement Priority: P5 - low Component: OPAC Assignee: oleonard(a)myacpl.org Reporter: oleonard(a)myacpl.org QA Contact: testopia(a)bugs.koha-community.org In the list of lists in the OPAC the "Share" link doesn't have an icon. -- You are receiving this mail because: You are watching all bug changes.

1 20

[Bug 15234] Gateway Timeout in z3950_search.pl when a Z39.50 query is performed against a large group of targets.
by bugzilla-daemon＠bugs.koha-community.org 14 May '20

14 May '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15234 Manos PETRIDIS <egpetridis(a)yahoo.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Summary|Administrative interface |Gateway Timeout in |timeout |z3950_search.pl when a | |Z39.50 query is performed | |against a large group of | |targets. --- Comment #5 from Manos PETRIDIS <egpetridis(a)yahoo.com> --- As "Cataloging" is only available at the administrative interface and not the OPAC -as far as I know- I used the term "administrative" in the original title. I have updated the title to "Gateway Timeout in z3950_search.pl when a Z39.50 query is performed against a large group of targets" as to better reflect the malfunction. I have already set timeouts on all target entries in z3950servers table, but the mere fact that the problem does not arise unless one tries to query a large number of servers shows that it is not a matter of specific servers not timing out, but that koha(?) has a total timeout limit set somewhere. It may well be a matter of configuration as you wrote, but then what is the appropriate system preference to amend so that no such timeout occurs. You have set the status to "Resolved Invalid". Have you tried to recreate the error conditions and discovered that no such error manifests itself in a stock koha configuration? -- You are receiving this mail because: You are watching all bug changes.

1 0