www.dlpinfo.net/jomsocial/572sprookjesprins6/profile.html
ISSUE SUMMARY:


STEPS TO REPLICATE:
1
2
3
4
5
RESULT
EXPECTED RESULT
BROWSER

Undeclared variable: disney SQL=SELECT DISTINCT a.* FROM `rjznc11_community_events` AS a LEFT JOIN `rjznc11_community_events_members` AS b ON a.`id`=b.`eventid` LEFT JOIN `rjznc11_community_groups` AS g ON g.`id` = a.`contentid`WHERE a.`published`='1' AND b.`memberid`='572' AND b.`status`='1' AND a.`unlisted` = '0' AND(a.`permission` = '0' OR(a.`permission` = '1' AND(SELECT COUNT(`eventid`) FROM `rjznc11_community_events_members` as b WHERE b.`memberid`='0' and b.`eventid`=a.`id`) > 0 ) ) AND (g.`approvals` = '0' OR g.`approvals` IS NULL OR (g.`approvals`='1' AND (SELECT COUNT(`groupid`) FROM `rjznc11_community_groups_members` as t WHERE t.`memberid`='0' AND t.`approved`='1' and t.`groupid`=g.`id`) > 0) OR b.`memberid`='572') AND a.`enddate` >= '2015-10-22 11:15:38' AND ((a.`parent`='0' && (a.`repeat`='' || a.`repeat` IS NULL)) || (a.`parent`!= 0 && a.`repeat` IS NOT NULL)) ORDER BY a.`created` DESC LIMIT 0, disney pin

HI.

I assign developer to this thread.

EDIT.

This issue was caused by your member. He enabled JS My Events application on his profile... and provided "disney pin" in Count field... where he should provide number of displayed events...
He probably misunderstood what "Count" means...
I fixed it in your database.