Ian, Your are right! The to_address gets set by the process_message_queue. After changing AutoEmailPrimaryAddress to "first valid" everyone else got the overdue notice. Just for the book I have entered (and made overdue) for myself the system did not create a overdue record to be sent. Now I have to check why not. Thanks a lot for your help. Rudy Wuthrich Kodaikanal International School
Ian Walls <ian.walls@bywatersolutions.com> 11/2/2011 2:33 PM >>> Rudy,
I've found that to_address remains null until process_message_queue sends the message; this is so that if the email changes between when the notice is generated and when it's sent, the most up-to-date email is used. Can you check to see if messages are going out now? At the least, if you see "sent" in a patron's message history, instead of "failed", you'll know this is working (whether the email reaches the patron, there is no way to know). -Ian On Wed, Nov 2, 2011 at 4:54 AM, ISM KIS <Ism@kis.in> wrote:
Ian,
Thank you for your input.
The setting was on "alternate" and I changed it to "first valid"
But still it does not enter anything into the to_address field.
Maybe I need to restart the server? I'll do that tomorrow morning before the library opens.
Let's hope.
Rudy
Ian Walls <ian.walls@bywatersolutions.com> 11/2/2011 12:02 PM >>> Rudy,
Check your AutoEmailPrimaryAddress system preference. It should be either "email" or "first valid".... we've found sometimes it gets defaulted to "alternate", which results in failed messages.
Cheers,
-Ian
On Wed, Nov 2, 2011 at 1:09 AM, ISM KIS <Ism@kis.in> wrote:
After upgrading to Koha 3.4.5 we have noticed that the overdue notices were not sent.
The cron jobs are running and the message_queue table gets updated. The borrowernumber is correct in the message_queue but the to_address field is NULL. ( select email from borrowers where borrowernumber = xxx gives me the correct email)
Any ideas why the to_address field is NULL and what to do about this?
If I manually update the to_address and run process_message_queue.plthen the notices are sent ok.
Thanks for any help.
Rudy Wuthrich Kodaikanal International School
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Ian Walls Lead Development Specialist ByWater Solutions Phone # (888) 900-8944 http://bywatersolutions.com ian.walls@bywatersolutions.com Twitter: @sekjal
-- Ian Walls Lead Development Specialist ByWater Solutions Phone # (888) 900-8944 http://bywatersolutions.com ian.walls@bywatersolutions.com Twitter: @sekjal