ISSUE SUMMARY:
i receiving SQL error when i'm using the advanced search, i tried troubleshoot by switching back to original jomsocial template. there's such error also.

STEPS TO REPLICATE:
1. Select one of the profile type
2. Leave name field as empty
3. Add criteria for extra field ( refer attachment : search-step.jpg )
4. Search ( refer attachment : sql-error.jpg )
5
RESULT
EXPECTED RESULT
BROWSER

Hi,

can you remove the restrict configration, please? I cant access your site, and it shows error 403 forbidden access, also I need your phpmyadmin access as well.

thank you

Hi Dimas,

is it safe to post the access here? hope to hear you soon.

Hi,

Edit your first post www.jomsocial.com/index.php?option=com_k...d=29527&mesid=143195 and put the info on "Miscellaneous"

thank you

Hi Dimas,

Already provided the login credential

Thank you

Hi,

Seems this is a bug, I will mark this as a bug for now.

thank you

Hi Dimas,

if so when will you providing the fix?
Meanwhile for that is it possible to change the default criteria to other field for temporary usage until the bug is fix?

I will let you know once it done, I suggest you disabled the adv. searn menu for a while

Please you check again, should work fine now..

I already updated the code by myself..