Support » Fixing WordPress » Database errors

  • Im getting this error on two two of my wordpress sites and i have no ideas what it means. could you help me please.

    Here is the error:

    [Mon Jul 10 13:04:45.225723 2017] [:error] [pid 3198] [client 184.154.139.21:25844] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND comment_type != 'webhook_delivery' ORDER BY comment_date_gmt DESC LIMIT 1' at line 1 for query SELECT wp_kzdj_comments.* FROM wp_kzdj_comments AND comment_type != 'webhook_delivery' ORDER BY comment_date_gmt DESC LIMIT 10 /* From [freddysjewelry.com/home/feed/] in [/nas/content/live/freddys/index.php:17] */ made by require('wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, referer: http://www.google.com/url?url=freddysjewelry.com&yahoo.com

Viewing 10 replies - 1 through 10 (of 10 total)
  • Hi, radevwp. From the author of the Woocommerce plugin:
    https://github.com/woocommerce/woocommerce/pull/15862

    Please let us know if it helps.

    when they say “They need to append the additonal where clause to avoid SQL errors on
    the feed URL.” they are saying woocommercce needs to fix this?

    From the discussion, it looks as though the plugin has been updated w/the changes. So I’d recommend seeing if the plugin has an update via your dashboard, & if so, running said update & see if it helps.

    Hello, I just checked the server log files and I have a somewhat similar WordPress database error. I use WordPress 4.8.1 and WooCommerce version 3.1.0 (will update to latest version of WC today). I use a theme based on Underscores.

    [Sun Aug 06 06:34:07 2017] [error] [client 68.180.228.216] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘AND comment_type != ‘webhook_delivery’ ORDER BY comment_date_gmt DESC LIMIT 1′ at line 1 for query SELECT wp_comments.* FROM wp_comments AND comment_type != ‘webhook_delivery’ ORDER BY comment_date_gmt DESC LIMIT 10 made by require(‘wp-blog-header.php’), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts

    Is this a theme problem that causes the database error? I’m new to these things, any help is very much appreciated, thank you!

    Hello, DodoDog, & welcome. It would actually be better if you start your own topic regarding this, as this topic hasn’t been responded to for some time, & the only reason I’m doing so now is because I forgot to unsub from it. Always better to start your very own personal topic.

    Please update your Woocommerce & see if the problem disappears. If not, again, please post a new topic, to include your site url, your theme name, & your versions of WC & WordPress. You may post a link here if you wish so that the topic can be referenced. Either I or 1 of the other forum volunteers will be glad to help.

    Sorry it took so long to answer Jackie, updated WooCommerce and the problem is solved. You’re right, next time I will make a new topic on the forum. Thank you so much for your advise, keep up the good work!

    One more thing, should this topic be closed? And how do I do this (maybe I’m not authorised to do so,…) Thank you!

    @dododog, if you’d please be so kind as to just mark the topic as ‘resolved’, that’d be good. Thanks. Glad the update worked for you.

    Sorry, but the status of this topic can’t be changed to “resolved” because the option to do so is not active. The options don’t appear, no fold out and I can’t click it. Please advise how to solve this, thank you!

    No worries, @dododog, just feel welcome here & forget the clerical stuff. Glad you got your issue resolved–that’s what’s really important. It’ll close on its own eventually. Good luck w/your endeavors.

Viewing 10 replies - 1 through 10 (of 10 total)
  • The topic ‘Database errors’ is closed to new replies.