mail to deleted account (account expire)

[Michaela Blomberg]

mahara version: 1.4.1
OS: debian squeeze
db: mysql 5.1.63-0+squeeze1

=========mysql table usr==============

username: NNN.deleted.1317203136
active : 0
deleted: 1
expiry: NULL
expirymailsent: 0
lastlogin: 2011-09-22 11:28:13
lastlastlogin: 2011-09-22 11:12:43
lastaccess: 2011-09-22 11:28:13
email: <email address hidden>
inactivemailsent: 0
suspendedctime: NULL
suspendedreason: NULL
suspendedcusr: NULL
====cron: mail delivery failed=======

lib/user.php:422) Cannot send email to (NNN.deleted.131720...) with subject Achtung, Ihr Konto ist nicht aktiv. Error from phpmailer was: Invalid address:<email address hidden>
Call stack (most recent first):
  * email_user(object(stdClass), null, "Achtung, Ihr Konto ist nicht aktiv", "Sehr geehrter ,

Ihr Zugang bei FCZB E-Portfolio ...", "<p>Hallo ,</p>

<p>Ihr Zugang ...") at ...auth/lib.php:1312
  * _email_or_notify(object(stdClass), "Achtung, Ihr Konto ist nicht aktiv", "Sehr geehrter ,

Ihr Zugang bei ...", "<p>Hallo ,</p>

[Kristina Hoeppner (kris-hoeppner)]

Hello Michaela,

What's the bug that you are reporting? Is it that emails are still sent to expired accounts? Accounts do not get deleted by Mahara automatically. They are either inactive or expired. When an account is deleted, there is no reference to it anywhere in the DB and thus no mails would be sent.

Cheers
Kristina

[Michaela Blomberg (blomberg)]

hello kristina,
there are still some deleted logins in the table urs (deleted=1, expire=0. they don't get any emails, because mahara rename the email into <email address hidden>. i could only see the trail in the webserver logfile and I wondered about the error.
but if it's not normal to have deleted login in the table usr, it's not a bug, that the system wants to write an email ;)

[Hugh Davenport (hugh-davenport)]

We need to figure out why it wants to send emails to deleted users. Michaela, can you help on this front.

If the emails are legitimate, we should change the email to remove the .deleted in the address.

If they are not, we should change it so it doesn't try to send to the deleted user

[Michaela Blomberg (blomberg)]

hello hugh,

the mail ist a warning:

"Achtung, Ihr Konto ist nicht aktiv!"
Hallo ,
Ihr Zugang bei XXX wird in 14 Tage enden. Sie können den Zugang erst dann wieder benützen, wenn ein Administrator den Zugang freigeschaltet hat. Sie können dieses umgehen, indem Sie sich anmelden."

it means, that the (deleted) account would't expired in 14 days, I get the mail year after creating the account.

the mail ist not legitmate, because mahara add the .deleted prefix. this ist ok, because the user should not get this mail.