aboutsummaryrefslogtreecommitdiffstats
path: root/install
diff options
context:
space:
mode:
authorFlorian Steinel <fsteinel@users.noreply.github.com>2016-10-27 02:41:32 +0200
committerFlorian Steinel <fsteinel@users.noreply.github.com>2016-10-27 02:41:32 +0200
commitc1c96e01fab131dd48cd68cdd9b63639e269d9c8 (patch)
tree3df5a97bc8829cdf811498e6f79c5653a7f7be73 /install
parentc3af36d33b9a08aacecd572ad17fe33362617d23 (diff)
downloadvolse-hubzilla-c1c96e01fab131dd48cd68cdd9b63639e269d9c8.tar.gz
volse-hubzilla-c1c96e01fab131dd48cd68cdd9b63639e269d9c8.tar.bz2
volse-hubzilla-c1c96e01fab131dd48cd68cdd9b63639e269d9c8.zip
sql: limit 1 for UPDATE and DELETE is not supported by the SQL standard and postgresql
(see: https://www.postgresql.org/message-id/flat/1291109101.26137.35.camel%40pcd12478 )
Diffstat (limited to 'install')
-rw-r--r--install/update.php4
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
+}