Support has been upgraded!
The Support Forum is closed. Not to worry! Providing the top quality support you expect and we're known for will continue! We're not ending support, just changing where you submit requests. This will provide you with the best experience possible.
Have you purchased an addon for Connections such as one of our premium templates or extensions with a valid license and you need help?
Please open a Support Ticket in your user account.
Are you using the free Connections plugin? Don't worry, you are still very important to us! We are still providing you with the same high quality support that we're known for.
Please open a new support topic in the WordPress support forums for Connections.
05/04/2016 at 9:14 pm #375243
My client sent me the following email…
When I type in “Peoria, AZ” I get some AZ agents but also Houston, TX, Durham, NC and Toronto Canada agents. Not a robust search capability.
Is there a way to make the search feature work better? Paid extension, setting adjustment, etc?
Here is the page:
http://negotiationexpertise.com/mcne-agents/05/06/2016 at 2:05 pm #375449
re: When I type in “Peoria, AZ” I get some AZ agents but also Houston, TX, Durham, NC and Toronto Canada agents.
That’s because the two letters are being dropped by the database. Most databased drop “short words”. The limit, generally is, three to four characters. The results you see would be for only entries which contains “Peoria”.
Well, there’s another two reasons… each word is searched separately so the results would be representative of entries which contain “Peoria” OR “AZ” (assuming AZ not being dropped). It can not be treated as a single word because the values are stored in separate fields in the database so each word is search for in each field separately. So, the search is actually fairly complex “erring” on the side of a wide results instead a narrowly focused.
re: Is there a way to make the search feature work better?
Yes. First, you can limit the fields that are searched on the Connections : Setting admin page under the Search tab. Second, you can try disabling the Keyword Search option.
Another option, try enabling the locality, region and postal code Permalink options. This will allow you users to filter by those. The related portions of the address will be comes links and when those links are clicked on the results will be filtered by what was clicked.
Lastly, a custom search option could be developed.
Hope that helps!05/06/2016 at 10:54 pm #375485
Thanks for the reply Steven. My hosting said they DO support FULLTEXT, however the search does not work at all when I disable the “Enable LIKE query support.”checkbox. Is there another setting I need to adjust in order to make it work? Thanks05/09/2016 at 10:59 am #375638
Try disabling and then enabling the FULLTEXT option. If that does not work, can you please share your system info with me. You can create a temporary share link on the Connections : Tools admin page under the System Information tab.05/10/2016 at 4:08 am #375782
Thanks, I have never done this before. How do I securely send you access? Thank you05/10/2016 at 10:41 am #375844
re: I have never done this before. How do I securely send you access? Thank you
Here’s the doc page. Go to the Connections : Tools admin page and click the System Information tab. Scroll down and generate a URL by click the button. Copy the URL and reply back having pasted in the message. You can also check the “Set as private reply” option before submitting the reply.05/11/2016 at 12:40 am #375945This reply has been marked as private.05/11/2016 at 4:03 pm #376057
I suspect the tables were created with the InnoDB db engine which does not support FULLTEXT indexes in the version of MySQL installed on the server.
Log into the webhost’s control panel for your site and use the phpMyAdmin tool to check the table engine being used and if it is InnoDB, change the Connections tables to MyISAM. After you do that, then toggle the FULLTEXT setting in Connections so the FULLTEXT indexes will be created by the database.
Hope that helps!
You cannot reply to this support topic. Please open your own support topic.