Fix c&p error
authorSimon Poole <simon@poole.ch>
Wed, 5 Sep 2018 14:02:17 +0000 (16:02 +0200)
committerSimon Poole <simon@poole.ch>
Wed, 5 Sep 2018 14:02:17 +0000 (16:02 +0200)
cookbooks/planet/templates/default/users-deleted.erb

index 6360d28c6ef568e99fe43b1eaaff656c466b52aa..a4d4c71f05f5bee0f6ff2f17324d62355b3df745 100644 (file)
@@ -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