• mike.tenrec

    (@miketenrec)


    When I install and active that “search everywhere” plugin, some of my content that uses custom metadata fields does not display properly. When I review this in my php error logs, I see:

    WordPress database error Unknown column ‘tter.name’ in ‘where clause’ for query SELECT DPFLwp_posts
    .ID FROM DPFLwp_posts WHERE 1=1 AND (((((DPFLwp_posts.post_title LIKE ‘%Practi
    ces%’) OR (DPFLwp_posts.post_content LIKE ‘%Practices%’))) OR ((tter.name LIKE ‘
    %Practices%’)) OR ((tter.slug LIKE ‘%practices%’)) OR ((ttax.description LIKE
    ‘%Practices%’)) OR ((m.meta_value LIKE ‘%Practices%’)) OR ((DPFLwp_posts.post_
    excerpt LIKE ‘%Practices%’)) )) AND DPFLwp_posts.post_type = ‘acf’ AND ((DPFLwp
    _posts.post_status = ‘publish’)) ORDER BY DPFLwp_posts.post_date DESC LIMIT 0,
    5 made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-load
    er.php’), include(‘/themes/dpf/template-practice.php’), dpf_tabs_for_group, dpf_
    fields_for_group, get_posts, WP_Query->query, WP_Query->get_posts

    If I disable the plugin, my page displays as expected. I’ve tried modifying settings in the plugin but those don’t seem to fix things. Any thoughts?

    https://wordpress.org/plugins/search-everything/

Viewing 1 replies (of 1 total)
  • PetraP

    (@petrap)

    Hey Mike,

    thanks for reaching out!
    We are currently a bit in the dark as far as your problem goes, since we can’t replicate it on our side. We are going to need a bit more information on what’s going on — any chance you could tell me what other plugins you have installed? Which version of the WP you are using? What theme are you using? A link to your blog would be really helpful. Any additional information will be more than appreciated!
    I do have a suggestion for you as well: there is a chance that the plugin didn’t drop the table properly, so would you mind disable and delete the plugin. Then re-install from fresh download. It should rebuild the table by itself.
    If that doesn’t work, try to untick the box next to the “Search every custom field (metadata)” in the plugin settings.

    Let me know how it works out.

    Take care & have a nice day!

    Petra

Viewing 1 replies (of 1 total)

The topic ‘Broken wordpress query’ is closed to new replies.