From 00b3c4c881290427189185cdf4a247285aa79e5b Mon Sep 17 00:00:00 2001 From: friendica Date: Tue, 24 Mar 2015 12:40:55 -0700 Subject: sql errors on postgres with yestderday's optimisation --- include/items.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'include') diff --git a/include/items.php b/include/items.php index 32e5dcbe5..d1998bd0a 100755 --- a/include/items.php +++ b/include/items.php @@ -4381,7 +4381,7 @@ function zot_feed($uid,$observer_xchan,$arr) { if(is_sys_channel($uid)) { require_once('include/security.php'); - $r = q("SELECT parent from item + $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 @@ -4391,7 +4391,7 @@ function zot_feed($uid,$observer_xchan,$arr) { ); } else { - $r = q("SELECT parent from item + $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", -- cgit v1.2.3