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 WHERE 1);
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?