Search in dashboard

I also have the same issue. Is there any solution, please?

no solution yet… tried almost everything available online 🙁

If i run the following query on the SQL DB manually, it looses the connection.

SELECT DISTINCT posts.ID as product_id, posts.post_parent as parent_id
FROM wp_posts posts
LEFT JOIN wp_postmeta postmeta
ON posts.ID = postmeta.post_id
WHERE posts.post_type IN (‘product’,’product_variation’)
AND ( ( ( posts.post_title LIKE ‘%samsung%’)
OR ( posts.post_excerpt LIKE ‘%samsung%’)
OR ( posts.post_content LIKE ‘%samsung%’ )
OR ( postmeta.meta_key = ‘_sku’
AND postmeta.meta_value LIKE ‘%samsung%’ ) ))
ORDER BY posts.post_parent ASC, posts.post_title ASC

If i just run it on post.title it works, looks like all those joins are making it fail….

SELECT DISTINCT posts.ID as product_id, posts.post_parent as parent_id FROM wp_posts posts LEFT JOIN wp_postmeta postmeta ON posts.ID = postmeta.post_id WHERE posts.post_type IN (‘product’,’product_variation’) AND ( posts.post_title LIKE ‘%samsung%’) ORDER BY posts.post_parent ASC, posts.post_title ASC

• This reply was modified 5 years, 8 months ago by DiscountDukan.