Remove WPBakery Page Builder (formerly Visual Composer) shortcodes from the Excerpt

I’ve had this issue on a site where we’re using WPBakery Page Builder and its built-in “Grid Builder” for showing a selection of pages. Within the Grid Builder, we’re outputting the page excerpt. 

This means that WordPress shows certain shortcodes (or some variations of them) within the excerpt:

Continue reading “Remove WPBakery Page Builder (formerly Visual Composer) shortcodes from the Excerpt”

Deleting Yoast SEO metadata for a Custom Post Type

I needed to delete 20.000+ rows in the wp_postmeta table which related to a Custom Post Type and Yoast SEO. The SQL I ended up using was this:

DELETE pm 
FROM wp_postmeta pm
LEFT JOIN wp_posts wp ON wp.ID = pm.post_id
WHERE wp.post_type LIKE '%CUSTOMPOSTTYPENAME%'
AND pm.meta_key LIKE '%_yoast_%'

IMPORTANT: Don’t try this at home. And backup your database! I’m not responsible for any case of data loss!