XF 2.1 Wrong attachments being displayed

[knobby]

Hi,
I've noticed on some posts in my forum that certain pictures are being displayed which are nothing to do with the post, and are not what the attachment should be. I have found that the pictures actually come from a posts in a "staff only" forum which I made many years ago. An example may explain better:


As you can see above the attachment is a spreadsheet, and the original poster inserted it into the post. The motorcycle picture (which this poster would not have any access to) was a test attachment in a thread in a restricted access node.
There are other examples of a similar nature.
Any idea what's going on and what I can do to fix it?
Thanks

Edit: you can see the original thread here: https://www.accordionists.info/threads/learning-to-tune.6469/#post-69757
The same image of the motorbike also appears in post 12 of that thread.

 

[knobby]

I've looked at this a little more - if I edit this post then the picture in the post is supposed to be attachment 8 (see below):


If I inspect the element in Firefox it shows the following:


Anyone any idea what's going on and how I can fix it?
Thanks

EDIT: The actual picture on the original post in the restricted node is called offroad.jpg

 

[Paul B]

What is the actual attachment ID of the spreadsheet?

The poster could have just entered the wrong attachment ID when composing the post.

 

[knobby]

What is the actual attachment ID of the spreadsheet?

How do I find that out?

The poster could have just entered the wrong attachment ID when composing the post.

The attachment ID for this picture in the original post is attachment 1.

 

[Paul B]

Attachment ID doesn't exist: https://www.accordionists.info/attachments/1

How do I find that out?

The ID is the number after the period - you can edit the post to see it.

 

[knobby]

This is from the original post which contained the picture.

The ID is the number after the period - you can edit the post to see it.

Sorry, I don't understand this. If I edit the post I don't see any ID number for the spreadsheet, only the spreadsheet name.

 

[knobby]

Here is another instance further down the same thread:



This should be showing the attachment linear_bps.2.jpg not the picture shown above. If I go into edit mode I get the following:

It's calling attachment 2

 

[Paul B]

If attachment IDs are being reused then you have some level of corruption in the database.

What ID value is provided for a new attachment uploaded?

 

[knobby]

I've just added this attachment to a post a few minutes ago. There don't seem to be ID values, only the name of the attached file. Or do I need to look somewhere else for this information?