When a user tries to access their profile from the front end, they get the following message:-

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 20 SQL=SELECT COUNT( a.`id` ) FROM `#__comprofiler_plugin_activity` AS a LEFT JOIN `#__comprofiler_plugin_activity_hidden` AS b ON b.`type` = 'activity' AND b.`item` = a.`id` AND b.`user_id` = 429 LEFT JOIN `#__comprofiler` AS c ON c.`id` = a.`user_id` LEFT JOIN `#__users` AS d ON d.`id` = c.`id` LEFT JOIN `#__comprofiler_members` AS e ON e.`pending` = 0 AND e.`accepted` = 1 AND e.`memberid` = a.`user_id` AND e.`referenceid` = 429 LEFT JOIN `#__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 `#__comprofiler_plugin_activity_hidden` WHERE `type` = 'activity' AND `item` = f.`id` AND `user_id` = 429) AND ( f.`user_id` = 429 OR e.`memberid` IS NOT NULL ) AND f.`date` > a.`date` LEFT JOIN `#__groupjive_plugin_wall` AS gj_w ON a.`type` = 'groupjive' AND a.`subtype` = 'group.wall' AND a.`item` = gj_w.`id` LEFT JOIN `#__groupjive_plugin_video` AS gj_v ON a.`type` = 'groupjive' AND a.`subtype` = 'group.video' AND a.`item` = gj_v.`id` LEFT JOIN `#__groupjive_plugin_photo` AS gj_p ON a.`type` = 'groupjive' AND a.`subtype` = 'group.photo' AND a.`item` = gj_p.`id` LEFT JOIN `#__groupjive_plugin_file` AS gj_f ON a.`type` = 'groupjive' AND a.`subtype` = 'group.file' AND a.`item` = gj_f.`id` LEFT JOIN `#__groupjive_plugin_events` AS gj_e ON a.`type` = 'groupjive' AND a.`subtype` = 'group.event' AND a.`item` = gj_e.`id` LEFT JOIN `#__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` = 429 OR e.`memberid` IS NOT NULL ) AND

Any Idea?

Please can I make a suggestion and it would really help. I love your plug-in system and its really good, but could it tell us when a new version is available when you are looking through them, even click a sort at the top to filter out all the bits that need updating, this will prevent issues like that and be so much more user friendly. There could even be a link to the update