Thread tagged as: Question, Problem

perch2_content_items and perch2_content_index referencing regions that don't exi...


I am seeing rows in perch2_content_items and perch2_content_index which reference regions that don't exist in perch2_content_regions.

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?

Cheers, Mark

Mark Fisher

Mark Fisher 0 points

  • 3 years ago

Sorry for posting thrice. I thought going to ACCOUNT -> LOGOUT would log me out of the forum but I see the authentication for the 2 sub-domains is separate.

Drew McLellan

Drew McLellan 2638 points
Perch Support

There shouldn't be a reason to, but you could delete them, yes. Make backups first.