[Maia-users] Strange thing happened when linking an account to mine...

[Robert LeBlanc]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Kurt Buff wrote:
> I just linked an account to mine.
> 
> It had 26 unconfirmed non-spam and 1010 unconfirmed spam.
> 
> I linked it, and expected all of the above unconfirmed emails to show in my
> interface. Nothing. Nada. They all disappeared.
> 
> However, new emails to this address are showing up in the interface. 
> 
> Wha' happen?

Good question :)  At the time accounts are linked, the recipient IDs of
the mail items belonging to the linkee are supposed to be changed to
that of the linker, so that ownership of those items is transferred as
well.  Apparently this did not happen in your case, and I'd be
interested to know why.  Perhaps a database-related error occurred at
some point in the middle of the process; your PHP logs or web server's
error log might have some evidence to report.

I don't suppose you happen to know the old maia_users.id number of the
user that whose account you linked to yours?  If you do, you can try
querying the maia_mail_recipients table for items tied to that recipient
ID and simply change the recipient IDs manually for that set of items.
One simple query should fix it, e.g.

 UPDATE maia_mail_recipients
 SET recipient_id = <new user ID>
 WHERE recipient_id = <old user ID>;

This presumes, of course, that the mail in question hasn't already been
deleted by the expire-quarantine-cache.pl script (which would likely see
them as "orphans").

- --
Robert LeBlanc <rjl at renaissoft.com>
Renaissoft, Inc.
Maia Mailguard <http://www.maiamailguard.com/>

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (GNU/Linux)

iD8DBQFGpnaRGmqOER2NHewRAlfZAKCLHtJdEH70i6f/glCv0vBGcXnXbgCfem6k
a+ULX/2QZj99ulxKuHdZZE8=
=rQSk
-----END PGP SIGNATURE-----