From 6ad4ed87a313901dd40fb1f8370c5bfdc7acddc8 Mon Sep 17 00:00:00 2001 From: zotlabs Date: Mon, 7 May 2018 19:33:58 -0700 Subject: yet another postgres/"group by" issue --- Zotlabs/Module/Search.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'Zotlabs/Module') 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']) ); } -- cgit v1.2.3