I am trying to setup a view, starting from a clone of the default all_activity view provided by 2.x-dev, that would list activity by friends of the user on his profile page.
I get this:
-----------------------
* user warning: Unknown column 'users.uid' in 'IN/ALL/ANY subquery' query: SELECT COUNT(*) FROM (SELECT activity.aid AS aid FROM activity activity LEFT JOIN node node_activity ON activity.nid = node_activity.nid LEFT JOIN users users_activity ON activity.uid = users_activity.uid LEFT JOIN flag_friend users_activity__flag_friend ON users_activity.uid = users_activity__flag_friend.uid INNER JOIN activity_targets activity_targets ON activity.aid = activity_targets.aid AND (activity_targets.uid = 0 AND activity_targets.language = 'es') INNER JOIN activity_messages activity_messages ON activity_targets.amid = activity_messages.amid LEFT JOIN activity_targets activity_personal_targets ON activity.aid = activity_personal_targets.aid AND (activity_personal_targets.uid = 1 AND activity_personal_targets.language = 'es') LEFT JOIN activity_messages activity_personal_messages ON activity_personal_targets.amid = activity_personal_messages.amid WHERE (users.uid IN (SELECT f.friend_uid FROM flag_friend f WHERE f.uid = 1)) OR (users.uid IN (SELECT f.uid FROM flag_friend f WHERE f.friend_uid = 1)) ) count_alias in /home/manuel/htdocs/raimundo/sites/all/modules/views/includes/view.inc on line 739.
* user warning: Unknown column 'users.uid' in 'IN/ALL/ANY subquery' query: SELECT activity.aid AS aid, COALESCE(activity_personal_messages.message, activity_messages.message) AS activity_messages_message, activity.aid AS activity_aid FROM activity activity LEFT JOIN node node_activity ON activity.nid = node_activity.nid LEFT JOIN users users_activity ON activity.uid = users_activity.uid LEFT JOIN flag_friend users_activity__flag_friend ON users_activity.uid = users_activity__flag_friend.uid INNER JOIN activity_targets activity_targets ON activity.aid = activity_targets.aid AND (activity_targets.uid = 0 AND activity_targets.language = 'es') INNER JOIN activity_messages activity_messages ON activity_targets.amid = activity_messages.amid LEFT JOIN activity_targets activity_personal_targets ON activity.aid = activity_personal_targets.aid AND (activity_personal_targets.uid = 1 AND activity_personal_targets.language = 'es') LEFT JOIN activity_messages activity_personal_messages ON activity_personal_targets.amid = activity_personal_messages.amid WHERE (users.uid IN (SELECT f.friend_uid FROM flag_friend f WHERE f.uid = 1)) OR (users.uid IN (SELECT f.uid FROM flag_friend f WHERE f.friend_uid = 1)) ORDER BY activity_aid DESC LIMIT 0, 25 in /home/manuel/htdocs/raimundo/sites/all/modules/views/includes/view.inc on line 765.
-----------------------
Here is the query the view is trying to run:
SELECT activity.aid AS aid,
COALESCE(activity_personal_messages.message, activity_messages.message) AS activity_messages_message,
activity.aid AS activity_aid
FROM activity activity
LEFT JOIN node node_activity ON activity.nid = node_activity.nid
LEFT JOIN users users_activity ON activity.uid = users_activity.uid
LEFT JOIN flag_friend users_activity__flag_friend ON users_activity.uid = users_activity__flag_friend.uid
INNER JOIN activity_targets activity_targets ON activity.aid = activity_targets.aid AND (activity_targets.uid = 0 AND activity_targets.language = '***ACTIVITY_LANGUAGE***')
INNER JOIN activity_messages activity_messages ON activity_targets.amid = activity_messages.amid
LEFT JOIN activity_targets activity_personal_targets ON activity.aid = activity_personal_targets.aid AND (activity_personal_targets.uid = ***CURRENT_USER*** AND activity_personal_targets.language = '***ACTIVITY_LANGUAGE***')
LEFT JOIN activity_messages activity_personal_messages ON activity_personal_targets.amid = activity_personal_messages.amid
WHERE (users.uid IN (SELECT f.friend_uid FROM flag_friend f WHERE f.uid = 1)) OR (users.uid IN (SELECT f.uid FROM flag_friend f WHERE f.friend_uid = 1))
ORDER BY activity_aid DESC
The only thing I am adding is the argument "Flag friend: Friends of", which apparently grabs the user relationship by default. AFIK this is the way to setup a view filtering the friends of the uid provided as argument.
Am I doing something wrong, is this a known issue? Anyone else seeing this?
Comments
Comment #1
manuel garcia commentedNevermind, I had not checked Flag_friend: Friend in Activity Access Control, which is necessary for this filter to work properly it seems.
Comment #2
Scott Reynolds commentedyep and Flag Friend Friends of argument is a bit broken #592622: Duplicate friend listing in Views2
Comment #3
manuel garcia commentedwoa, thanks for the heads up!