My site’s been broken for a while. And now, after three(?)+ years I think I’ve finally got it working correctly again.
Part of my issue was my previous host — (mediatemple)/GoDaddy — had broken my posts, postmeta, etc. into two different sets of tables. When I moved the site to where it currently resides, whatever they did to have things read from those tables with different prefixes stopped working.
With the help of ChatGPT, I was able to iterate through a series of prompts that enabled me to combine all of the tables that needed to be combined via SQL (as well as work through some issues that cropped up along the way). I know ChatGPT’s not great for the planet, and I try to avoid using it unless I’m absolutely stuck on something, but it was great for trying to work through a problem I didn’t know how to fix otherwise.