aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorilu33 <ilu33@users.noreply.github.com>2016-10-22 05:52:29 +0200
committerGitHub <noreply@github.com>2016-10-22 05:52:29 +0200
commit351f21c89fd8ad2e30dffa60735d6d14bcbce3a2 (patch)
treeeab5910d917942a86a47ae4027ff16d53a189b0a
parent9fea44cbc36e2e8bb5b2b521694d797e0eadc456 (diff)
downloadvolse-hubzilla-351f21c89fd8ad2e30dffa60735d6d14bcbce3a2.tar.gz
volse-hubzilla-351f21c89fd8ad2e30dffa60735d6d14bcbce3a2.tar.bz2
volse-hubzilla-351f21c89fd8ad2e30dffa60735d6d14bcbce3a2.zip
Postgres complaining again ...
```sql UPDATE abook SET abook_profile = (SELECT profile_guid AS FROM profile WHERE is_default = 1 AND uid = 13 LIMIT 1) WHERE abook_profile = '' AND abook_channel = 13 ; returned false ERROR: syntax error at or near "profile" LINE 1: ... SET abook_profile = (SELECT profile_guid AS FROM profile WH... ^ ```
-rw-r--r--Zotlabs/Module/Profiles.php2
1 files changed, 1 insertions, 1 deletions
diff --git a/Zotlabs/Module/Profiles.php b/Zotlabs/Module/Profiles.php
index 127304f92..19a642a83 100644
--- a/Zotlabs/Module/Profiles.php
+++ b/Zotlabs/Module/Profiles.php
@@ -31,7 +31,7 @@ class Profiles extends \Zotlabs\Web\Controller {
// move every contact using this profile as their default to the user default
- $r = q("UPDATE abook SET abook_profile = (SELECT profile_guid AS FROM profile WHERE is_default = 1 AND uid = %d LIMIT 1) WHERE abook_profile = '%s' AND abook_channel = %d ",
+ $r = q("UPDATE abook SET abook_profile = (SELECT profile_guid FROM profile WHERE is_default = 1 AND uid = %d LIMIT 1) WHERE abook_profile = '%s' AND abook_channel = %d ",
intval(local_channel()),
dbesc($profile_guid),
intval(local_channel())