Looks like there is most likely some DB tables corruption around. For example:
Shows 7 replies , but there are 2 posts in total. Older stuff seems to be in limbo
Yeah, that's because some posts made to those topics are missing but we'd rather leave odd post counts like that in place so that we can identify where posts disappeared from in the future (such as realising that a post is a reply to a post that is no longer there as opposed to just a random post). I don't think a few off counts hurt?
But thanks for pointing this out.
but at least we have ssl instead of a good database backup plan.
This is handled by OSL as previously stated and it was a rare situation in that the backups are taken from SQL2 and it was fixing SQL2 so backups could recommence that then caused issues to SQL1.
OSL are making numerous changes to ensure that their backup infrastructure is a lot more steadfast (As you can read about here
) and we are also working on making our own daily database backups for redundancy in light of this incident (so we will have two independent backup systems backing up to different locations). OSL did have a good backup plan in place (It is considered good/common industry practice to backup from your slave/second SQL server in order to prevent load on your primary SQL1) but of course in this rare edge case that proved problematic which is why we will be working to make it an even greater backup plan.
I might add that SSL is important to us as we highly value our users security and privacy, but requires relatively little work to implement (A few uploads and a few lines added to a virtual host as you know) compared to our new backup infrastructure which we are looking to implement which requires the setting up of various new systems and a lot of man hours in order to ensure it's reliability. Our number one priority is our commitment to your security and, by extension, the security of the data you put on phpbb.com.