diff options
author | Florian Steinel <fsteinel@users.noreply.github.com> | 2016-10-27 02:41:32 +0200 |
---|---|---|
committer | Florian Steinel <fsteinel@users.noreply.github.com> | 2016-10-27 02:41:32 +0200 |
commit | c1c96e01fab131dd48cd68cdd9b63639e269d9c8 (patch) | |
tree | 3df5a97bc8829cdf811498e6f79c5653a7f7be73 /include/network.php | |
parent | c3af36d33b9a08aacecd572ad17fe33362617d23 (diff) | |
download | volse-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 'include/network.php')
-rw-r--r-- | include/network.php | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/include/network.php b/include/network.php index 24e77527f..7cfd3a5e6 100644 --- a/include/network.php +++ b/include/network.php @@ -1434,7 +1434,7 @@ function discover_by_webbie($webbie) { dbesc($address) ); if($r) { - $r = q("update xchan set xchan_name = '%s', xchan_network = '%s', xchan_name_date = '%s' where xchan_hash = '%s' limit 1", + $r = q("update xchan set xchan_name = '%s', xchan_network = '%s', xchan_name_date = '%s' where xchan_hash = '%s'", dbesc($fullname), dbesc($network), dbesc(datetime_convert()), @@ -2328,4 +2328,4 @@ function probe_api_path($host) { } return ''; -}
\ No newline at end of file +} |