diff options
| author | ilu33 <ilu33@users.noreply.github.com> | 2016-10-22 05:52:29 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2016-10-22 05:52:29 +0200 |
| commit | 351f21c89fd8ad2e30dffa60735d6d14bcbce3a2 (patch) | |
| tree | eab5910d917942a86a47ae4027ff16d53a189b0a | |
| parent | 9fea44cbc36e2e8bb5b2b521694d797e0eadc456 (diff) | |
| download | volse-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.php | 2 |
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()) |