I've just installed groupjive and I'm getting the following error when i go to access my profile. any ideas?
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 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` = 42 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` = 42 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` = 42) AND ( F.`USER_ID` = 42 OR E.`MEMBERID` IS NOT NULL ) AND F.`DATE` > A.`DATE` 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_PLUGIN_FILE` AS GJ_F ON A.`TYPE` = 'GROUPJIVE' AND A.`SUBTYPE` = 'GROUP.FILE' AND A.`ITEM` = GJ_F.`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_VIDEO` AS GJ_V ON A.`TYPE` = 'GROUPJIVE' AND A.`SUBTYPE` = 'GROUP.VIDEO' AND A.`ITEM` = GJ_V.`ID` 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_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` = 42 OR E.`MEMBERID` IS NOT NULL ) AND
Update CB Activity. Older release has an API bug that causes that.
Kyle (Krileon) Community Builder Team Member Before posting on forums:
Read FAQ thoroughly
+
Read our Documentation
+
Search the forums CB links:
Documentation
-
Localization
-
CB Quickstart
-
CB Paid Subscriptions
-
Add-Ons
-
Forge
-- If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
-- If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please
send me a private message
with your thread and will reply when possible!
-- Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
-- My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
krileon
