I'm missing about 85,000 attachments

[xony]

Hello, I am faced with the following problem, I have physically 267,177 files distributed in 11,300 folders, all under / images / upload /, all have write permissions, but since some were not shown, pass the images to the database , they still did not show, I passed them again to images / upload files, they have recovered many, but they still lack more, can someone help me with this? Thank you.

I currently have 267,177 attachments, but vbulletin only recognizes Single / Total Attachments 190,155 / 182,692

[Wayne Luke]

If attachments were attached to threads that have since been deleted, vBulletin will not count them anymore. It will remove the records from the database if an attachment remains unused but it may stay in the file system.

[xony]

The fact is that I have not deleted them as attachments or removed any messages, those messages appear without the attachment, only the title appears without the image giving an error as the file is not found in the directory.

[Wayne Luke]

Each of those would have an attachment ID. Hovering over the link should produce something like attachment.php?attachmentid=XX. Does the database row for that attachment ID exist within vBulletin's database? They would be stored in the attachment table so...

select * from attachment where attachmentid=XX

If the attachment record exists does the filedata record exist for the attachment? This would be in the filedata table:

Select * from filedate where filedataid=YY

The YY for fileid would be returned as part of the attachment query.

Attachments are stored as fileid.attach in the user's directory. Does the file actually exist in that directory? Attachments are stored by userid... For example, the user with the id of 868 would have their files stored in attachment/path/8/6/8/.