[Roger]

Searches seem to be performed as “or” searches instead of “and” searches. This causes a search for a business name with three words to return dozens of other results before the one I am looking for. How can I make this an “and” search, so that all of the terms are required instead of just one?

[Steven Zahm]

@ Roger

Try going to the Connections : Settings admin page and disabling the keyword search option under the Search settings tab. If you server support FULLTEXT searching, you get better search results.

Hope that helps!

[Roger]

I do not get any results when I enable fulfulltext searching. How can I enable it on the server? Is there a command I need to run from the command line?

[Steven Zahm]

@ Roger

You need to change the db engine for the Connections tables using phpMyAdmin. This can usually be accessed from your web host’s control panel. Depending on the version of MySQL that is installed you either want InnoDB or MyISAM. IF MySQL is great than or equal to 5.6.4 then you want InnoDB otherwise you want MyISAM.

To change a table to InnoDB you would use this query:
ALTER TABLE <table-name> ENGINE=INNODB;

To change a table to MyISAM you would use this query:
ALTER TABLE <table-name> ENGINE=MyISAM;

You would replace <table-name> with the actual table.

This is the list of tables you would have to change:

<wp_db_table_prefix>_connections
<wp_db_table_prefix>_connections_address
<wp_db_table_prefix>_connections_phone
<wp_db_table_prefix>_connections_email
<wp_db_table_prefix>_connections_messenger
<wp_db_table_prefix>_connections_social
<wp_db_table_prefix>_connections_link
<wp_db_table_prefix>_connections_date
<wp_db_table_prefix>_connections_meta
<wp_db_table_prefix>_connections_terms
<wp_db_table_prefix>_connections_term_taxonomy
<wp_db_table_prefix>_connections_term_relationships

You would replace <wp_db_table_prefix> with the actual WP db table prefix. The default is wp_.

A simpler way using phpMyAdmin (rather than doing the queries), see this:
http://www.electrictoolbox.com/mysql-change-table-storage-engine/

Before you do this go to the Connections : Settings admin page and disable the FULLTEXT option under the search tab.

When you have completed this, the go back and re-enable it so the FULLTEXT indexes will be built.

That should do it.

[Roger]

Thank you very much! This solves the issue.

[Steven Zahm]

@ Roger

Great to hear!

If you have a moment, I would truly appreciate a review as they really do make a difference. Many thanks in advance!
http://wordpress.org/support/view/plugin-reviews/connections

[Author]

Posts