diff options
| author | zotlabs <mike@macgirvin.com> | 2018-05-07 19:33:58 -0700 |
|---|---|---|
| committer | Mario Vavti <mario@mariovavti.com> | 2018-05-08 11:48:26 +0200 |
| commit | 6ad4ed87a313901dd40fb1f8370c5bfdc7acddc8 (patch) | |
| tree | d8785cf66427c193f4fde8ec6ac496b3cdf59a66 | |
| parent | be4c9a9598350fb4333480f0c7b302acebcddfd4 (diff) | |
| download | volse-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.php | 4 |
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']) ); } |