aboutsummaryrefslogtreecommitdiffstats
path: root/util
diff options
context:
space:
mode:
authorMario <mario@mariovavti.com>2019-06-10 22:34:51 +0200
committerMario <mario@mariovavti.com>2019-06-10 22:34:51 +0200
commit6a40f3ed60d14cc7fe0c4b2a66cff33ceb472f7f (patch)
tree08425aadc8aabcbb235c592e4d046aa9ea99cbc9 /util
parentdd1f631d9ddcc488554d44c0259265dd8c75e429 (diff)
downloadvolse-hubzilla-6a40f3ed60d14cc7fe0c4b2a66cff33ceb472f7f.tar.gz
volse-hubzilla-6a40f3ed60d14cc7fe0c4b2a66cff33ceb472f7f.tar.bz2
volse-hubzilla-6a40f3ed60d14cc7fe0c4b2a66cff33ceb472f7f.zip
Revert "PgSQL compatibility on conversion"
This reverts commit dd1f631d9ddcc488554d44c0259265dd8c75e429
Diffstat (limited to 'util')
-rwxr-xr-xutil/storageconv4
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) {