diff options
| author | alecpl <alec@alec.pl> | 2011-03-28 06:49:02 +0000 |
|---|---|---|
| committer | alecpl <alec@alec.pl> | 2011-03-28 06:49:02 +0000 |
| commit | 9556e004db346ed5a05d4cf75c4608c72d118ea2 (patch) | |
| tree | 903f1578066f2a31d6c1d0320b88c7277682e20c | |
| parent | c9f2c470271b83bd8a158de21b8b774b7d46835b (diff) | |
- Fix SQL query for postgres
| -rwxr-xr-x | bin/indexcontacts.sh | 2 |
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'] . "..."; |