FCPX file relink 'new file is not long enough' + wrong project

I'm having a problem when I relink some (not all) files on FCXP. Firstly if I select the clip and relink by pointing to an entire folder of files it relinks to a clip that doesn't even exist in that folder, if I then try to resolve this by relinking and picking the exact clip I receive this message

'The new file is not long enough to cover clip Clip 10 in event Looking at Rose'

Bizarrely the event it refers to is not the event I am working on, it is the event that this wrong clip is from.

To summarise: I have multiple events, in one event I am relinking a file and if I point to an entire folder of footage it relinks to Clip 10 that doesn't exist in that folder, if I relink by pointing at the exact file I want Clip 22 then it seems to think I am working on the event that contains Clip 10.

How do I fix this without having to delete the clip entirely?