Here, important… on the subsite which was broken, try adding an entry with details for every section (address/phone/email, so on).
Edit that entry, was the data saved? Can you make changes and are they saved?
Do the same with adding a category.
It occurred to me that perhaps those tables might be broken (well the ones that I did not rebuild, yesterday that is).