XF 1.5 Find and delete and attachment with confidential information

DavidXLD

Active member
Hi all,
A member of my site asked me to delete his profile and I did it.
After that, he asked me to delete an attachment he had posted in the past.
He has only the URL of the attachment allowing to download the file.
Unfortunately, now that I have deleted his profile, I do not know how to find where is the attachment on the server and delete it.
Do you have an idea?
Thanks
David
Unfortunately ow tit is impossible for me to find where the
 
@AndyB It is what I did... but he does not know and I do not find it on Google.
On short term I have redirected the URL of the attachment thanks to a .htaccess entry.
But I would be much more confident by deleting the attachment physically on the server.
Thanks
David
 
Yes I know but...
The user asked me to delete its account.
I have deleted the account and now, it is no more possible to find all the messages posted by the member.
All the threads initiated by the member are under the "guest" status and the XenForo search engine does not allow to find threads anymore for a guest.
I can not find the threads anymore even through google.
I know only the URL allowing to open directly the attachment.
What a mess!
 
The URL contains a number, using that number you can locate the post it belongs to by using phpMyAdmin. The table you need to look at is called:

xf_attachment

once you identify the content_id (this is the post ID) you can go to that post with this URL:

https://domain.com/posts/1234/

where 1234 is the post number.
 
Last edited:
Top Bottom