• Resolved mileu

    (@mileu)


    Hi, any idea why I am getting this error in my server log?

    Here’s a complete log:

    WordPress database error Unknown column 'tter.name' in 'where clause' for query SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON (wp_posts.ID = wp_postmeta.post_id) WHERE 1=1 AND (((((wp_posts.post_title LIKE '%זיגי%') OR (wp_posts.post_content LIKE '%זיגי%')) AND ((wp_posts.post_title LIKE '%סטאר%') OR (wp_posts.post_content LIKE '%סטאר%')) AND ((wp_posts.post_title LIKE '%דאסט%') OR (wp_posts.post_content LIKE '%דאסט%'))) OR (((tter.name LIKE '%זיגי%') AND (tter.name LIKE '%סטאר%') AND (tter.name LIKE '%דאסט%')) OR (tter.name LIKE '%זיגי סטאר דאסט%')) )) AND (wp_posts.post_password = '') AND wp_posts.post_type = 'product' AND (wp_posts.post_status = 'publish') AND ( (wp_postmeta.meta_key = '_visibility' AND CAST(wp_postmeta.meta_value AS CHAR) IN ('visible','search')) ) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC made by require('wp-blog-header.php'), wp, WP->main, do_action_ref_array, call_user_func_array, WC_Query->get_products_in_view, get_posts, WP_Query->query, WP_Query->get_posts

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

Viewing 9 replies - 1 through 9 (of 9 total)
  • Hey mileu,

    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. I’m sure together we’ll make it work, but in order to do so, 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 plugin/WP you are using? We really need to know what we are dealing with in order to help you out. So 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 the plugin and re-enable it. It should rebuild the table by itself.
    If that doesn’t work, please disable and delete the plugin. Then re-install from fresh download.

    Let me know how it works out.

    Take care & have a nice day!

    Petra

    Thread Starter mileu

    (@mileu)

    Hi PetraP,

    I will try these suggestions.

    Moving on, here are the infos you requested.

    WordPress 3.8.1

    Plug-ins Installed:
    * Add Multiple USers
    * English WordPRess Admin
    * Newsletter
    * No Future Posts
    * Redirection
    * Regenerate Thumbnails
    * Search Everything
    * Simple Ads Manager
    * TinyMCE Advance
    * W3 Total Cache
    * WooCommerce
    * WooCommerce Checkout Manager
    * WooCommerce Print Invoices & Delivery Notes
    * WordPress HTTPS
    * WordPress SEO
    * WPFront Notification Bar
    * WP Smush.it
    * YITH WooCommerce Wishlist
    * And 2 custom plugins I made which is a payment gateway and a plugin for sorting something (it uses different table)

    Additional infos:
    * All our data in DB are in Hebrew chars
    * We are using a different table prefix. Something like: wp_e43245343_
    * We have an 100k+ entries in the wp_posts table
    * We have 40k+ data in wp_postmeta table

    Hey,

    just a quick question – you are logged in your WordPress’s Dashboard as an Admin, right?
    Also, I am being curious – have you tried what was suggested and did it help in anyway?

    Best,

    Petra

    Thread Starter mileu

    (@mileu)

    Hi Petra,

    Yes I’m logged as admin.

    I haven’t tried your suggestion. But I will try them later since I’m almost done setting up our test machine.

    I’ll let you know as soon as I’m done with your suggestions.

    Regards,
    mileu

    PetraP

    (@petrap)

    Hey,

    before you try anything, I also suggest to update the plugin – we released a new version a few days ago.

    Take care and have a nice day,

    Petra

    Thread Starter mileu

    (@mileu)

    Hi Petra,

    The error above is not appearing in the test machine I set-up. Our live is in shared hosting. Could it be that there’s a limit in the DB server?

    Anyway, it seems the cause of the error I reported was from something else.

    Regards,
    mileu

    PetraP

    (@petrap)

    Hey,

    so this is kind of semi-great news 🙂
    And to be honest, I am not sure what exactly do you mean by “limit in the DB server”?

    Best,

    Petra

    Thread Starter mileu

    (@mileu)

    I meant, maybe the hosting put a time or query limit on executing SQL queries…

    Anyway, the error is not showing anymore so I guess this is resolved for now.

    Thank you for help!

    Regards,
    mileu

    Same problem,
    Solved after disable/re-enable all the plugins.

Viewing 9 replies - 1 through 9 (of 9 total)

The topic ‘WordPress database error Unknown column 'tter.name' in 'where clause'’ is closed to new replies.