db_rewrite_sql causing errors with DISTINCT - workaround

Created on 5 May 2009, over 16 years ago
Updated 29 October 2025, 6 days ago

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?

📌 Task
Status

Closed: outdated

Version

2.0

Component

Miscellaneous

Created by

🇷🇺Russia mrjavum

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

No activities found.

Production build 0.71.5 2024