[Steven Zahm]

@ Thomas

The login/pass worked to get to the site but it still requires a login to view the directory.

The LIKE query is basic. It simply matches words that begin with the keywords that were entered in the selected fields.

The FULLTEXT is more complex but this is handled by the database, not Connections. The database matches against the keyword terms that were entered and orders the results according to a score in the selected fields.

As to why “jour” was working and “journal” was not…

The FULLTEXT is matching against the whole word, not a partial like the LIKE query. Now, when a FULLTEXT query returns zero results, it’ll fallback to a LIKE query automatically.

So with FULLTEXT enabled here’s what was happening so you can see why you were getting the results you were:

• “jour” (found) — No FULLTEXT results, fallback to LIKE, returns partial match results.
• “journal” (not found) — found FULLTEXT results, no fallback to LIKE, returns FULLTEXT whole word matches
• “journali” (found) — No FULLTEXT results, fallback to LIKE, returns partial match results.
• “journalist” (not found) — found FULLTEXT results, no fallback to LIKE, returns FULLTEXT whole word matches
• “journalistin” (found) — found FULLTEXT results, no fallback to LIKE, returns FULLTEXT whole word matches

With LIKE only enabled, you will always receive matches to keywords that being with the entered terms.

All this said, it does sound like everything is work quite correctly.

At one point I did have the FULLTEXT configured to do keyword begins with queries but the feedback I received from quite a few others was that is returned results were too “wide” to be useful. So I made FULLTEXT query whole word only and that seems to satisfy most nearly everyone.

Now, if you really want to have partial term matching with FULLTEXT, there is a filter which you can hook into with a bit of PHP code to change FULLTEXT query back to partial term matching. (NOTE: this will be terms that start with only, FULLTEXT does not support partial match where the term ins within the word).

I hope this thoroughly answers your question.

[Steven Zahm]

@ Barbara

re: Yes, the page renders properly with Enhanced Categories deactivated. But I would like to be able to list the categories on the page.

Great that helps narrow down the cause. Now to figure out why that is causing an error…

Can you attach a screenshot of the Fred entry, specifically the category metabox in the admin when editing the entry?

re: Actually, although the page displays correctly now since deactivating the Enhanced Categories, that error message has not gone away.

Are you certain you are not looking at the old errors in the log? Can you double check the timestamps? Or, better yet, just delete the error log (it’ll recreate automatically as needed) and then visit the page a few times? Do the errors show?

It should not be possible to trigger that section of the code unless Enhance Categories is activated.

If you are still seeing errors, give me a temp admin account and FTP login and I’ll debug this much closer. That’ll actually be the quickest way to resolve this. The details can be posted here as a private reply.

[Steven Zahm]

@ Barbara

Try deactivating the Enhanced Categories extension.

Does the error go away?

[Steven Zahm]

@ Craig

You need to turn it on in the Template Customizer. Here’s how…

• Navigate to the Connections : Templates admin page.
• Click the Customize button for the Default template.
• The page will reload with the Customizer on the left and a preview on the right.
• Enable the bio in the Display panel shown in the Customizer.
• Click an entry name in the preview, any entry will do.
• The preview will refresh displaying the single entry view.
• Enable the bio again. YOu do this because the results list view and the single entry view are configured separately.
• Click the Save and Publish button in the Customizer.
• Exit the Customizer.

Hope that helps!

ps. Take time to navigate around the Template Customizer it provides many options.

[Steven Zahm]

@ Lee Ann

Yes, but that requires breaking the directory up by category … a method that many others use to power several different directories on the same site using Connections. Why does the category method not work for you?

[Steven Zahm]

@ Thomas

Being able to see the screen without being able to dive into the actual queries is not going to help much. How about…

• pasting the contents of the system info here as a private reply.
• a screenshot of the search settings
• a screenshot of the entry edit page “Journalistin” in a field that is searchable but not being found with partial keyword searches.
• the exact shortcode used on the directory page.

That’s all I can think of at the moment.

[Steven Zahm]

@ Barbara

The issue is not that all entries are not being displayed. The issue is that the page is not being completely rendered. Notice how the page header is not displayed and missing the page footer.

Generally this is caused by:

• some fatal plugin conflict, very, very, rare.
• fatal php error, rare, but can happen
• php running out of the memory allocated to it, still rare but more common than the previous two, especially on the lesser expensive shared web hosts.

So, my first suggestion, try increasing the memory allocated to PHP. Here’s an excellent blog post which covers several ways to do it. Which method that will work really depends on the webhost.

http://dailyblogging.org/wordpress/increase-wordpress-memory-limit/

I suggest starting at the top and work your way down the list.

Hope that helps, let me know.

[Steven Zahm]

@ len

It is unlikely that the db update caused this issue since that only slightly changes the db structure when saving and retrieving entries. It sounds like a settings misconfiguration.

I just did a test submission on you site. It appears that my submission did enter the moderation queue as it is not listed on your site. The success message was also correct for a submission entering the mod queue.

Also, I did receive the submission notice letting me know that my submission was received.

It does appear everything is working as expected.

If you are testing while logged in, please see this FAQ.

Hope this helps. Let me know.

[Steven Zahm]

@ Robby

Apologies, forgot to answer the other question…

re: Also, how do I change/edit text from “Choose Category” to “Choose Country”?

In what context? In a template, if so which one. In the admin? You could use the Say What plugin as outlined in this tutorial:

http://connections-pro.com/2014/05/04/quicktip-easy-text-changing/

[Steven Zahm]

@ Robby

I do have an advanced tutorial on how to accomplish this here:

http://connections-pro.com/2015/04/23/quicktip-show-no-entries-until-user-performs-a-search/

This works great with templates that have a drop down category filter. Not 100% certain it’ll work for the category list in the widget pack. It should, but I never tested it.

Hope this helps, let me know.

[Author]

Posts