diff -r 9d10877e1c10 -r 92a6132940f5 VirtualMailManager/Account.py --- a/VirtualMailManager/Account.py Thu Aug 14 00:33:31 2008 +0000 +++ b/VirtualMailManager/Account.py Thu Aug 14 18:05:21 2008 +0000 @@ -222,8 +222,9 @@ raise VMMAccountException((_('uid must be greater than 0.'), ERR.INVALID_AGUMENT)) dbc = dbh.cursor() - dbc.execute("SELECT local_part||'@'||domains.domainname AS address, uid,\ - gid FROM users LEFT JOIN domains USING(gid) WHERE uid=%s", uid) + dbc.execute("SELECT local_part||'@'|| domain_name.domainname AS address,\ + uid, users.gid FROM users LEFT JOIN domain_name ON (domain_name.gid \ + = users.gid AND is_primary) WHERE uid = %s;", uid) info = dbc.fetchone() dbc.close() if info is None: