You must be logged in to see replies to this topic. Click here to login or register
Home › Forums › Plugins › WooCommerce Photo Reviews › Database error in SQL Syntax
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