XF 1.1 Checking for orphan attachments?

[Floren]

I did an import from vBulletin to Xenforo. The forum had over 150GB of attachments. Due to the "shaky" setup (lots of old vBulletin products), I'm not sure if all attachments imported properly. Is there a way I could verify if there are any orphan attachments that don't belong to any post?

I'm looking at the xf_attachment and xf_post tables... I don't see a 'content_id' or any column that can associate the attachments to a specific post. Thank you for your help.

 

[Jake Bunce]

Actually the importer doesn't import orphaned attachments. It won't import an attachment if it can't find a matching post_id.