aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--Zotlabs/Update/_1238.php26
1 files changed, 19 insertions, 7 deletions
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");