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.
Please update to latest nightly releases for CB Auto Actions and CB Activities and then install latest CB GroupJive nightly.
All items can be found as links here:
www.joomlapolis.com/cb-20-addon-status
nant