From 6a40f3ed60d14cc7fe0c4b2a66cff33ceb472f7f Mon Sep 17 00:00:00 2001 From: Mario Date: Mon, 10 Jun 2019 22:34:51 +0200 Subject: Revert "PgSQL compatibility on conversion" This reverts commit dd1f631d9ddcc488554d44c0259265dd8c75e429 --- util/storageconv | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'util/storageconv') diff --git a/util/storageconv b/util/storageconv index 1e053e075..9c49787d1 100755 --- a/util/storageconv +++ b/util/storageconv @@ -45,7 +45,7 @@ if($argc == 2) { break; } - $x = q("SELECT resource_id, content FROM photo WHERE photo_usage = 0 AND os_storage = 1 AND imgscale = 0"); + $x = q("SELECT DISTINCT resource_id, content FROM photo WHERE photo_usage = 0 AND os_storage = 1 AND imgscale = 0"); if($x) { foreach($x as $xx) { @@ -85,7 +85,7 @@ if($argc == 2) { break; } - $x = q("SELECT resource_id FROM photo WHERE photo_usage = 0 AND os_storage = 1 AND imgscale = 0"); + $x = q("SELECT DISTINCT resource_id FROM photo WHERE photo_usage = 0 AND os_storage = 1 AND imgscale = 0"); if($x) { foreach($x as $xx) { -- cgit v1.2.3