Support

Search results for ""

Sorry, no results found. Perhaps you would like to search the documentation?
All Topics
bill2

Yoast SEO Conflict with Admin Columns Pro

With Yoast SEO and Admin Columns Pro enabled, I get the following errors anytime I search or filter a post type list:

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 1]

[Not unique table/alias: 'wp_postmeta']
SELECT DISTINCT wp_posts.ID FROM wp_posts
LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id)
LEFT JOIN wp_term_relationships AS tt1 ON (wp_posts.ID = tt1.object_id)
LEFT JOIN wp_term_relationships AS tt2 ON (wp_posts.ID = tt2.object_id)
INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id )
LEFT JOIN wp_postmeta ON wp_posts.ID = wp_postmeta.post_id
WHERE 1=1 AND (
wp_term_relationships.term_taxonomy_id IN (43)
AND tt1.term_taxonomy_id IN (43)
AND tt2.term_taxonomy_id IN (43)
)
AND (
( wp_postmeta.meta_key = 'parts' AND wp_postmeta.meta_value != '' )
)
AND wp_posts.post_type = 'product'
AND (
(wp_posts.post_status <> 'trash' AND wp_posts.post_status <> 'auto-draft')
)
GROUP BY wp_posts.ID
ORDER BY CAST(wp_postmeta.meta_value AS CHAR) ASC

3 years, 10 months ago
Stefan
Developer

Hi Bill,

I cannot reproduce the issue with our latest version and the latest version of Yoast SEO. Do you have another plugin active that does something with searching/filtering other than our plugin?

3 years, 10 months ago

You must be logged in to reply to this topic.