[Official] Database Rollback / Restore / Missing Posts / 24h Data Loss / Dun Goofed

[SkullTraill]

I am extremely sorry guys. I screwed up big time. In the process of purging some accounts (as described here: https://wizardforums.com/threads/email-issue-fixed-unconfirmed-accounts-purged.25509/) - I ended up inadvertently purging several actual in-use accounts. Many belonging to Benefactors (who often don't post because they don't need to). 100s of accounts lost, and 10s of Benefactor accounts lost.

Huge mistake on my part, not sure how the hell I messed up so bad... was probably due to being stressed out about the email issue + recovering from an injury, so a bit woozy.

Anyway, mega stupid mistake on my part. Couldn't live with that level of damage to member/benefactor accounts and decided to rollback the database to the backup right after fixing the email issue (right before purging).

This means all activity, posts, data, registrations etc on WF since the backup have been lost.

Super unfortunate and 100% of the blame is on me... it is what it is though. I hope there's no lasting damage to the DB. I'll keep a close eye over the next few days, but I believe things should be fine now.

Again, super sorry about this.

 

[Morell]

Damn, that's tough. Hope you will heal well from your injury.

It's okay, things happen. Good to see that you keep backing up properly so you can reverse the problems. I guess that unverified accounts will have to wait for now?

 

[SkullTraill]

Damn, that's tough. Hope you will heal well from your injury.

It's okay, things happen. Good to see that you keep backing up properly so you can reverse the problems. I guess that unverified accounts will have to wait for now?

Thanks. No, it's just that people who registered or posted in the last 24-ish hours will have to register/post again. Other than that + 1 award + 2 new benefactors who I have refunded already, nothing else was damaged.

 

[Morell]

Thanks. No, it's just that people who registered or posted in the last 24-ish hours will have to register/post again. Other than that + 1 award + 2 new benefactors who I have refunded already, nothing else was damaged.

Even when stressed and injured, you are still really good in what you do. We are privileged to have you running this place.

 

[kusuri]

You do a ton for us, and I am grateful for all of this still. Recover well. I see a couple things and I am fixing some of my replies. It isnt super bad I think.

 

[akenu]

Btw, does the database you're currently using support transactions? There you should be able to check what records were affected and either commit or rollback depending on the situation.

 

[Mashreqi]

I had a few questions to ask but the messages were deleted

 

[Seimulluh]

Please, Log in or Register to view URLs content!

Please, Log in or Register to view URLs content!

@SkullTraill Surely you are aware of the ongoing php vulnerabilities?

 

[Faria]

This means all activity, posts, data, registrations etc on WF since the backup have been lost.

Previously, the full text of replies would appear in email, and could be retrieved by going to the email and then re-copying them to here. Now the email only notifies that a reply exists, without the text. That was a useful backup.

 

[Mashreqi]

Can anyone find a connection between this incident and supernatural forces

Post automatically merged: Today at 4:27 PM

Sorry I don’t mean to mock but imagining several great magicians who went to other dimensions with their astral bodies and spoke with angels and demons but now with reading glasses are behind a computer struggling with website building

 

[diana_i_gusarova]

I hope that all the data will be successfully restored. In any case, we will understand. No complaints against you. This is life, and anything can happen. Good luck and all the best in the future!

 

[Aeternus]

@SkullTraill , first of all, I wish you great healing. May you recover from your injury.

Second of all, I must say that during the mistake, my post in the thread "Do you think niche forums like this attract any attention" has been lost I see that my reply to @Robert Ramsay as well as a post from @Digiquo is lost.

I will link to the topic here:

https://wizardforums.com/threads/do-you-think-niche-forums-like-this-attract-any-attention.25294

 

[Omee]

Can I blame it on the gnomes? Oh it's actually mercury retrograde also!

 

[Aeternus]

@SkullTraill Another problem is that hellfire lost his ban. I saw the topics about French students as well as the one promoting human sacrifice that he posted and those were some problematic topics

 

[Frater M.M.]

@SkullTraill also wanted to say hope you recover from your injury and thank you for continuing what is pretty much the last bastion for these kind of mulit-path forums.

@SkullTraill , first of all, I wish you great healing. May you recover from your injury.

Second of all, I must say that during the mistake, my post in the thread "Do you think niche forums like this attract any attention" has been lost I see that my reply to @Robert Ramsay as well as a post from @Digiquo is lost.

I will link to the topic here:

https://wizardforums.com/threads/do-you-think-niche-forums-like-this-attract-any-attention.25294

@SkullTraill Another problem is that hellfire lost his ban. I saw the topics about French students as well as the one promoting human sacrifice that he posted and those were some problematic topics

On the plus side, we lost hellfire's actual threads on the French students and human sacrifice. Somewhere in Quantico a fed has been spared from being tipped over the edge by having to trawl thru those threads as well

 

[Robert Ramsay]

Huge mistake on my part, not sure how the hell I messed up so bad... was probably due to being stressed out about the email issue + recovering from an injury, so a bit woozy.

Get well soon! And worry not - I once managed to delete the product database of an entire phone network

 

[diana_i_gusarova]

Probably, it’s due to Mercury’s alignment with the new star T CrB (T Coronae Borealis, “The Flaring Star”), which explodes every 80 years. And now it has exploded once again. Irony, of course, as you understand.

 

[Mh4419]

Some of my posts gone and very sadly some of my likes too

Thanks For Your Hard Working.I Hope You Get Well Soon.

 

[PedroM]

Huge thank you for letting us know! May you recover well from your injury!

 

[Frater M.M.]

Some of my posts gone and very sadly some of my likes too

Please have a like back from me