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