From 326644104c169ddcc5188af994e1a0fa932ad99f Mon Sep 17 00:00:00 2001
From: Mario <mario@mariovavti.com>
Date: Tue, 12 May 2020 08:56:05 +0000
Subject: really fix update for postgres

---
 Zotlabs/Update/_1238.php | 26 +++++++++++++++++++-------
 1 file changed, 19 insertions(+), 7 deletions(-)

(limited to 'Zotlabs/Update')

diff --git a/Zotlabs/Update/_1238.php b/Zotlabs/Update/_1238.php
index e08cd334f..92dfeef38 100644
--- a/Zotlabs/Update/_1238.php
+++ b/Zotlabs/Update/_1238.php
@@ -20,13 +20,25 @@ class _1238 {
 		);
 
 		// fix singleton networks hubloc_id_url
-		$r2 = q("UPDATE hubloc
-			LEFT JOIN xchan ON hubloc.hubloc_hash = xchan.xchan_hash
-			SET hubloc.hubloc_id_url = xchan.xchan_url
-			WHERE hubloc.hubloc_network IN ('activitypub', 'diaspora', 'friendica-over-diaspora', 'gnusoc')
-			AND hubloc.hubloc_id_url = ''
-			AND xchan.xchan_url != ''"
-		);
+		if(ACTIVE_DBTYPE == DBTYPE_MYSQL) {
+			$r2 = q("UPDATE hubloc
+				LEFT JOIN xchan ON hubloc_hash = xchan_hash
+				SET hubloc_id_url = xchan_url
+				WHERE hubloc_network IN ('activitypub', 'diaspora', 'friendica-over-diaspora', 'gnusoc')
+				AND hubloc_id_url = ''
+				AND xchan_url != ''"
+			);
+		}
+		if(ACTIVE_DBTYPE == DBTYPE_POSTGRES) {
+			$r2 = q("UPDATE hubloc                                                                                   
+				SET hubloc_id_url = xchan_url
+				FROM xchan
+				WHERE hubloc_hash = xchan_hash
+				AND hubloc_network IN ('activitypub', 'diaspora', 'friendica-over-diaspora', 'gnusoc')
+				AND hubloc_id_url = ''
+				AND xchan_url != ''"
+			);
+		}
 
 		if($r1 && $r2) {
 			q("COMMIT");
-- 
cgit v1.2.3