diff options
| author | Mario <mario@mariovavti.com> | 2019-06-10 22:34:51 +0200 |
|---|---|---|
| committer | Mario <mario@mariovavti.com> | 2019-06-10 22:34:51 +0200 |
| commit | 6a40f3ed60d14cc7fe0c4b2a66cff33ceb472f7f (patch) | |
| tree | 08425aadc8aabcbb235c592e4d046aa9ea99cbc9 | |
| parent | dd1f631d9ddcc488554d44c0259265dd8c75e429 (diff) | |
| download | volse-hubzilla-6a40f3ed60d14cc7fe0c4b2a66cff33ceb472f7f.tar.gz volse-hubzilla-6a40f3ed60d14cc7fe0c4b2a66cff33ceb472f7f.tar.bz2 volse-hubzilla-6a40f3ed60d14cc7fe0c4b2a66cff33ceb472f7f.zip | |
Revert "PgSQL compatibility on conversion"
This reverts commit dd1f631d9ddcc488554d44c0259265dd8c75e429
| -rwxr-xr-x | util/storageconv | 4 |
1 files changed, 2 insertions, 2 deletions
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) { |