crealiagroup wrote: Hi, after upgraded to GJ 3.0 I got this error in the pages where the CB Activity module is published:

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 17 SQL=SELECT COUNT( a.`id` ) FROM `myprefix_comprofiler_plugin_activity` AS a LEFT JOIN `myprefix_comprofiler_plugin_activity_hidden` AS b ON b.`type` = 'activity' AND b.`item` = a.`id` AND b.`user_id` = 42818 LEFT JOIN `myprefix_comprofiler` AS c ON c.`id` = a.`user_id` LEFT JOIN `myprefix_users` AS d ON d.`id` = c.`id` LEFT JOIN `myprefix_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 `myprefix_comprofiler_plugin_activity_hidden` WHERE `type` = 'activity' AND `item` = f.`id` AND `user_id` = 42818) AND f.`date` > a.`date` LEFT JOIN `myprefix_groupjive_plugin_events` AS gj_e ON a.`type` = 'groupjive' AND a.`subtype` = 'group.event' AND a.`item` = gj_e.`id` LEFT JOIN `myprefix_groupjive_plugin_photo` AS gj_p ON a.`type` = 'groupjive' AND a.`subtype` = 'group.photo' AND a.`item` = gj_p.`id` LEFT JOIN `myprefix_groupjive_plugin_video` AS gj_v ON a.`type` = 'groupjive' AND a.`subtype` = 'group.video' AND a.`item` = gj_v.`id` LEFT JOIN `myprefix_groupjive_plugin_wall` AS gj_w ON a.`type` = 'groupjive' AND a.`subtype` = 'group.wall' AND a.`item` = gj_w.`id` LEFT JOIN `myprefix_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
It appears the page you were looking for doesn't exist. Sorry about that.

If I disable the module everything works.
I've tryed to recreate the module but no way, still same error.

crealiagroup wrote: Thanks Nant, that solved the issue.