neofight78 wrote:I've had a quick flick through the first few pages of my log and there is an old uploaded image that is displaying, so I guess it must only be more recent images that are missing.
Thank you, that really helps! I'll ask rdearman to take a look, and we'll figure out if we can recover this missing images.
Morning update: One more round of database gremlins
We just had another 25 minutes of downtime while I fixed a problem with the database configuration. It turns out that phpBB was storing the database address in 3 files(!), and not just one, thanks to how the Symphony caching system works. This is nasty and ugly—I'd updated the database URL correctly in the main file, but the two undocumented cache files actually pointed to the wrong database. This meant that, in reality, everybody's posts were being written to the old database, because phpBB never even looks at the config file (outside of the admin panel) as long as the cache exists. That's just gross.
So to fix this, I changed the password on the old database (so that the new site can't access it any more), I migrated the data again, and I cleared all the caches. So now everything should be talking to the correct servers, and even if something tries to access the wrong server, it won't know the password anyway.
Some days I kinda hate technology. But we should be operational again, this time for real!
(hangs head in shame, offers many apologies)