diff options
author | zotlabs <mike@macgirvin.com> | 2016-10-27 12:38:46 +1100 |
---|---|---|
committer | GitHub <noreply@github.com> | 2016-10-27 12:38:46 +1100 |
commit | 9e46409517c2f2fe1929d3332445aa8d8674c5ab (patch) | |
tree | 576130ba970381bdad7018b7fc56522984552195 /install/update.php | |
parent | d42da529ece416a3d69d30eea7ded96731774a62 (diff) | |
parent | c1c96e01fab131dd48cd68cdd9b63639e269d9c8 (diff) | |
download | volse-hubzilla-9e46409517c2f2fe1929d3332445aa8d8674c5ab.tar.gz volse-hubzilla-9e46409517c2f2fe1929d3332445aa8d8674c5ab.tar.bz2 volse-hubzilla-9e46409517c2f2fe1929d3332445aa8d8674c5ab.zip |
Merge pull request #570 from fsteinel/issue-NEW
sql: limit 1 for UPDATE and DELETE is not supported …
Diffstat (limited to 'install/update.php')
-rw-r--r-- | install/update.php | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/install/update.php b/install/update.php index fc6641c55..7e7104b74 100644 --- a/install/update.php +++ b/install/update.php @@ -1095,7 +1095,7 @@ function update_r1097() { $r = q("select hubloc_id, hubloc_addr from hubloc where hubloc_addr like '%%/%%'"); if($r) { foreach($r as $rr) { - q("update hubloc set hubloc_addr = '%s' where hubloc_id = %d limit 1", + q("update hubloc set hubloc_addr = '%s' where hubloc_id = %d", dbesc(substr($rr['hubloc_addr'],0,strpos($rr['hubloc_addr'],'/'))), intval($rr['hubloc_id']) ); @@ -2462,4 +2462,4 @@ function update_r1183() { if($r1 && $r2) return UPDATE_SUCCESS; return UPDATE_FAILED; -}
\ No newline at end of file +} |