aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorzotlabs <mike@macgirvin.com>2018-05-07 19:33:58 -0700
committerMario Vavti <mario@mariovavti.com>2018-05-08 11:48:26 +0200
commit6ad4ed87a313901dd40fb1f8370c5bfdc7acddc8 (patch)
treed8785cf66427c193f4fde8ec6ac496b3cdf59a66
parentbe4c9a9598350fb4333480f0c7b302acebcddfd4 (diff)
downloadvolse-hubzilla-6ad4ed87a313901dd40fb1f8370c5bfdc7acddc8.tar.gz
volse-hubzilla-6ad4ed87a313901dd40fb1f8370c5bfdc7acddc8.tar.bz2
volse-hubzilla-6ad4ed87a313901dd40fb1f8370c5bfdc7acddc8.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'])
);
}