Profile Question changes make members search failing

    • 23 posts
    October 27, 2017 7:25 AM EDT

    When changing a profile question (or just saving it again) breaks the members search when searching for profile question.

    Example:

    Gender

    When adding a new gender (eg. "Couple") and save this question.

    Member searches for "Male" in members search.

    Member get 0 Search results alo when there are 30 male users that should be shown.

    Profile questions are still set by "Male" members.

    Tried to clean cache, did not help.

     

     

     

    • Moderator
    • 6759 posts
    October 27, 2017 7:49 AM EDT

    Please follow the posting guidelines any time you post a bug report. You can copy and paste the required items list. http://community.socialengine.com/forums/topic/4/submitting-issue-bug-reports

    • 23 posts
    October 27, 2017 8:16 AM EDT

    What are the steps to reproduce this issue?

    When adding a new gender (eg. "Couple") and save this question.

    Member searches for "Male" in members search.

    What happens?

    Member get 0 Search results alo when there are 30 male users that should be shown.

    Profile questions are still set by "Male" members.

    What were you expecting to happen?

    Show all Male users

    Any logs, error output, etc?

    (If it’s long, please paste to https://ghostbin.com/ and insert the link here.)

    Paste Log Here

    Any other comments?

    Tried to clean cache, did not help.

    • Moderator
    • 6759 posts
    October 27, 2017 8:18 AM EDT

    You didn't provide the full details required. 

    What versions of software are you using?

    Operating System: …

    SocialEngine PHP Version: …

    • 23 posts
    October 27, 2017 8:32 AM EDT

    What versions of software are you using?

    php7

    Operating System: …

    Centos 6

    SocialEngine PHP Version: …

      4.9.4p4
    • Moderator
    • 6759 posts
    October 27, 2017 9:23 AM EDT

    I'll make tests on my staging site for this issue. Thank you.

    • Moderator
    • 6759 posts
    October 27, 2017 9:49 AM EDT

    I'm not having this issue in testing. For all of the members that have chosen a gender, it shows them in the appropriate search. Note that they have to have selected a gender in order to produce results.

    • Moderator
    • 6759 posts
    October 27, 2017 9:50 AM EDT

    Please do not assign the [BUG] title as that is only for us to assign if we test and find something an actual bug. 

    • 18 posts
    December 28, 2017 10:03 PM EST

    Here's my solution.  Let me know if it works for you.

    I had the same problem.  I was messing around with the profile questions and Gender field did not work on the Advanced Member search page.  I had bought and installed the SocialEngineAddOns Advanced Members plugin along with SEAO core, and some other of their plugins.  Not sure if that has any relevance to this problem.

    I have installed SocialEngine version 4.9.4p4 with most of SE plugins.

    If I remember correctly, I deleted the Male and Female options in the Gender profile question and added them back.  And the search worked again.   Caveat: I think I may also had to go in and re-save each member's profile info for the 'new' Gender value to sink in.

    In my MySQL database, the "engine4_user_fields_options" table has added another set of "Male" and "Female" options.  I'm guessing there's a glitch in the drop down options in general if you change the profile questions regularly.  The fix, in my case, is to delete then add the options back.  The only overhead I've seen so far is the extra (deprecated) field values in the "engine4_user_fields_options" table, which is minimal. 

    Just for my curiosity, if you could go into the "engine4_user_fields_search" table and see if the Gender field is populated.  If not populated, then the values were erased during those profile questions changes and, I'm guessing, must be re-populated somehow.  If the Gender field IS populated, then go into the "engine4_user_fields_options" table and change the Male' and Female's Order value to "999" (which I have) and see if that works.  Long shot, no idea if that will work, but would be a great shortcut if it does.


    This post was edited by Kieuph at December 28, 2017 10:35 PM EST