aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorMario Vavti <mario@mariovavti.com>2020-08-24 20:31:59 +0200
committerMario Vavti <mario@mariovavti.com>2020-08-24 20:31:59 +0200
commit6177ec9134b458865ebf382a6e03827bb1834365 (patch)
treeab3b624205fb2d4469c431afcbceeb55bea605fe
parentbd4867ef39fee496170167bb4046a4807aa2cdd9 (diff)
downloadvolse-hubzilla-6177ec9134b458865ebf382a6e03827bb1834365.tar.gz
volse-hubzilla-6177ec9134b458865ebf382a6e03827bb1834365.tar.bz2
volse-hubzilla-6177ec9134b458865ebf382a6e03827bb1834365.zip
prefix table names
-rw-r--r--Zotlabs/Module/Fhubloc_id_url.php8
-rw-r--r--Zotlabs/Update/_1238.php8
2 files changed, 8 insertions, 8 deletions
diff --git a/Zotlabs/Module/Fhubloc_id_url.php b/Zotlabs/Module/Fhubloc_id_url.php
index 6303e2460..eb86b702d 100644
--- a/Zotlabs/Module/Fhubloc_id_url.php
+++ b/Zotlabs/Module/Fhubloc_id_url.php
@@ -30,10 +30,10 @@ class Fhubloc_id_url extends \Zotlabs\Web\Controller {
);
$r3 = dbq("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 = ''"
+ 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 = ''"
);
}
diff --git a/Zotlabs/Update/_1238.php b/Zotlabs/Update/_1238.php
index 2a10e594f..533358219 100644
--- a/Zotlabs/Update/_1238.php
+++ b/Zotlabs/Update/_1238.php
@@ -32,10 +32,10 @@ class _1238 {
);
$r3 = dbq("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 = ''"
+ 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 = ''"
);
}
if(ACTIVE_DBTYPE == DBTYPE_POSTGRES) {