ISSUE SUMMARY:
We getting earch on search component after logged-in > component> search
and search not performaing for front end also . try this keyword : NALANDDA
giving 0 result forund but the link is there : fashionablyin.com/NALANDDA .
Even you select "Exact Phrase" from frontend in search giving this same error :

An error has occurred.
1054 Unknown column 'a.caption' in 'order clause' SQL=SELECT a.id AS id, a.name AS title, a.description AS description, 'Albums' AS section, "2" AS browsernav,a.created AS created, a.creator AS creator, a.groupid AS groupid,a.type AS type,p.thumbnail AS thumb, p.storage AS storage,u.name AS user, u.username AS username FROM `#__community_photos_albums` AS a LEFT JOIN `#__community_photos` AS p ON a.photoid=p.id INNER JOIN `#__users` AS u ON a.creator=u.id INNER JOIN `#__community_users` AS cu ON a.creator=cu.userid WHERE (a.name LIKE '%nalandda%') AND a.type IN ('group','user') GROUP BY id, title, description, section, browsernav, created, creator, groupid, type, thumb, storage, user, username ORDER BY a.caption ASC LIMIT 50

STEPS TO REPLICATE:
1 For backend : login to administrator > component > search
2 For frontend : Search from sidebar - keyword : NALANDDA
3 no result found and also select "Exact Phrase" and then search again giving the error
4
5
RESULT :
1054 Unknown column 'a.caption' in 'order clause' SQL=SELECT a.id AS id, a.name AS title, a.description AS description, 'Albums' AS section, "2" AS browsernav,a.created AS created, a.creator AS creator, a.groupid AS groupid,a.type AS type,p.thumbnail AS thumb, p.storage AS storage,u.name AS user, u.username AS username FROM `#__community_photos_albums` AS a LEFT JOIN `#__community_photos` AS p ON a.photoid=p.id INNER JOIN `#__users` AS u ON a.creator=u.id INNER JOIN `#__community_users` AS cu ON a.creator=cu.userid WHERE (a.name LIKE '%nalandda%') AND a.type IN ('group','user') GROUP BY id, title, description, section, browsernav, created, creator, groupid, type, thumb, storage, user, username ORDER BY a.caption ASC LIMIT 50

HI, Tarun.

Thank you for contacting us.
I'm sorry to hear you have issues with JomSocial.
It seems that your database lack certain record.
Please, try to reinstall JomSocial - make safe backup first, then download latest version from here: www.jomsocial.com/component/digistore/licenses and install it on top of your existing version.

Hi we tried the solution you suggested and re-installed again but still the search is not working , and the installation process keep getting in loop when we click on jomsocial under component (Admin dashboard)

HI, Tarun.

I reinstalled JomSocial on your site and tested simple and advanced search: snag.gy/uDOXip.jpg
It seems to work as it should now.
Please, test it yourself.

Thanks for your support, as we can see its working but still getting this error when selecting the Exact Phrase option for search :

1054
Unknown column 'test' in 'where clause' SQL=SELECT a.id AS id, a.title AS title, a.location AS location, a.summary AS summary, a.description AS description, 'Shows' AS section, "2" AS browsernav,a.avatar AS image, a.thumb AS thumb,a.created AS created,ec.name AS category, ec.description AS category_description FROM `#__community_events` AS a LEFT JOIN `#__community_events_category` AS ec ON a.catid=ec.id WHERE (a.title LIKE test) AND (a.permission='0') AND a.published IN (1) AND a.creator NOT IN (SELECT user_id FROM `#__user_usergroup_map` WHERE group_id=8) AND a.type IN ('group','profile') AND a.enddate >= '2016-10-10 17:19:02' GROUP BY id, title, location, summary, description, section, browsernav, thumb, image, created, category, category_description ORDER BY a.created DESC LIMIT 50

Also we noticed that user profile only visible after logged-in during in search result, can we allow search for any user profile without loggeg-in?

Thanks

HI, Tarun.

Do you mean that issue appears when you set EQUAL in search: snag.gy/bRgwFN.jpg
Please, provide exact step to replicate this issue.
This will help us to locate fault more efficient.

As for search option availability, do you mean that Advanced Search is not accessible to guests? Link to advanced search is displayed in toolbar that appears after login. So solution may be to add a link to advanced search in your main menu.

I tried to do a search when logged out and I was able to:
snag.gy/mZxeKU.jpg
Also I was able to access user profile:
snag.gy/zxWODj.jpg

If I misunderstood, please, elaborate.

Hi we are not talking about advanced search.

So the error we are facing in:
1. click on the side bar menu in main menu
2. there is a search bar in it, so try to search in it
3. then a new page will open with the search result
4. on that page select "Exact Phrase" and then click search again
5. there you will get the error which we are getting

and also When user is not logged in, they should still be able to search for user profiles, currently is working only when user is logged in.

Hi, Tarun.

But this is not JomSocial search but Joomla! native search.
You can see that in URL component/search... if this would be JS it should be component/community.
It seems that you're using some 3rd party plugins that meant to extend native Joomla! search to search in JomSocial as well... but please, make sure if this plugin is compatible with latest version of JomSocial. If you use such a plugin - please, contact with it developer as our Technical Support don't cover support for 3rd party extensions.

By default there is no option to extend Joomla! native search to JomSocial and no search in JS data tables could be performed.

ohh ok then can we assign jomsocial search in the offcanvas menu like we had for current search?

HI, Tarun.

JomSocial has 3 types of search:

1. Simple under icon in toolbar (searches members only)
2. Advanced available in toolbar under Members -> Advanced search
3. Separated search fields for videos and events available on their list pages.