A.k.a.: Andrew van der Stock
Super Administrator
a suffusion of yellow
Posts: 3121
Threads: 436
Registered: August 26th, 2002
Member Is Offline
Location: Colorado Springs, CO, USA
Theme: UltimaBB Pro Yellow
Mood: In the family again
posted on September 26th, 2004 at 11:44 PM
Where have all the posts gone?
I'm sorry folks, but I tried to get them back.
Basically, it came down to
a) doing nothing and letting you folks fill the place up again
b) restoring back to Saturday's backup for all posts
c) writing a tool to reconstruct and merge posts from a different forum ... several week's worth of work at my current avaibility level.
Option A is easiest and the one we've decided to take after I discussed the issue with Brad.
Option B would lose approximately 150 posts from today and half way through yesterday, which would cause a lot of consternation.
Option C doesn't help you until maybe the end of October. By then, we'd be about 1/3rd the way through to the next 90 days worth of posts.
--
Technical description:
The forum stores all the stuff in a database. The database is made up of various tables, such as forums, attachments, posts, members, and threads.
Although it was easy enough to select the right threads, and subsequently the right posts and attachments, it is simply not possible to merge them
back into the running database as the ID number for each increments and cannot be set outside of doing a restore. This means each thread has to be
re-created post by post, and attachment by attachment, plus I cannot give you the old TID, FID, or AID urls, so any links to any of the posts would
not work.
However, as the Buying and Selling forums are transitory, the loss of all the threads, although really annoying is not the Apocalypse.
--
Sorry for the data loss - the bug has been fixed, so it will not occur again.
Andrew
Desert Moose
A.k.a.: Chris Hill
Veteran Volks Folk
Cut Cut Cut
Posts: 2098
Threads: 175
Registered: March 4th, 2004
Member Is Offline
Location: Perth W.A.
Theme: UltimaBB Pro Black
Mood: I don't know if I'm indecisive
