aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorMario Vavti <mario@mariovavti.com>2018-07-04 10:55:38 +0200
committerMario Vavti <mario@mariovavti.com>2018-07-04 10:55:38 +0200
commitd9ece80fda867768fb3b8de47bf4eb7c3e6108e8 (patch)
treedb212eaf07ee258892ae9a92cf3d2da5f3ac811d
parentb88a9c2627e632d0f963e0078191eb616e5a1668 (diff)
downloadvolse-hubzilla-d9ece80fda867768fb3b8de47bf4eb7c3e6108e8.tar.gz
volse-hubzilla-d9ece80fda867768fb3b8de47bf4eb7c3e6108e8.tar.bz2
volse-hubzilla-d9ece80fda867768fb3b8de47bf4eb7c3e6108e8.zip
order nouveau by created instead of received since ordering by received returns unexpected results once old expired items get re-imported
-rw-r--r--Zotlabs/Module/Network.php4
1 files changed, 2 insertions, 2 deletions
diff --git a/Zotlabs/Module/Network.php b/Zotlabs/Module/Network.php
index 172157aab..77a08585b 100644
--- a/Zotlabs/Module/Network.php
+++ b/Zotlabs/Module/Network.php
@@ -480,7 +480,7 @@ class Network extends \Zotlabs\Web\Controller {
if($nouveau && $load) {
// "New Item View" - show all items unthreaded in reverse created date order
- $items = q("SELECT item.*, item.id AS item_id, received FROM item
+ $items = q("SELECT item.*, item.id AS item_id, created FROM item
left join abook on ( item.owner_xchan = abook.abook_xchan $abook_uids )
$net_query
WHERE true $uids $item_normal
@@ -488,7 +488,7 @@ class Network extends \Zotlabs\Web\Controller {
$simple_update
$sql_extra $sql_options $sql_nets
$net_query2
- ORDER BY item.received DESC $pager_sql "
+ ORDER BY item.created DESC $pager_sql "
);
require_once('include/items.php');