I tried to add filter
Activity Access: flag_friend Access
Specific Relationships: Friend
to default activity view and got an error:
user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND ((activity_access.realm = 'flag_friend' AND activity_access.value IN ' at line 10 query: SELECT COUNT(*) FROM (SELECT DISTINCT(activity.aid) AS aid, COALESCE(activity_personal_messages.message, activity_messages.message) AS activity_messages_message, activity.created AS activity_created FROM activity activity INNER JOIN activity_access activity_access ON activity.aid = activity_access.aid INNER JOIN activity_targets activity_targets ON activity.aid = activity_targets.aid AND activity_targets.uid = 0 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 LEFT JOIN activity_messages activity_personal_messages ON activity_personal_targets.amid = activity_personal_messages.amid WHERE () AND ((activity_access.realm = 'flag_friend' AND activity_access.value IN (3))) ORDER BY activity_created DESC ) count_alias in Y:\home\jjj\www\sites\all\modules\views\includes\view.inc on line 705.
user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND ((activity_access.realm = 'flag_friend' AND activity_access.value IN ' at line 10 query: SELECT DISTINCT(activity.aid) AS aid, COALESCE(activity_personal_messages.message, activity_messages.message) AS activity_messages_message, activity.created AS activity_created FROM activity activity INNER JOIN activity_access activity_access ON activity.aid = activity_access.aid INNER JOIN activity_targets activity_targets ON activity.aid = activity_targets.aid AND activity_targets.uid = 0 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 LEFT JOIN activity_messages activity_personal_messages ON activity_personal_targets.amid = activity_personal_messages.amid WHERE () AND ((activity_access.realm = 'flag_friend' AND activity_access.value IN (3))) ORDER BY activity_created DESC LIMIT 0, 25 in Y:\home\jjj\www\sites\all\modules\views\includes\view.inc on line 731.
and view displays nothing.
What is my mistake?
Closed: outdated
2.0
Miscellaneous
Not all content is available!
It's likely this issue predates Contrib.social: some issue and comment data are missing.
No activities found.