XF 2.2 How to delete old attachments in posts?

[Katorakte]

Hello,
recently migrated from vB4 to XF 2.2.
We have some attachments throwing out 404 errors.How may i delete them from posts ?

 

[Katorakte]

I have tried to replace the attachment codes via command :
UPDATE xf_post SET message = REPLACE(message, 'x', 'y');

but it didnt work.
Attachment codes in "table posts" are replaced correctly in db but when viewing posts in forum we still see the old codes.

Any other solutions ?

 

[VBX Co]

I have tried to replace the attachment codes via command :
UPDATE xf_post SET message = REPLACE(message, 'x', 'y');

but it didnt work.
Attachment codes in "table posts" are replaced correctly in db but when viewing posts in forum we still see the old codes.

Any other solutions ?

Replace is case sensitive - are there any variations in the case of the code snippets you're trying to replace?

 

[Katorakte]

Actually the attachment codes are replaced in db :




But that change is not reflected in posts :