aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorzotlabs <mike@macgirvin.com>2018-05-07 19:33:58 -0700
committerzotlabs <mike@macgirvin.com>2018-05-07 19:33:58 -0700
commit0c43a9bb5dae1ab6c1646c690f0e9b765e88832e (patch)
treeca615dce939f9ceed9f31d4ddc6b35f1589f028d
parenteb85d381fdb447d23e568dfecbde24a860879952 (diff)
downloadvolse-hubzilla-0c43a9bb5dae1ab6c1646c690f0e9b765e88832e.tar.gz
volse-hubzilla-0c43a9bb5dae1ab6c1646c690f0e9b765e88832e.tar.bz2
volse-hubzilla-0c43a9bb5dae1ab6c1646c690f0e9b765e88832e.zip
yet another postgres/"group by" issue
-rw-r--r--Zotlabs/Module/Search.php4
1 files changed, 2 insertions, 2 deletions
diff --git a/Zotlabs/Module/Search.php b/Zotlabs/Module/Search.php
index 43464ad8b..3a552bb22 100644
--- a/Zotlabs/Module/Search.php
+++ b/Zotlabs/Module/Search.php
@@ -175,7 +175,7 @@ class Search extends \Zotlabs\Web\Controller {
OR ( item.uid = %d )) OR item.owner_xchan = '%s' )
$item_normal
$sql_extra
- group by mid order by created desc $pager_sql ",
+ group by mid, created order by created desc $pager_sql ",
intval(local_channel()),
dbesc($sys['xchan_hash'])
);
@@ -188,7 +188,7 @@ class Search extends \Zotlabs\Web\Controller {
$pub_sql ) OR owner_xchan = '%s')
$item_normal
$sql_extra
- group by mid order by created desc $pager_sql",
+ group by mid, created order by created desc $pager_sql",
dbesc($sys['xchan_hash'])
);
}