Fix c&p error

diff --git a/cookbooks/planet/templates/default/users-deleted.erb b/cookbooks/planet/templates/default/users-deleted.erb
index 6360d28c6ef568e99fe43b1eaaff656c466b52aa..a4d4c71f05f5bee0f6ff2f17324d62355b3df745 100644 (file)
--- a/cookbooks/planet/templates/default/users-deleted.erb
+++ b/cookbooks/planet/templates/default/users-deleted.erb
@@ -8,7 +8,7 @@ T=$(mktemp -d -t -p /var/tmp users.XXXXXXXXXX)
 export PGPASSFILE=/etc/replication/users-agreed.conf
 
 echo "# user IDs of deleted users. " > $T/users_deleted
-psql -h <%= node[:web][:readonly_database_host] %> -U planetdiff -t -c "select id from users where status='deleted' by id asc" openstreetmap >> $T/users_deleted
+psql -h <%= node[:web][:readonly_database_host] %> -U planetdiff -t -c "select id from users where status='deleted' order by id asc" openstreetmap >> $T/users_deleted
 
 if cmp -s "${T}/users_deleted "/store/planet/users_deleted.txt"; then
   : # do nothing