[Bug 26452] New: overdue_notices causes "uninitialized value in string"
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26452 Bug ID: 26452 Summary: overdue_notices causes "uninitialized value in string" Change sponsored?: --- Product: Koha Version: 20.05 Hardware: PC OS: Linux Status: NEW Severity: normal Priority: P5 - low Component: Fines and fees Assignee: koha-bugs@lists.koha-community.org Reporter: wyneken@physik.uni-freiburg.de QA Contact: testopia@bugs.koha-community.org I just updated my Koha from 17.05 to 20.05 when I upgraded the server from Debian Stretch to Debian Buster. Now when I execute: koha-foreach --chdir --enabled --email /usr/share/koha/bin/cronjobs/overdue_notices.pl -t I get the following error/warning: Use of uninitialized value in string eq at /usr/share/koha/lib/C4/Overdues.pm line 663. Can anybody tell me what this means? Is it a big problem? -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26452 Matthew Wyneken <wyneken@physik.uni-freiburg.de> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |wyneken@physik.uni-freiburg | |.de -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26452 --- Comment #1 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Can you give your exact Koha version for the line numbers? (20.05.xx) It's more likely to be a warn than a big issue. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26452 --- Comment #2 from Matthew Wyneken <wyneken@physik.uni-freiburg.de> --- Thank you for responding! The version is 20.05.03.000. If it's just a warning is it maybe just complaining about a single account? Is there any way to find out which account it is and what exactly it's complaining about? -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26452 --- Comment #3 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- It looks like this is the line in your version: http://git.koha-community.org/gitweb/?p=koha.git;a=blob;f=C4/Overdues.pm;h=a... Maybe it could help to run this SQL statement and see what it returns: 658 SELECT DISTINCT(branchcode) 659 FROM overduerules 660 WHERE delay1 IS NOT NULL 661 ORDER BY branchcode -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26452 --- Comment #4 from Matthew Wyneken <wyneken@physik.uni-freiburg.de> --- Thanks for the response, Katrin! I really don't know much about mysql so I hope I did this correctly. I created a script file test.sql: USE koha_libschil SELECT DISTINCT(branchcode) FROM overduerules WHERE delay1 IS NOT NULL ORDER BY branchcode Then I executed it like this but there was no output at all: # mysql --user=root -p <test.sql Enter password: Does that provide any useful information? -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26452 --- Comment #5 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Sorry, not really. What you can do is: - In Koha: Reports > New from SQL > Paste the command there, save and run - Check your configuration under Tools > Ovrdue notice triggers makes sense and looks complete -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26452 --- Comment #6 from Matthew Wyneken <wyneken@physik.uni-freiburg.de> --- I created a new report and ran it. The results: MyReportName Rows per page: <20> branchcode So again, nothing. Under "Overdue notice/status triggers" I have three tabs: First, Second, Third. Each of them has two lines: Adult, Student. Everything is blank, though. This Koha instance is for the library of a university department. It's basically only used to keep track of the books. It's not even used to check books out so there isn't much of anything configured. There are five users, mostly for administrative purposes. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26452 --- Comment #7 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Ah ok, maybe it would be easiest to just deactivate that cronjob then? I think it complains about missing configuration - but it makes not sense to set it up if not used. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26452 --- Comment #8 from Matthew Wyneken <wyneken@physik.uni-freiburg.de> --- That is a simple and elegant solution to the problem! It's a good thing I gave you the background. Thanks! -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26452 --- Comment #9 from Matthew Wyneken <wyneken@physik.uni-freiburg.de> --- I just commented out the line in /etc/cron.daily/koha-common. Or is the way to do that using the web site? -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26452 Matthew Wyneken <wyneken@physik.uni-freiburg.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution|--- |FIXED -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org