diff options
| author | zotlabs <mike@macgirvin.com> | 2018-05-07 19:33:58 -0700 |
|---|---|---|
| committer | zotlabs <mike@macgirvin.com> | 2018-05-07 19:33:58 -0700 |
| commit | 0c43a9bb5dae1ab6c1646c690f0e9b765e88832e (patch) | |
| tree | ca615dce939f9ceed9f31d4ddc6b35f1589f028d | |
| parent | eb85d381fdb447d23e568dfecbde24a860879952 (diff) | |
| download | volse-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.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']) ); } |