diff options
author | Habeas Codice <habeascodice@federated.social> | 2015-01-24 22:07:53 -0800 |
---|---|---|
committer | Habeas Codice <habeascodice@federated.social> | 2015-01-24 22:07:53 -0800 |
commit | 1d6aead325aa052fbacaad24efdbc784f1ee9407 (patch) | |
tree | eefc12a7d0b39c6cab511a787bbd3b57aca3620f | |
parent | af7fa99e2ec819164e5800412f8bcbff44bc1c63 (diff) | |
download | volse-hubzilla-1d6aead325aa052fbacaad24efdbc784f1ee9407.tar.gz volse-hubzilla-1d6aead325aa052fbacaad24efdbc784f1ee9407.tar.bz2 volse-hubzilla-1d6aead325aa052fbacaad24efdbc784f1ee9407.zip |
remove superfluous group by
this gets called from a zot post_post dealing with a specific messageid and hubloc_hash combination. grouping by site
doesn't make sense here and it gets grouped when pulled back out elsewhere anyway
-rw-r--r-- | include/zot.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/include/zot.php b/include/zot.php index 3d92f7824..780c6a265 100644 --- a/include/zot.php +++ b/include/zot.php @@ -2919,7 +2919,7 @@ function zot_process_message_request($data) { $r = q("select hubloc_guid, hubloc_url, hubloc_sitekey, hubloc_network, hubloc_flags, hubloc_callback, hubloc_host from hubloc where hubloc_hash = '%s' and not (hubloc_flags & %d)>0 - and not (hubloc_status & %d)>0 group by hubloc_sitekey", + and not (hubloc_status & %d)>0 ", dbesc($sender_hash), intval(HUBLOC_FLAGS_DELETED), intval(HUBLOC_OFFLINE) |