ISSUE SUMMARY:
I have a web site with jomsocial installed, multi profile feature is active. Two kind of profiles are there 1- Traveller, 2- Business.

I want to search user of particular profile type.
for this i am using advanced search, in that two options are given 1- Match all criteria and 2- Match any criteria.

On adv search page if i leave every thing blank and choose 2nd option(Match any criteria.) then click search jomsocial search throws and error below:
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 'AND a.`id` NOT IN('201','540','981')' at line 1 SQL=CREATE TEMPORARY TABLE tmpadv ( SELECT DISTINCT( b.`userid` ) as `user_id`, a.`username` AS `username`, a.`name` AS `name`, a.`registerDate` AS `registerDate`, CASE WHEN s.`userid` IS NULL THEN 0 ELSE 1 END AS online FROM `el4us_users` AS a LEFT JOIN `el4us_session` AS s ON a.`id`=s.`userid` INNER JOIN `el4us_community_users` AS b ON a.`id` = b.`userid` AND a.`block` = '0' WHERE a.`name` LIKE '%%' ) AND a.`id` NOT IN('201','540','981') "

i am unable to solve it, please help me.

STEPS TO REPLICATE:
1 After reaching www.globejugglers.com/ click on CONNECT at top right corner. it will take you to login page, login here using given admin details in site info section.
2 After login you will reach profile page here you can find "Search for Influencers" on jomsocial toolbar click it.
3 It will take you to adv search here you have to leave all fields empty and choose "Match any criteria" then click on search button.
4 It will show and error.

Hi,

please try this fix:
www.jomsocial.com/forum/profile-universa...rch-members-profiles

please backup the file before replacing it with new one.

FYI:
your jomsocial still using old version 4.1.5, it would be great if you using latest version 4.2.4

Regards

Hello,

Albertus thanks for reply.

I took backup of file and placed the zip file suggested in given article, and it solved my problem.

Thanks once again.