As you will likely have noticed, we were down for a few days.
On Friday, May 27, around 21:30 UTC / 22:30 BST / 18:30 EDT a database glitch resulted in us losing at a quick glance at least 800 - 900 member accounts, including a few moderator and admin accounts.
After trying to do a local restore for a few hours, we shut down FPN, first in order to try a partial and a complete database restore, and when that didn't work, we only had the option to do a full restore from the backup of Thursday, May 26, 17:00 EDT / 22:00 BST / 21:00 UTC, thereby losing some data, for approximately 1400 posts. This we considered to be a better option than losing at least 100,000+ posts from quite a few respected members here, including the loss of those members.
The full restore was finished at around 17:00 EDT / 22:00 BST / 21:00 UTC on Saturday, May 28. The site came online for a short time span, while we were checking initial data integrity. It appeared there were still some data problems, and as we didn't want to take any risks, we brought down the board again, and did a full integrity test of the entire database and board, with fixes as and where needed.
This required the rebuild of all posts, topics, member registrations, PMs, and a host of smaller items, and resulted amongst others automatically in the recount of posts. As we implemented the 30+/30+ rule on January 28, 2010, i.e., 30+ days of registration and 30+ posts in relevant forums (non-Chatter posts), and we hadn't done these integrity test for quite a few years, this rebuild resulted for post counts in the following:
1. All total post counts are likely down due to posting in spam topics and deleted double postings.
2. The main profile post count number lists the total remaining posts, including those in Chatter.
3. The mini profile panel next to each post only indicates all non-Chatter posts, IOW, only those that would count towards a Gold membership.
Because of the rules introduced early 2010, the number in the mini profile panel will likely differ significantly from the number in the full profile, for most members here. Nothing to worry about, however, and as integrity of the database is more important, in our consideration, than a mere number of posts next to one's member id, we considered this to be a minor evil. The recount was done automatically, with the rebuild of the posts, topics and forums, and this also took care of any old, dead links to no longer exisiting posts and topics (increasing integrity IOW).
All of the above was finished around 22:30 BST / 21:30 UTC / 17:30 EDT on Sunday, May 29, so we were effectively down for 2 entire days.
What did we lose because of this unavoidable exercise?
1. All replies, topics, comments, images and classifieds posted after the backup date and time, as mentioned, approximately 1400.
2. All new registrations after the backup date and time, approximately 60 new registrations
3. The automatic server startup procedure
1. and 2. is only something you all can fix, so please add the replies, topics, comments, images and classifieds again we lost, as well as you can, and for those who registered and whose registrations were undone due to the restore, please be so kind to reregister.
As to 3.: we are busy working on that right now. It may take some time to get this in order. Upon a glitch or upon a restart the server used to automatically start up any services it needed for FPN to work correctly, but this has reverted to beign a manual job. Until this is fixed, we may suffer from temporary outages occasionally - nothing to worry about, as nothing will get lost once "Added". It is just annoying. We will inform you when this is fixed again.
Update: Automatic startup procedure is fixed now too!
During the process of restoring and checking/fixing, we tried to keep you all up-to-date as much as possible through a "FPN maintenance" type temporary screen - we do hope this did help in mitigating, at least to some degree, any serious addiction withdrawal symptoms .
The FPN Admin Team
Edited by wimg, 30 May 2011 - 14:22.
Added update for automatic startup fix