From 1e4490079b5257a8a90064eb986e16825391421d Mon Sep 17 00:00:00 2001 From: friendica Date: Sat, 28 Mar 2015 18:45:58 -0700 Subject: issue #938 --- include/items.php | 10 ++++++++-- 1 file changed, 8 insertions(+), 2 deletions(-) (limited to 'include/items.php') diff --git a/include/items.php b/include/items.php index a8947202d..4246dd41f 100755 --- a/include/items.php +++ b/include/items.php @@ -4383,13 +4383,19 @@ function zot_feed($uid,$observer_xchan,$arr) { $items = array(); + // FIXME + + if(ACTIVE_DBTYPE == DBTYPE_POSTGRES) { + return array(); + } + if(is_sys_channel($uid)) { require_once('include/security.php'); $r = q("SELECT parent, created from item WHERE uid != %d AND item_private = 0 AND item_restrict = 0 AND uid in (" . stream_perms_api_uids(PERMS_PUBLIC,10,1) . ") AND (item_flags & %d) > 0 - $sql_extra GROUP BY parent ORDER BY created ASC $limit", + $sql_extra GROUP BY parent, created ORDER BY created ASC $limit", intval($uid), intval(ITEM_WALL) ); @@ -4398,7 +4404,7 @@ function zot_feed($uid,$observer_xchan,$arr) { $r = q("SELECT parent, created from item WHERE uid = %d AND item_restrict = 0 AND (item_flags & %d) > 0 - $sql_extra GROUP BY parent ORDER BY created ASC $limit", + $sql_extra GROUP BY parent, created ORDER BY created ASC $limit", intval($uid), intval(ITEM_WALL) ); -- cgit v1.2.3