[Koha] overdue_notives - to_address field is not populated

[ISM KIS]

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 at 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 at 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 at 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 at 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 at 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 at bywatersolutions.com 
> Twitter: @sekjal
>
>


-- 
Ian Walls
Lead Development Specialist
ByWater Solutions
Phone # (888) 900-8944
http://bywatersolutions.com 
ian.walls at bywatersolutions.com 
Twitter: @sekjal