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. "email@example.com,firstname.lastname@example.org") 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: email@example.com,firstname.lastname@example.org: 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.
Sorry, it was Bug 26705 not Bug 26706.
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?
(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.
I found a case of passing --to with multiple addresses to runreports.pl that stopped working, and might be related.
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 "email@example.com,firstname.lastname@example.org,email@example.com" --subject "Sending to firstname.lastname@example.org,email@example.com,firstname.lastname@example.org" --format html 1
*** This bug has been marked as a duplicate of bug 28870 ***