perch2_content_items and perch2_content_index referencing regions that don't exi...
I am seeing rows in
perch2_content_index which reference regions that don't exist in
Is it safe to delete these with:
DELETE FROM `perch2_content_index`
WHERE regionID NOT IN
(SELECT regionID FROM perch2_content_regions
and similarly for perch2_content_index?
And, if so, is there anything else I might like to do to clean up? Any idea how this happened?