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
krileon
