From 9556e004db346ed5a05d4cf75c4608c72d118ea2 Mon Sep 17 00:00:00 2001
From: alecpl <alec@alec.pl>
Date: Mon, 28 Mar 2011 02:49:02 -0400
Subject: [PATCH] - Fix SQL query for postgres
---
bin/indexcontacts.sh | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/bin/indexcontacts.sh b/bin/indexcontacts.sh
index ac20e04..e8dec2f 100755
--- a/bin/indexcontacts.sh
+++ b/bin/indexcontacts.sh
@@ -35,7 +35,7 @@
die("No DB connection\n");
// iterate over all users
-$sql_result = $db->query("SELECT user_id FROM " . $RCMAIL->config->get('db_table_users', 'users')." WHERE 1");
+$sql_result = $db->query("SELECT user_id FROM " . $RCMAIL->config->get('db_table_users', 'users')." WHERE 1=1");
while ($sql_result && ($sql_arr = $db->fetch_assoc($sql_result))) {
echo "Indexing contacts for user " . $sql_arr['user_id'] . "...";
--
Gitblit v1.9.1