In another post, I’m talking about a case where it turned out to be a mismatch between some pretty central tables in the database. I’m assuming that this mismatch was caused by years of upgrades as well as a migration to another server and installation type (from downloads to composer) a few years ago.
This has me think that maybe there’s a way to make a new and fresh installation, and then transfer the data from the current installation. However, since there is a mix of data populated from the installation and site data in the database, I’m unsure if it’s possible to do this in a sane way. Is there?
Alternatively, is there a repair wizzard of some sort that can check that the core data is sane, i.e. that things like (from the other post) pkCategoryID is matching the way it should across diverse tables?