From 94b64368ff6ee87426d450da36831220753268d7 Mon Sep 17 00:00:00 2001 From: Florent Bruneau Date: Wed, 30 Mar 2011 21:03:34 +0200 Subject: [PATCH] Fix to_forlife in list.rpc.py (Closes #1454) Signed-off-by: Florent Bruneau --- bin/lists.rpc.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/bin/lists.rpc.py b/bin/lists.rpc.py index ff30e73..843f7c0 100755 --- a/bin/lists.rpc.py +++ b/bin/lists.rpc.py @@ -202,7 +202,7 @@ def to_forlife(email): mbox = email fqdn = PLATAL_DOMAIN if ( fqdn == PLATAL_DOMAIN ) or ( fqdn == PLATAL_DOMAIN2 ): - res = mysql_fetchone("""SELECT CONCAT(f.alias, '@%s'), a.full_name + res = mysql_fetchone("""SELECT CONCAT(s1.email, '@%s'), a.full_name FROM accounts AS a INNER JOIN email_source_account AS s1 ON (a.uid = s1.uid AND s1.type = 'forlife') INNER JOIN email_source_account AS s2 ON (a.uid = s2.uid AND s2.email = '%s') -- 2.1.4