ALL users and ALL posts are gone

Get help with installation and running phpBB 3.3.x here. Please do not post bug reports, feature requests, or extension related questions here.
Abtzero
Registered User
Posts: 7
Joined: Mon Jan 18, 2021 1:33 pm

ALL users and ALL posts are gone

Post by Abtzero »

Well, do I hate mondays now?

I had to cleanup my board due to heavy spamming.

I had to delete 1420 User accounts.
Therefore I looked into the phpMyAdmin interface and read some of the email-addresses. Many russian addresses appeared repetedately (strange word...?) So I strated prune useres by wildcarding email-adresses.
Like *popmile45.com I filtered out dozends of users at the same time.

I always was asked for confirmation with a username-list. I also deleted all posts of these users.

In the end all users were deleted and all posts.
I never confirmed the deletion of known users, and I think, I did not enter just "*".

I do not know, what happened.
I do not have a backup; the board was relatively young and had about 50 users. But some important posts...

There is no raw backup in the database?

There is no enthusiasm left for my project.
I feel just empty...
Last edited by Mick on Sat Jan 23, 2021 8:48 am, edited 1 time in total.
Reason: Solved
User avatar
KevC
Support Team Member
Support Team Member
Posts: 70432
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: ALL users and ALL posts are gone

Post by KevC »

Contact your hosts. They should have a backup.
-:|:- Support Request Template -:|:-
Image
Cheap UK Hosting
"In the land of the blind the little green bloke with no pupils is king - init!"
Abtzero
Registered User
Posts: 7
Joined: Mon Jan 18, 2021 1:33 pm

Re: ALL users and ALL posts are gone

Post by Abtzero »

Hey KevC, there is a mySQL backup!!!
I did not think about the hoster... let 's see!


THANK YOU!
User avatar
warmweer
Jr. Extension Validator
Posts: 6501
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Bel ... gium

Re: ALL users and ALL posts are gone

Post by warmweer »

Abtzero wrote:
Mon Jan 18, 2021 1:45 pm
I do not have a backup; the board was relatively young and had about 50 users. But some important posts...
Unforgiveable mistake.
Never do major edits without having a backup!
Spelling is freeware, which means you can use it for free.
On the other hand, it is not open source, which means you cannot change it or publish it in a modified form.
User avatar
david63
Registered User
Posts: 19038
Joined: Thu Dec 19, 2002 8:08 am
Location: Lancashire, UK
Contact:

Re: ALL users and ALL posts are gone

Post by david63 »

Abtzero wrote:
Mon Jan 18, 2021 1:45 pm
I looked into the phpMyAdmin interface
Ad never directly edit the database unless you know exactly what you are doing. Editing just one table will, as you have found out, almost certainly break your board as many of the tables are interlinked.
David
Remember: You only know what you know and - you don't know what you don't know!
My CDB Contributions | How to install an extension
I will not be accepting translations for any of my extensions in Github - please post any translations in the appropriate topic.
No support requests via PM or email as they will be ignored
Abtzero
Registered User
Posts: 7
Joined: Mon Jan 18, 2021 1:33 pm

Re: ALL users and ALL posts are gone

Post by Abtzero »

david63 wrote:
Mon Jan 18, 2021 3:03 pm
Abtzero wrote:
Mon Jan 18, 2021 1:45 pm
I looked into the phpMyAdmin interface
Editing just one table will, as you have found out, almost certainly break your board as many of the tables are interlinked.
No, I did not find out. I did not edit the table in phpMyAdmin.
I just took a look to see, which different domains for the user-emails exist. So I found 30-40 who's users are definbitely spammers and deleted them with the admin-gui. I do not know, how it happened to have all users deleted except myself

So there should be a filter witgh a domain blacklist. That would filter out some ammount.
Is there any plugin? I would ban the IP directly...
User avatar
warmweer
Jr. Extension Validator
Posts: 6501
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Bel ... gium

Re: ALL users and ALL posts are gone

Post by warmweer »

Abtzero wrote:
Mon Jan 18, 2021 3:39 pm
So there should be a filter witgh a domain blacklist. That would filter out some ammount.
ACP > Users and Groups > User Security > Ban emails
Abtzero wrote:
Mon Jan 18, 2021 3:39 pm
Is there any plugin? I would ban the IP directly...
Banning IPs is a waste of time unless you know for 100% the user has a fixed IP, and even then - long live proxies :lol:
Spelling is freeware, which means you can use it for free.
On the other hand, it is not open source, which means you cannot change it or publish it in a modified form.
User avatar
Mick
Support Team Member
Support Team Member
Posts: 23055
Joined: Fri Aug 29, 2008 9:49 am

Re: ALL users and ALL posts are gone

Post by Mick »

And, in the majority of cases, boards that get heavily spammed have inadequate anti-spam settings. Please supply a link to your board so we can see what you have and offer some advice.
"The more connected we get the more alone we become" - Kyle Broflovski©
Abtzero
Registered User
Posts: 7
Joined: Mon Jan 18, 2021 1:33 pm

Re: ALL users and ALL posts are gone

Post by Abtzero »

Thanks for the offer to check my board!
Here it is: https://forum.midikey2key.de
Since the re-opening I have 160 new accounts to delete or validate...

They have many similar email-providers: skljo.maildddeaml.com, aksni.sdfaldd.com,akljs.sdgmaipop.com, ...
Is there a plugin just to refuse a list of mailadresses?
User avatar
david63
Registered User
Posts: 19038
Joined: Thu Dec 19, 2002 8:08 am
Location: Lancashire, UK
Contact:

Re: ALL users and ALL posts are gone

Post by david63 »

Abtzero wrote:
Tue Jan 19, 2021 10:21 am
Is there a plugin just to refuse a list of mailadresses?
It is part of the core ACP > Users & Groups > Ban emails

You will not prevent spam with that Captcha - it was broken many years ago.

Use a good Q&A with a question that you cannot Google the answer to in conjunction with the NRU group and your spam will disappear overnight.
David
Remember: You only know what you know and - you don't know what you don't know!
My CDB Contributions | How to install an extension
I will not be accepting translations for any of my extensions in Github - please post any translations in the appropriate topic.
No support requests via PM or email as they will be ignored
User avatar
warmweer
Jr. Extension Validator
Posts: 6501
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Bel ... gium

Re: ALL users and ALL posts are gone

Post by warmweer »

david63 wrote:
Tue Jan 19, 2021 10:26 am
Use a good Q&A with a question that you cannot Google the answer to in conjunction with the NRU group and your spam will disappear overnight.
That's arguably one of the most underused feature phpBB has.
Spelling is freeware, which means you can use it for free.
On the other hand, it is not open source, which means you cannot change it or publish it in a modified form.
Abtzero
Registered User
Posts: 7
Joined: Mon Jan 18, 2021 1:33 pm

Re: ALL users and ALL posts are gone

Post by Abtzero »

david63 wrote:
Tue Jan 19, 2021 10:26 am
&A with a question that you cannot Google the answer to in conjunction with the NRU group and your spam will disappear overnight.
Thanks for Your tips, guys!

I put all the known email-domains I know so far in the ban list. This works.
I also changed to Q&A with the question: "Enter five letters of the phrase birthday starting with the first letter of running.".
Is that understandable for You?

@david63: I do not understand the thing with the NRU group. Something with the "new users" group function (as default)?

Greetz
Abtzero
User avatar
RMcGirr83
Former Team Member
Posts: 21905
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr

Re: ALL users and ALL posts are gone

Post by RMcGirr83 »

rthda
Former Modifications/Extensions Team Member | My extensions | github | All requests for support via PM will be ignored
Appreciate the extensions/mods/support then buy me a beerImage
User avatar
david63
Registered User
Posts: 19038
Joined: Thu Dec 19, 2002 8:08 am
Location: Lancashire, UK
Contact:

Re: ALL users and ALL posts are gone

Post by david63 »

Abtzero wrote:
Tue Jan 19, 2021 11:59 am
I do not understand the thing with the NRU group. Something with the "new users" group function (as default)?
Go to ACP > User registration settings > New member post limit: and set the limit to 1 or 2. Then when a new user registers they will go into the NRU group and their fist one or two posts will need to be approved.
David
Remember: You only know what you know and - you don't know what you don't know!
My CDB Contributions | How to install an extension
I will not be accepting translations for any of my extensions in Github - please post any translations in the appropriate topic.
No support requests via PM or email as they will be ignored
Abtzero
Registered User
Posts: 7
Joined: Mon Jan 18, 2021 1:33 pm

Re: ALL users and ALL posts are gone

Post by Abtzero »

RMcGirr83 wrote:
Tue Jan 19, 2021 12:20 pm
*****
Hey! Now You made my security question googelable... ;)
Post Reply

Return to “[3.3.x] Support Forum”