ISSUE SUMMARY:


STEPS TO REPLICATE:
1Log into tahoerimtrail.org/j25. Click 'Trail Challenge Login' at upper right
2Log into jomsocial - userid is webmaster 'at' mccall.warpmail.net
, pw is woof
3Search for 'mccall', select the John McCall entry with a number of friends - click to display
4
5
RESULT error message
Error: 500 - DB function failed with error number 1054
Unknown column 'a.unlisted' in 'where clause' SQL=SELECT DISTINCT a.* FROM `jml_community_events` AS a LEFT JOIN `jml_community_events_members` AS b ON a.`id`=b.`eventid` LEFT JOIN `jml_community_groups` AS g ON g.`id` = a.`contentid`WHERE a.`published`='1' AND b.`memberid`='2525' AND b.`status`='1' AND(a.`unlisted` = '0' OR(a.`unlisted` = '1' AND(SELECT COUNT(`eventid`) FROM `jml_community_events_members` as b WHERE b.`memberid`='2516' and b.`eventid`=a.`id`) > 0 ) ) AND (g.`approvals` = '0' OR g.`approvals` IS NULL OR b.`memberid`='2525') AND a.`enddate` >= '2015-06-17 07:58:12' 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, 5
You may not be able to visit this page because of:
1. an out-of-date bookmark/favourite
2. a search engine that has an out-of-date listing for this site
3. a mistyped address
4. you have no access to this page
5. The requested resource was not found.
6. An error has occurred while processing your request.

EXPECTED RESULT Display of user. NOTE - other JS members do display without error. For non-friends, get the denial message as expected. This particular user (John McCall) is a Super User but other Super Users display properly
BROWSER Chrome

Hi John,

seem that missing field at events table. here the fix:
1. login to your hosting cpanel
2. open database manager/phpmyadmin
3. and execute this query

ALTER TABLE `#_community_events` ADD `unlisted` TINYINT(1) NOT NULL ;