03-05-2017, 03:50 AM
Here's a good one...
After checking to make sure that I did everything correct (I made it to post #930) I went to remove the first post since it was a duplicate. Well, at first I did a soft delete and that hides the post but keeps a placeholder area saying "post deleted". Figuring that was a bit annoying I clicked the little checkbox, then in the moderators options I see (1) post selected and click the Delete Post Permanently.
After about 5 seconds I think to myself, "that's sure taking a while". After 20 seconds I then thought, "I bet it's deleting all posts". Yup. All the posts were gone, the thread was gone and a quick check with FTP to see the attachment directory, all files were gone too. Crud.
Normally that would cause an "oh shit!" moment, a sinking feeling in the gut and a wave of panic.
Nope... It's 7:30pm and I have a movie date at 8pm... challenge accepted.
With FTP running, I go to my NAS and select all 6,189 files to upload. While that's going on I recreate the thread then hit the database to see what the new index numbers are for the thread, posts and attachments. I update my source code with the new index numbers. Re-run my program to create the new INSERT DB scripts for the posts and attachments. Run the SQL queries once the upload completes and I'm done.
At 7:55pm I was getting some popcorn and beer ready for the movie.
(and the database has been completely backed up now)
After checking to make sure that I did everything correct (I made it to post #930) I went to remove the first post since it was a duplicate. Well, at first I did a soft delete and that hides the post but keeps a placeholder area saying "post deleted". Figuring that was a bit annoying I clicked the little checkbox, then in the moderators options I see (1) post selected and click the Delete Post Permanently.
After about 5 seconds I think to myself, "that's sure taking a while". After 20 seconds I then thought, "I bet it's deleting all posts". Yup. All the posts were gone, the thread was gone and a quick check with FTP to see the attachment directory, all files were gone too. Crud.
Normally that would cause an "oh shit!" moment, a sinking feeling in the gut and a wave of panic.
Nope... It's 7:30pm and I have a movie date at 8pm... challenge accepted.
With FTP running, I go to my NAS and select all 6,189 files to upload. While that's going on I recreate the thread then hit the database to see what the new index numbers are for the thread, posts and attachments. I update my source code with the new index numbers. Re-run my program to create the new INSERT DB scripts for the posts and attachments. Run the SQL queries once the upload completes and I'm done.
At 7:55pm I was getting some popcorn and beer ready for the movie.
(and the database has been completely backed up now)