aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorMario <mario@mariovavti.com>2020-05-12 08:34:35 +0000
committerMario <mario@mariovavti.com>2020-05-12 08:34:35 +0000
commit1520a26e0f4356bef13f5988cc5b5db352e2e14a (patch)
tree830d14e85382d7d355c811d895d017ffadf79d0c
parent6ffdc1b64238f63d3739bb5639b2b4517f90aa34 (diff)
downloadvolse-hubzilla-1520a26e0f4356bef13f5988cc5b5db352e2e14a.tar.gz
volse-hubzilla-1520a26e0f4356bef13f5988cc5b5db352e2e14a.tar.bz2
volse-hubzilla-1520a26e0f4356bef13f5988cc5b5db352e2e14a.zip
fix update for postgres
-rw-r--r--Zotlabs/Update/_1238.php10
1 files changed, 5 insertions, 5 deletions
diff --git a/Zotlabs/Update/_1238.php b/Zotlabs/Update/_1238.php
index 428f7ce15..e08cd334f 100644
--- a/Zotlabs/Update/_1238.php
+++ b/Zotlabs/Update/_1238.php
@@ -21,11 +21,11 @@ class _1238 {
// fix singleton networks hubloc_id_url
$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 != ''"
+ 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($r1 && $r2) {