Conflict with Offers for WooCommerce plugin..??

When I have Offers for WooCommerce enabled and I try to filter the IPN list by Live transactions (which currently returns 0 results) I end up with a database error.

WordPress database error: [Not unique table/alias: 'aewp_postmeta']
SELECT SQL_CALC_FOUND_ROWS DISTINCT aewp_posts.ID FROM aewp_posts INNER JOIN aewp_postmeta ON ( aewp_posts.ID = aewp_postmeta.post_id )LEFT JOIN aewp_postmeta ON aewp_posts.ID = aewp_postmeta.post_id WHERE 1=1 AND aewp_posts.post_type = 'paypal_ipn' AND (aewp_posts.post_status = 'publish' OR aewp_posts.post_status = 'adaptive_paments' OR aewp_posts.post_status = 'billing_agreements' OR aewp_posts.post_status = 'mass_payments' OR aewp_posts.post_status = 'merchant_payments' OR aewp_posts.post_status = 'not-available' OR aewp_posts.post_status = 'orders' OR aewp_posts.post_status = 'other' OR aewp_posts.post_status = 'recurring_payments' OR aewp_posts.post_status = 'recurring_payments_p' OR aewp_posts.post_status = 'refund' OR aewp_posts.post_status = 'subscriptions' OR aewp_posts.post_status = 'subscription_payment' OR aewp_posts.post_status = 'shopping_cart' OR aewp_posts.post_status = 'accepted-offer' OR aewp_posts.post_status = 'countered-offer' OR aewp_posts.post_status = 'on-hold-offer' OR aewp_posts.post_status = 'expired-offer' OR aewp_posts.post_status = 'buyercountered-offer' OR aewp_posts.post_status = 'completed-offer' OR aewp_posts.post_status = 'declined-offer' OR aewp_posts.post_status = 'future' OR aewp_posts.post_status = 'draft' OR aewp_posts.post_status = 'pending' OR aewp_posts.post_status = 'private') AND ( ( aewp_postmeta.meta_key = 'test_ipn' AND CAST(aewp_postmeta.meta_value AS CHAR) = '0' ) ) GROUP BY aewp_posts.ID ORDER BY aewp_posts.post_date DESC LIMIT 0, 20

When I disable Offers for WooCommerce the problem goes away. Please install that plugin locally and see if you can reproduce the error, and then please see where the conflict is so we can get it resolved one way or another. Thanks!

Comments (2)