Viewing 4 posts - 1 through 4 (of 4 total)
  • #155139
    ksprague
    Member
    Post count: 21

    When I navigate to any product in our WooCommerce shop, this error message appears in the error_log:


    [04-Mar-2015 22:00:00 UTC] 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 ')' at line 3 for query SELECT p.* FROM bcrc_wp_posts AS p
    INNER JOIN bcrc_wp_term_relationships AS tr ON p.ID = tr.object_id INNER JOIN bcrc_wp_term_taxonomy tt ON tr.term_taxonomy_id = tt.term_taxonomy_id
    WHERE p.post_date > '2015-02-06 10:59:30' AND p.menu_order = '52' AND p.post_type = 'product' AND p.post_status = 'publish' AND tt.taxonomy = 'category' AND tt.term_id IN () made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/neighborhood/woocommerce/single-product.php'), woocommerce_get_template_part, wc_get_template_part, load_template, require('/themes/neighborhood/woocommerce/content-single-product.php'), next_post_link, get_next_post_link, get_adjacent_post_link, get_adjacent_post, apply_filters('get_next_post_where'), call_user_func_array, cpto_get_next_post_where

    Looking through the support forums here, I see another ticket for the same issue (theoretically caused by the Previous and Next Post in Same Taxonomy plugin) from a couple years ago, with a reply indicating that it would be fixed in the next release.

    #155146
    Rui Guerreiro – SUPPORT
    Keymaster
    Post count: 25779

    Hi,

    I notice that you have a child theme. Check if that error happens with the parent theme active, also try to disable all plugins except Woocommerce.

    -Rui

    #155319
    ksprague
    Member
    Post count: 21

    A-HA! I apologize for not doing my due diligence before I wrote. Looks like a conflict between the theme’s WooCommerce templates and the Post Types Order plugin:

    Post Types Order

    We do use that plugin pretty extensively. Any way you could address the conflict?

    #155324
    Rui Guerreiro – SUPPORT
    Keymaster
    Post count: 25779

    Hi,

    Unfortunately not since it’s not related to the theme.

    Try to search in the web for similar issues and check the support site of the Post types orde for similar issues.

    -Rui

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in and have valid license to reply to this topic.

License required for one of the following items
Login and Registration Log in · Register