Welcome the Technical Support section. Help us in assisting you by providing us with a concise and descriptive elaboration of your issues. Be specific and if possible, provide us with a step-by-step instruction in replicating your problem.
I have found bad links going through my Jom Social install and I think I know what caused it but how to correct the problem. When I download the install i entered www and just as I hit download noticed in red do not use http or www. Now when logged into Jom Social and click on profile I will get a full page of SQL errors 1327. Any help here would be huge . if i remove the www from the bad link the page shows again
327
UNDECLARED VARIABLE: EVENTS SQL=SELECT DISTINCT A.* FROM `HKJAR_COMMUNITY_EVENTS` AS A LEFT JOIN `HKJAR_COMMUNITY_EVENTS_MEMBERS` AS B ON A.`ID`=B.`EVENTID` LEFT JOIN `HKJAR_COMMUNITY_GROUPS` AS G ON G.`ID` = A.`CONTENTID`WHERE A.`PUBLISHED`='1' AND B.`MEMBERID`='674'AND B.`STATUS`<'2' AND (G.`APPROVALS` = '0' OR G.`APPROVALS` IS NULL OR B.`MEMBERID`='674') AND A.`ENDDATE` >= '2015-01-29 01:34:14' AND ((A.`PARENT`='0' && (A.`REPEAT`='' || A.`REPEAT` IS NULL)) || (A.`PARENT`!= 0 && A.`REPEAT` IS NOT NULL)) ORDER BY A.`STARTDATE` ASC LIMIT 0, EVENTS