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 /Zotlabs/Module/Connedit.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 'Zotlabs/Module/Connedit.php')
| -rw-r--r-- | Zotlabs/Module/Connedit.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/Zotlabs/Module/Connedit.php b/Zotlabs/Module/Connedit.php index c11d1ea16..cee593a5f 100644 --- a/Zotlabs/Module/Connedit.php +++ b/Zotlabs/Module/Connedit.php @@ -448,7 +448,7 @@ class Connedit extends \Zotlabs\Web\Controller { } if($cmd === 'resetphoto') { - q("update xchan set xchan_photo_date = '2001-01-01 00:00:00' where xchan_hash = '%s' limit 1", + q("update xchan set xchan_photo_date = '2001-01-01 00:00:00' where xchan_hash = '%s'", dbesc($orig_record[0]['xchan_hash']) ); $cmd = 'refresh'; |