Would a data leak contain old user emails?

Do not post support requests, bug reports or feature requests. Discuss phpBB here. Non-phpBB related discussion goes in General Discussion!
Suggested Hosts
User avatar
KevC
Support Team Member
Support Team Member
Posts: 69239
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: Would a data leak contain old user emails?

Post by KevC » Wed Aug 14, 2019 8:47 pm

MacbethRepents wrote:
Wed Aug 14, 2019 8:39 pm
Would you be able to post up instructions so I could request it from an admin?
The owner of a site is unlikely to do a lot of complex editing because one user has asked them to add something.
-:|:- Support Request Template -:|:-
Image
Cheap UK Hosting
"In the land of the blind the little green bloke with no pupils is king - init!"

User avatar
KevC
Support Team Member
Support Team Member
Posts: 69239
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: Would a data leak contain old user emails?

Post by KevC » Wed Aug 14, 2019 8:52 pm

MacbethRepents wrote:
Wed Aug 14, 2019 8:39 pm
So it's a existing specific log I'd like to erase, not all logs going forward, can any admin do this in the ACP?
As I said before, what's the bigger picture here?

Are you actually asking if you can contact the admin of a site that you use to ask them to delete the record of an email address change because you don't want them to see the old email address you used?

If so, 99.99% of admins won't have even noticed that you've changed it. Telling them about it will make them go and look and then they really will see it!
-:|:- Support Request Template -:|:-
Image
Cheap UK Hosting
"In the land of the blind the little green bloke with no pupils is king - init!"

User avatar
3Di
Former Team Member
Posts: 13916
Joined: Mon Apr 04, 2005 11:09 pm
Location: Milan (IT) Frankfurt (DE)
Name: Marco
Contact:

Re: Would a data leak contain old user emails?

Post by 3Di » Wed Aug 14, 2019 8:54 pm

MacbethRepents wrote:
Wed Aug 14, 2019 8:39 pm
Would you be able to post up instructions so I could request it from an admin?
Execute query in phpmyadmin or similar tool.
Change phpbb_ table prefix to yours if different.

DELETE FROM `phpbb_log` WHERE `log_operation` LIKE 'LOG_USER_UPDATE_EMAIL' AND `log_data` LIKE '%MacbethRepents%';

The above will delete only those logs where you changed your email and related data.
Please PM me only to request paid works. Thx.
Want to compensate me for my interest? Donate
My development's activity º PhpStorm's proud user
Extensions, Scripts, MOD porting, Update/Upgrades
👨‍🏫 | Take a tour to | The Studio | 👨‍🏫

MacbethRepents
Registered User
Posts: 11
Joined: Wed Aug 14, 2019 6:03 pm

Re: Would a data leak contain old user emails?

Post by MacbethRepents » Wed Aug 14, 2019 8:57 pm

KevC wrote:
Wed Aug 14, 2019 8:52 pm
MacbethRepents wrote:
Wed Aug 14, 2019 8:39 pm
So it's a existing specific log I'd like to erase, not all logs going forward, can any admin do this in the ACP?
As I said before, what's the bigger picture here?

Are you actually asking if you can contact the admin of a site that you use to ask them to delete the record of an email address change because you don't want them to see the old email address you used?

If so, 99.99% of admins won't have even noticed that you've changed it. Telling them about it will make them go and look and then they really will see it!
I was more concerned about hackers etc. but you're right, it's a bit silly when you put it like that.

MacbethRepents
Registered User
Posts: 11
Joined: Wed Aug 14, 2019 6:03 pm

Re: Would a data leak contain old user emails?

Post by MacbethRepents » Wed Aug 14, 2019 8:57 pm

3Di wrote:
Wed Aug 14, 2019 8:54 pm
MacbethRepents wrote:
Wed Aug 14, 2019 8:39 pm
Would you be able to post up instructions so I could request it from an admin?
Execute query in phpmyadmin or similar tool.
Change phpbb_ table prefix to yours if different.

DELETE FROM `phpbb_log` WHERE `log_operation` LIKE 'LOG_USER_UPDATE_EMAIL' AND `log_data` LIKE '%MacbethRepents%';

The above will delete only those logs where you changed your email and related data.
Thanks, I appreciate that.

User avatar
david63
Registered User
Posts: 16328
Joined: Thu Dec 19, 2002 8:08 am
Location: Lancashire, UK
Name: David Wood
Contact:

Re: Would a data leak contain old user emails?

Post by david63 » Thu Aug 15, 2019 1:18 am

3Di wrote:
Wed Aug 14, 2019 8:54 pm
MacbethRepents wrote:
Wed Aug 14, 2019 8:39 pm
Would you be able to post up instructions so I could request it from an admin?
Execute query in phpmyadmin or similar tool.
Change phpbb_ table prefix to yours if different.

DELETE FROM `phpbb_log` WHERE `log_operation` LIKE 'LOG_USER_UPDATE_EMAIL' AND `log_data` LIKE '%MacbethRepents%';

The above will delete only those logs where you changed your email and related data.
How would a "user" run a sql query via phpMyAdmin?
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
Registered User
Posts: 2378
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Belt ... well actually Belgium

Re: Would a data leak contain old user emails?

Post by warmweer » Thu Aug 15, 2019 7:56 am

david63 wrote:
Thu Aug 15, 2019 1:18 am
How would a "user" run a sql query via phpMyAdmin?
MacbethRepents can't do it as a user, but can ask the admin to do it (under the assumption the admin has phpMy Admin access).
MacbethRepents wrote:
Wed Aug 14, 2019 8:39 pm
Would you be able to post up instructions so I could request it from an admin?
My board's not broken, it just went peculiar

User avatar
KevC
Support Team Member
Support Team Member
Posts: 69239
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: Would a data leak contain old user emails?

Post by KevC » Thu Aug 15, 2019 7:59 am

Your old and new email addresses would already be all over the internet anyway. So if a hacker got in and delved deep enough to find your one account that had an email change, what are they gaining? They probably already know it.

My dear old mum only emails me and my brother and gets online shopping. She gets spam mail. They know eveyone's address. And if they don't they just fire off dictionary words or sets of numbers. It's not a 'private' piece of information to know an email address.
-:|:- Support Request Template -:|:-
Image
Cheap UK Hosting
"In the land of the blind the little green bloke with no pupils is king - init!"

MacbethRepents
Registered User
Posts: 11
Joined: Wed Aug 14, 2019 6:03 pm

Re: Would a data leak contain old user emails?

Post by MacbethRepents » Thu Aug 15, 2019 8:05 am

Yeah, you're right, I know all I need to know if you want to lock this or anything.

Edit: But thanks for the help, everyone. It was just a mild curiosity / concern and you put my mind at ease.

Post Reply

Return to “phpBB Discussion”