[SOLVED] CB Group Jive

Hi Guys

Just upgraded to the new CB group Jive 3.0.0-RC1 release and everything seems to be working great, except for CB activity - I get a SQL error when I try to access the site activity. I've pasted the error beneath: -

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 21 SQL=SELECT COUNT( a.`id` ) FROM `een_comprofiler_plugin_activity` AS a LEFT JOIN `een_comprofiler_plugin_activity_hidden` AS b ON b.`type` = 'activity' AND b.`item` = a.`id` AND b.`user_id` = 849 LEFT JOIN `een_comprofiler` AS c ON c.`id` = a.`user_id` LEFT JOIN `een_users` AS d ON d.`id` = c.`id` LEFT JOIN `een_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 `een_comprofiler_plugin_activity_hidden` WHERE `type` = 'activity' AND `item` = f.`id` AND `user_id` = 849) AND f.`date` > a.`date` LEFT JOIN `een_groupjive_plugin_events` AS gj_e ON a.`type` = 'groupjive' AND a.`subtype` = 'group.event' AND a.`item` = gj_e.`id` LEFT JOIN `een_groupjive_plugin_file` AS gj_f ON a.`type` = 'groupjive' AND a.`subtype` = 'group.file' AND a.`item` = gj_f.`id` LEFT JOIN `een_groupjive_plugin_photo` AS gj_p ON a.`type` = 'groupjive' AND a.`subtype` = 'group.photo' AND a.`item` = gj_p.`id` LEFT JOIN `een_groupjive_plugin_video` AS gj_v ON a.`type` = 'groupjive' AND a.`subtype` = 'group.video' AND a.`item` = gj_v.`id` LEFT JOIN `een_groupjive_plugin_wall` AS gj_w ON a.`type` = 'groupjive' AND a.`subtype` = 'group.wall' AND a.`item` = gj_w.`id` LEFT JOIN `een_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` ) ) LEFT JOIN `een_groupjive_categories` AS gj_c ON gj_c.`id` = gj_g.`category` LEFT JOIN `een_groupjive_users` AS gj_u ON gj_u.`user_id` = 849 AND gj_u.`group` = gj_g.`id` LEFT JOIN `een_groupjive_invites` AS gj_i ON gj_i.`group` = gj_g.`id` AND gj_i.`accepted` = '0000-00-00 00:00:00' AND ( ( gj_i.`email` = '**chopped**' AND gj_i.`email` != "" ) OR ( gj_i.`user` = 849 AND gj_i.`user` > 0 ) ) WHERE b.`id` IS NULL AND f.`id` IS NULL AND c.`approved` = 1 AND c.`confirmed` = 1 AND d.`block` = 0 AND

Are there any config changes I need to make CB Activity in order to get it working correctly?

delhi-expat wrote:
Are there any config changes I need to make CB Activity in order to get it working correctly?

Please download latest CB Activity nightly and CB Auto Actions nightly and try again.

Relevant links foe these downloads can be found here:
www.joomlapolis.com/cb-20-addon-status

nant wrote:

delhi-expat wrote:
Are there any config changes I need to make CB Activity in order to get it working correctly?

Please download latest CB Activity nightly and CB Auto Actions nightly and try again.

Relevant links foe these downloads can be found here:
www.joomlapolis.com/cb-20-addon-status

That did it - thanks!