diff options
| author | Mario <mario@mariovavti.com> | 2020-05-12 08:34:35 +0000 |
|---|---|---|
| committer | Mario <mario@mariovavti.com> | 2020-05-12 08:34:35 +0000 |
| commit | 1520a26e0f4356bef13f5988cc5b5db352e2e14a (patch) | |
| tree | 830d14e85382d7d355c811d895d017ffadf79d0c | |
| parent | 6ffdc1b64238f63d3739bb5639b2b4517f90aa34 (diff) | |
| download | volse-hubzilla-1520a26e0f4356bef13f5988cc5b5db352e2e14a.tar.gz volse-hubzilla-1520a26e0f4356bef13f5988cc5b5db352e2e14a.tar.bz2 volse-hubzilla-1520a26e0f4356bef13f5988cc5b5db352e2e14a.zip | |
fix update for postgres
| -rw-r--r-- | Zotlabs/Update/_1238.php | 10 |
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) { |