diff options
| author | Mario Vavti <mario@mariovavti.com> | 2020-08-24 20:31:59 +0200 |
|---|---|---|
| committer | Mario Vavti <mario@mariovavti.com> | 2020-08-24 20:31:59 +0200 |
| commit | 6177ec9134b458865ebf382a6e03827bb1834365 (patch) | |
| tree | ab3b624205fb2d4469c431afcbceeb55bea605fe | |
| parent | bd4867ef39fee496170167bb4046a4807aa2cdd9 (diff) | |
| download | volse-hubzilla-6177ec9134b458865ebf382a6e03827bb1834365.tar.gz volse-hubzilla-6177ec9134b458865ebf382a6e03827bb1834365.tar.bz2 volse-hubzilla-6177ec9134b458865ebf382a6e03827bb1834365.zip | |
prefix table names
| -rw-r--r-- | Zotlabs/Module/Fhubloc_id_url.php | 8 | ||||
| -rw-r--r-- | Zotlabs/Update/_1238.php | 8 |
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) { |