[Bug 28019] New: Script "process_message_queue.pl" no more accepting comma separated addresses
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28019 Bug ID: 28019 Summary: Script "process_message_queue.pl" no more accepting comma separated addresses Change sponsored?: --- Product: Koha Version: 20.11 Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: koha-bugs@lists.koha-community.org Reporter: mik@adminkuhn.ch QA Contact: testopia@bugs.koha-community.org Since in the Koha staff client it is not possible to send the same e-mail to two recipients at once we have regularly updated field "message_queue.to_address" of pending messages by SQL to contain two addresses instead of one (e. g. "abc@def.com,xyz@def.com") and in Koha 19.11 script "process_message_queue.pl" sent these notices to both addresses without a problem. But after the update to Koha 20.11 this doesn't work anymore - instead the script says: Invalid 'to' parameter: abc@def.com,xyz@def.comxxx: 11 status returned by "/usr/share/koha/bin/cronjobs/process_message_queue.pl" In Bug 26706 Tomas Cohen Arazi wrote: "The non-advertised feature of accepting comma separated addresses is still not working. I can solve it on a separate bug report if someone files it. It needs to specify which fields could be multi-address." I our case field "message_queue.to_address" did contain two comma separated addresses. According to http://schema.koha-community.org/20_11/tables/message_queue.html this is the only field that contains recipients. -- 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=28019 --- Comment #1 from Michael Kuhn <mik@adminkuhn.ch> --- Sorry, it was Bug 26705 not Bug 26706. -- 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=28019 Tomás Cohen Arazi <tomascohen@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |tomascohen@gmail.com Version|20.11 |master --- Comment #2 from Tomás Cohen Arazi <tomascohen@gmail.com> --- Ok, so this was some hack: you manually intercept the messages_queue unsent messages, and tweak the message_queue.to_address column. Can you explain a bit more why aren't you using (say) NoticeBcc? -- 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=28019 --- Comment #3 from Michael Kuhn <mik@adminkuhn.ch> --- (In reply to Tomás Cohen Arazi from comment #2)
Ok, so this was some hack: you manually intercept the messages_queue unsent messages, and tweak the message_queue.to_address column.
Can you explain a bit more why aren't you using (say) NoticeBcc?
The first address is the one the main user while the second address is either a second address of this same person (e. g. his home address) or the address of his secretary (which actually often cares about the checked-out media instead of the main user). We do use system preference "NoticeBcc" but this contains another address - the head of the library (while at the moment in Koha 20.11 this also doesn't work, see Bug 26705) who needs to control what e-mails where sent out. -- 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=28019 Tomás Cohen Arazi <tomascohen@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Assignee|koha-bugs@lists.koha-commun |tomascohen@gmail.com |ity.org | -- 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=28019 Tomás Cohen Arazi <tomascohen@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |ASSIGNED --- Comment #4 from Tomás Cohen Arazi <tomascohen@gmail.com> --- I found a case of passing --to with multiple addresses to runreports.pl that stopped working, and might be related. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28019 Tomás Cohen Arazi <tomascohen@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |DUPLICATE Status|ASSIGNED |RESOLVED --- Comment #5 from Tomás Cohen Arazi <tomascohen@gmail.com> --- This is actually fixed by bug 28870. Tested on master with (a good SMTP config on koha-conf.xml and) this command: $ perl misc/cronjobs/runreport.pl --to "tomascohen@gmail.com,nick@bywatersolutions.com,liz@bywatersolutions.com" --subject "Sending to tomascohen@gmail.com,nick@bywatersolutions.com,liz@bywatersolutions.com" --format html 1 *** This bug has been marked as a duplicate of bug 28870 *** -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org