From 1e52f1788a44b94c0df1c1038d905b59ca3ab9de Mon Sep 17 00:00:00 2001 From: alec Date: Mon, 28 Mar 2011 06:49:02 +0000 Subject: - Fix SQL query for postgres git-svn-id: https://svn.roundcube.net/trunk@4623 208e9e7b-5314-0410-a742-e7e81cd9613c --- roundcubemail/bin/indexcontacts.sh | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/roundcubemail/bin/indexcontacts.sh b/roundcubemail/bin/indexcontacts.sh index ac20e0441..e8dec2f63 100755 --- a/roundcubemail/bin/indexcontacts.sh +++ b/roundcubemail/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'] . "..."; -- cgit v1.2.3