• Resolved mmtomm

    (@mmtomm)


    Hi,

    during research on a (different) problem I found a lot’s of lines in the error log regarding your plugin. 2 Examples:

    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 NOT IN ('atum_order_note', 'log_note') ORDER BY comment_date' at line 1 f\xc3\xbcr Abfrage SELECT wp_comments.* FROM wp_comments AND comment_type NOT IN ('atum_order_note', 'log_note') ORDER BY comment_date_gmt DESC LIMIT 20 von require('wp-blog-header.php'), wp, WP->main, WP->parse_request, apply_filters('request'), WP_Hook->apply_filters, woocommerce_mpay24cw_alter_the_query, woocommerce_mpay24cw_is_plugin_page, woocommerce_mpay24cw_get_page_id, url_to_postid, WP_Query->__construct, WP_Query->query, WP_Query->get_posts
    
    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 NOT IN ('atum_order_note', 'log_note') ORDER BY comment_date' at line 1 f\xc3\xbcr Abfrage SELECT wp_comments.* FROM wp_comments AND comment_type NOT IN ('atum_order_note', 'log_note') ORDER BY comment_date_gmt DESC LIMIT 20 von require('wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts
    

    the first example references our payment provider plugin. the second one is not related to any plugin.

    They all have this ‘at line 1 f\xc3\xbcr’ in common.

    Best regards
    Tom

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Stock Management Labs

    (@stockmanagementlabs)

    Hi Tom,

    Thank you very much for your post.

    I am sorry you are having issues with your site. Our team would be glad to help of course. I have forwarded the issue to our senior dev.

    He will have a look at it first thing tomorrow.

    Best Regards,

    Pavel

    Plugin Author Stock Management Labs

    (@stockmanagementlabs)

    HI mmtomm,

    Thank you very much for your patience.

    Or developers have tried every possible variation of setups and cant replicate any syntax error.

    It seems specific to your site and in our opinion it could be a 3rd party plugin blocking some functions.

    We are not able to help you out on this forum, but can advise you to disable all the plugins apart of WooCommerce and ATUM. See if the problem is there.

    Then just add plugin by plugin to find out when the Error appears. That way you will hopefully be able to find the issue.

    Let me know.

    Pavel

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

The topic ‘many errors in sql syntax found in cgi-debugger log’ is closed to new replies.