XF 1.4 Search for attachment based on filename/path

I have a tricky problem. I need to remove a file from my server (under pain of death) but I'm not sure where it is.

All I have is the raw path

I can access that file.

Now how do I work backwards to locate the post/thread associated with that file, in order to cleanly remove it?

Note: I have hundreds of thousands of files and literally millions of posts/threads.
That assumes I know the date. I don't.

But I did try that, and for whatever reason in the 370xxx zone, it's not there. No idea why that would be.

So I assumed there must be something going on that I am not aware of regarding nomenclature.


XenForo moderator
Staff member
If you have the file name then you can use PhpMyAdmin to search the attachment_data table, which will provide the id, user and date.
SELECT * FROM `xf_attachment_data` WHERE `filename` LIKE '%mysteriousfile%'
Thank you @Brogan

It's too bad there's not a better way to do it in Xenoro (e.g. searching attachments by filename, sorting by filename, having an attachment.php input that takes us to the thread/user etc.) but I suppose it's a bit of a niche thing...