fix storageconv issue with postgres

(cherry picked from commit 0e2239e50b6a4da8261a03284211d989c87f50e2)

1 files changed, 5 insertions, 2 deletions

diff --git a/util/storageconv b/util/storageconv
index 9c49787d1..c4d981531 100755
--- a/util/storageconv
+++ b/util/storageconv
@@ -46,7 +46,7 @@ if($argc == 2) {
 			}
 
 			$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) {
 					
@@ -54,12 +54,15 @@ if($argc == 2) {
 						dbesc($xx['resource_id']),
 						$storage
 					);
+
+					$img_path = dbunescbin($xx['content']);
 					
 					foreach($n as $nn) {
 						
 						echo '.';
 						
-						$filename = dbunescbin($xx['content']) . '-' . $nn['imgscale'];
+						$filename = $img_path . '-' . $nn['imgscale'];
+
 						if(! file_put_contents($filename, dbunescbin($nn['content']))) {
 							echo 'Failed to save file ' . $filename . PHP_EOL;
 							continue;