I'm getting this error message when clicking in the user profile menu:
Error: 1064 - 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 '' at line 20 SQL=SELECT COUNT( a.`id` ) FROM `bda_comprofiler_plugin_activity` AS a LEFT JOIN `bda_comprofiler_plugin_activity_hidden` AS b ON b.`type` = 'activity' AND b.`item` = a.`id` AND b.`user_id` = 1146 LEFT JOIN `bda_comprofiler` AS c ON c.`id` = a.`user_id` LEFT JOIN `bda_users` AS d ON d.`id` = c.`id` LEFT JOIN `bda_comprofiler_members` AS e ON e.`pending` = 0 AND e.`accepted` = 1 AND e.`memberid` = a.`user_id` AND e.`referenceid` = 1146 LEFT JOIN `bda_comprofiler_plugin_activity` AS f ON ( ( f.`type` = 'activity' AND f.`item` = a.`id` ) OR ( f.`type` = 'activity' AND a.`type` = 'activity' AND f.`item` = a.`item` ) ) AND f.`id` NOT IN (SELECT `item` FROM `bda_comprofiler_plugin_activity_hidden` WHERE `type` = 'activity' AND `item` = f.`id` AND `user_id` = 1146) AND ( f.`user_id` = 1146 OR e.`memberid` IS NOT NULL ) AND f.`date` > a.`date` LEFT JOIN `bda_groupjive_plugin_wall` AS gj_w ON a.`type` = 'groupjive' AND a.`subtype` = 'group.wall' AND a.`item` = gj_w.`id` LEFT JOIN `bda_groupjive_plugin_photo` AS gj_p ON a.`type` = 'groupjive' AND a.`subtype` = 'group.photo' AND a.`item` = gj_p.`id` LEFT JOIN `bda_groupjive_plugin_video` AS gj_v ON a.`type` = 'groupjive' AND a.`subtype` = 'group.video' AND a.`item` = gj_v.`id` LEFT JOIN `bda_groupjive_plugin_file` AS gj_f ON a.`type` = 'groupjive' AND a.`subtype` = 'group.file' AND a.`item` = gj_f.`id` LEFT JOIN `bda_groupjive_plugin_events` AS gj_e ON a.`type` = 'groupjive' AND a.`subtype` = 'group.event' AND a.`item` = gj_e.`id` LEFT JOIN `bda_groupjive_groups` AS gj_g ON a.`type` = 'groupjive' AND ( ( a.`subtype` = 'group' AND a.`item` = gj_g.`id` ) OR ( a.`subtype` != 'group' AND a.`parent` = gj_g.`id` ) ) WHERE b.`id` IS NULL AND f.`id` IS NULL AND c.`approved` = 1 AND c.`confirmed` = 1 AND d.`block` = 0 AND ( a.`user_id` = 1146 OR e.`memberid` IS NOT NULL ) AND
had the same issue myself. This fixed it and many others too.