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.
- This topic has 16 replies, 5 voices, and was last updated 9 years, 6 months ago by Steven Zahm.
04/27/2013 at 5:06 pm #258036
We have quite a large database here, so when so when someone searches for “Steve Brown” we need only the one Steve Brown to be returned, not 100 Steves and 100 Mr Browns for a page of 200 listings when they just wanted one. (just an example)
It sounds like the solution to this is enabling fulltext for the fields we’re concerned with? Is that accurate? Could you walk me through configuring it with phpMyAdmin?
Thank you04/27/2013 at 8:47 pm #258041
FULLTEXT search is already supported by Connections, but because there are a large number of hosts that do not allow this do to the increase MySQL load the simple keyword search is enabled by default too. YOu can turn this off and that should help with the search results.
Go to the Connections : Settings admin page, click the Search tab. Here you can disable the keyword search and configure which fields should be queried.
Hope that helps.04/30/2013 at 9:16 am #258347
Thanks Steve. What is required on the MySQL side? I have to create a FULLTEXT index with the appropriate fields?04/30/2013 at 10:00 am #258352
Also, which tables? connections, connections_phone, and connections_term_relationships?04/30/2013 at 11:52 am #258365
You don’t need to do anything on the MySQL side. Connections creates the required FULLTEXT indices.04/30/2013 at 12:29 pm #258375
Interesting, I did have to create the index myself for it to start finding results. In fact, it still isn’t finding anything if I search by phone number. Id assume because that’s a different table.05/17/2013 at 1:55 pm #260194ANA GARZAParticipant
I also need the search box to work with AND and not OR (when searching more than one word).
If I search for JUAN GARZA, I don´t want displayed all the JUAN and all the GARZA, just the records that contain Both Words. How can I acomplish that?
Thanks, -Ana Maria05/17/2013 at 2:22 pm #260195ANA GARZAParticipant
Now I am using FULLTEXT Search, and it works fine with JUAN MANUEL,
If I search: Notaria 62, it does not work.
If I search: Notaria 129, it does work.
Why don´t it work with 2 letters? If I use “Notaria 62″ Using(” “), then it works. Please help, -Ana Maria
This is where I have the directory:
Thanks!05/17/2013 at 3:14 pm #260196
@ ANA GARZA
Sorry, but there is nothing I can do about that, those are limitations to of MySQL and not Connections. The default character is usually 4+ characters so you webhost must have setup MySQL to allow 3+ character searches.05/20/2013 at 1:20 pm #260391AnaGuest
If I use “”, to search a keyword ejm: “notaria 62″, it will work fine. So, can you please let me know in where is the search code and .php file, maybe I can add this ” ” on the code. Thanks, -Ana Maria
You cannot reply to this support topic. Please open your own support topic.