Open
Description
This error emerged when upgrading to version 1.5.1 before using the version 1.4.2
The weird part is that the error only appears with one of my connections types. I need some advice. Thanks!
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 5]
SELECT wp_posts.*, wp_p2p.* FROM wp_posts INNER JOIN wp_p2p LEFT JOIN wp_p2pmeta AS p2pm_order ON ( wp_p2p.p2p_id = p2pm_order.p2p_id AND p2pm_order.meta_key = '_order_to' ) WHERE 1=1 AND wp_posts.post_type IN ('artist') AND (wp_posts.post_status <> 'trash' AND wp_posts.post_status <> 'auto-draft') AND (wp_p2p.p2p_type = 'artists_to_exhibitions' AND wp_posts.ID = wp_p2p.p2p_from AND wp_p2p.p2p_to IN (SELECT wp_posts.ID FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (67) AND wp_posts.post_type IN ('exhibition') AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'future' OR wp_posts.post_status = 'draft' OR wp_posts.post_status = 'pending' OR wp_posts.post_author = 1 AND wp_posts.post_status = 'private') )) ORDER BY p2pm_order.meta_value+0 ASC,