[SOLVED] GroupJive 3.0.0 SQL error after upgrade

Hi,

I've upgraded GroupJive 2.7 on a CB 2.0.12 installation to GroupJive 3.0.0 but I get a SQL error when viewing my profile (e-mail address removed):

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 19 SQL=SELECT COUNT( a.`id` ) FROM `abc_comprofiler_plugin_activity` AS a LEFT JOIN `abc_comprofiler_plugin_activity_hidden` AS b ON b.`type` = 'activity' AND b.`item` = a.`id` AND b.`user_id` = 123 LEFT JOIN `abc_comprofiler` AS c ON c.`id` = a.`user_id` LEFT JOIN `abc_users` AS d ON d.`id` = c.`id` LEFT JOIN `abc_comprofiler_members` AS e ON e.`pending` = 0 AND e.`accepted` = 1 AND e.`memberid` = a.`user_id` AND e.`referenceid` = 123 LEFT JOIN `abc_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 `abc_comprofiler_plugin_activity_hidden` WHERE `type` = 'activity' AND `item` = f.`id` AND `user_id` = 123) AND ( f.`user_id` = 123 OR e.`memberid` IS NOT NULL ) AND f.`date` > a.`date` LEFT JOIN `abc_groupjive_plugin_wall` AS gj_w ON a.`type` = 'groupjive' AND a.`subtype` = 'group.wall' AND a.`item` = gj_w.`id` LEFT JOIN `abc_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 `abc_groupjive_categories` AS gj_c ON gj_c.`id` = gj_g.`category` LEFT JOIN `abc_groupjive_users` AS gj_u ON gj_u.`user_id` = 123 AND gj_u.`group` = gj_g.`id` LEFT JOIN `abc_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` = '***' AND gj_i.`email` != "" ) OR ( gj_i.`user` = 123 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 ( a.`user_id` = 123 OR e.`memberid` IS NOT NULL ) AND


Installing the nightly build of GJ didn't solve the problem. I removed GJ 3.0 and installed GJ 2.7 again to get back to normal.

Any ideas?

thomasmes wrote: Hi,

I've upgraded GroupJive 2.7 on a CB 2.0.12 installation to GroupJive 3.0.0 but I get a SQL error when viewing my profile (e-mail address removed):

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 19 SQL=SELECT COUNT( a.`id` ) FROM `abc_comprofiler_plugin_activity` AS a LEFT JOIN `abc_comprofiler_plugin_activity_hidden` AS b ON b.`type` = 'activity' AND b.`item` = a.`id` AND b.`user_id` = 123 LEFT JOIN `abc_comprofiler` AS c ON c.`id` = a.`user_id` LEFT JOIN `abc_users` AS d ON d.`id` = c.`id` LEFT JOIN `abc_comprofiler_members` AS e ON e.`pending` = 0 AND e.`accepted` = 1 AND e.`memberid` = a.`user_id` AND e.`referenceid` = 123 LEFT JOIN `abc_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 `abc_comprofiler_plugin_activity_hidden` WHERE `type` = 'activity' AND `item` = f.`id` AND `user_id` = 123) AND ( f.`user_id` = 123 OR e.`memberid` IS NOT NULL ) AND f.`date` > a.`date` LEFT JOIN `abc_groupjive_plugin_wall` AS gj_w ON a.`type` = 'groupjive' AND a.`subtype` = 'group.wall' AND a.`item` = gj_w.`id` LEFT JOIN `abc_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 `abc_groupjive_categories` AS gj_c ON gj_c.`id` = gj_g.`category` LEFT JOIN `abc_groupjive_users` AS gj_u ON gj_u.`user_id` = 123 AND gj_u.`group` = gj_g.`id` LEFT JOIN `abc_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` = '***' AND gj_i.`email` != "" ) OR ( gj_i.`user` = 123 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 ( a.`user_id` = 123 OR e.`memberid` IS NOT NULL ) AND


Installing the nightly build of GJ didn't solve the problem. I removed GJ 3.0 and installed GJ 2.7 again to get back to normal.

Any ideas?

Upgrade to latest CB Activity and CB Auto Action nightly builds and then upgrade to GJ 3.0.

Thanks. This worked.

thomasmes wrote: Thanks. This worked.

Great!

Marking as solved.
If you have any other issue please start new thread.