From 6177ec9134b458865ebf382a6e03827bb1834365 Mon Sep 17 00:00:00 2001 From: Mario Vavti Date: Mon, 24 Aug 2020 20:31:59 +0200 Subject: prefix table names --- Zotlabs/Update/_1238.php | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) (limited to 'Zotlabs/Update') 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) { -- cgit v1.2.3