Is this a site that was upgraded from vB3? I know there are some issues with the Scheduled Task that is supposed to remove old attachments.

No, not an upgrade, it is a 4.2.1 installation only.

The main issue is that it appears that attachments are not being recorded properly.

1. After clicking on the add photo icon, the photo is uploaded but I don't see it in the editor, what I see is attachment tags and a number..
2. I go to look at the attachments ACP and see the attachment but no name to whom the attachment was uploaded by..
3. When I open the attachment manager, I get lots of empty spaces showing pic titles but no pic.
4. After the pic has supposedly been uploaded to the forums/cms/blogs, all that is seen is a link..
If I copy the link location and edit the post, add image tags to the link, then the pic is seen..
5. When rebuilding attachment thumbs, I get error all the way through.

These attachments are lost somewhere, I don't think this is normal behaviour..

I can move the attachments from the file system to the DB and it tells me they have been moved successfully. I try to rebuild again, same result. I go to the file system, the folder is 0777 perms and the files inside the folder are 0666, not sure here either..

I have cleared the folder and then moved them again from DB to file system and again, same result..

Baffled..

--------------- Added [DATE]1386782403[/DATE] at [TIME]1386782403[/TIME] ---------------

Ok, last attempt at trying to sort this out..

Simple request...

How do I delete all attachments for sure? Even the ones that apparently have already been deleted?