Home Forums Plugins WooCommerce Photo Reviews Database error in SQL Syntax

Database error in SQL Syntax

  • Author
    Posts
  • #149862

    SebastiaanVaz
    Participant

    Found this in our debug.log….

    [12-Jan-2023 20:58:54 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 ‘) AND (
    ***_commentmeta.meta_key = ‘id_import_reviews_from_ali’
    ) AND comm’ at line 3 for query
    SELECT COUNT(*)
    FROM ***_comments INNER JOIN ***_commentmeta ON ( ***_comments.comment_ID = ***_commentmeta.comment_id )
    WHERE ( comment_approved = ‘1’ OR comment_approved = ‘trash’ OR comment_approved = ‘spam’ ) AND comment_post_ID IN () AND (
    ***_commentmeta.meta_key = ‘id_import_reviews_from_ali’
    ) AND comment_type != ‘order_note’ AND comment_type != ‘webhook_delivery’

    ORDER BY ***_comments.comment_date_gmt DESC

    made by require(‘wp-admin/edit-form-advanced.php’), do_meta_boxes, VI_WOOCOMMERCE_PHOTO_REVIEWS_Admin_Import_Ali->add_custom_content_meta_box, get_comments, WP_Comment_Query->query, WP_Comment_Query->get_comments, WP_Comment_Query->get_comment_ids

You must be logged in to see replies to this topic. Click here to login or register