diff options
| author | Mario <mario@mariovavti.com> | 2020-05-12 09:13:59 +0000 |
|---|---|---|
| committer | Mario <mario@mariovavti.com> | 2020-05-12 09:13:59 +0000 |
| commit | 1329662edcfc9650982a770247fb52d3ab9c55a3 (patch) | |
| tree | 645a6e174c177f1c60c0e34a3a1dd521cb1eb8f6 | |
| parent | 249427365b4304088c6c9cea37caea1e03ea8ccf (diff) | |
| download | volse-hubzilla-1329662edcfc9650982a770247fb52d3ab9c55a3.tar.gz volse-hubzilla-1329662edcfc9650982a770247fb52d3ab9c55a3.tar.bz2 volse-hubzilla-1329662edcfc9650982a770247fb52d3ab9c55a3.zip | |
use dbq() in update 1238
| -rw-r--r-- | Zotlabs/Update/_1238.php | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/Zotlabs/Update/_1238.php b/Zotlabs/Update/_1238.php index 92dfeef38..77a14c3fa 100644 --- a/Zotlabs/Update/_1238.php +++ b/Zotlabs/Update/_1238.php @@ -13,7 +13,7 @@ class _1238 { ); // fix legacy zot hubloc_id_url - $r1 = q("UPDATE hubloc + $r1 = dbq("UPDATE hubloc SET hubloc_id_url = CONCAT(hubloc_url, '/channel/', SUBSTRING(hubloc_addr FROM 1 FOR POSITION('@' IN hubloc_addr) -1)) WHERE hubloc_network = 'zot' AND hubloc_id_url = ''" @@ -21,7 +21,7 @@ class _1238 { // fix singleton networks hubloc_id_url if(ACTIVE_DBTYPE == DBTYPE_MYSQL) { - $r2 = q("UPDATE hubloc + $r2 = 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') @@ -30,7 +30,7 @@ class _1238 { ); } if(ACTIVE_DBTYPE == DBTYPE_POSTGRES) { - $r2 = q("UPDATE hubloc + $r2 = dbq("UPDATE hubloc SET hubloc_id_url = xchan_url FROM xchan WHERE hubloc_hash = xchan_hash |