From 192c868192abfeceb739f9e5b4cf235c164873ff Mon Sep 17 00:00:00 2001 From: Florent Bruneau Date: Thu, 1 Jul 2010 09:54:30 +0200 Subject: [PATCH] Fix references to aliases.id. Signed-off-by: Florent Bruneau --- bin/cron/google_apps.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/bin/cron/google_apps.php b/bin/cron/google_apps.php index 307fb7a..f5133f7 100755 --- a/bin/cron/google_apps.php +++ b/bin/cron/google_apps.php @@ -32,7 +32,7 @@ if (!$globals->mailstorage->googleapps_domain) { /* Updates the l_userid parameter for newer user accounts. */ $res = XDB::iterator( - "SELECT g.g_account_name, a.id + "SELECT g.g_account_name, a.uid FROM gapps_accounts AS g LEFT JOIN aliases as a ON (a.alias = g.g_account_name AND a.type = 'a_vie') WHERE (g.l_userid IS NULL OR g.l_userid <= 0) AND a.uid IS NOT NULL"); @@ -58,7 +58,7 @@ while ($account = $res->next()) { /* Updates the l_userid parameter for newer nicknames. */ $res = XDB::iterator( - "SELECT g.g_account_name, a.id + "SELECT g.g_account_name, a.uid FROM gapps_nicknames AS g LEFT JOIN aliases AS a ON (a.alias = g.g_account_name AND a.type = 'a_vie') WHERE (g.l_userid IS NULL or g.l_userid <= 0) AND a.uid IS NOT NULL -- 2.1.4