summaryrefslogtreecommitdiff
path: root/bin/indexcontacts.sh
diff options
context:
space:
mode:
authoralecpl <alec@alec.pl>2011-03-28 06:49:02 +0000
committeralecpl <alec@alec.pl>2011-03-28 06:49:02 +0000
commit9556e004db346ed5a05d4cf75c4608c72d118ea2 (patch)
tree903f1578066f2a31d6c1d0320b88c7277682e20c /bin/indexcontacts.sh
parentc9f2c470271b83bd8a158de21b8b774b7d46835b (diff)
- Fix SQL query for postgres
Diffstat (limited to 'bin/indexcontacts.sh')
-rwxr-xr-xbin/indexcontacts.sh2
1 files changed, 1 insertions, 1 deletions
diff --git a/bin/indexcontacts.sh b/bin/indexcontacts.sh
index ac20e0441..e8dec2f63 100755
--- a/bin/indexcontacts.sh
+++ b/bin/indexcontacts.sh
@@ -35,7 +35,7 @@ if (!$db->is_connected() || $db->is_error())
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'] . "...";