[support] File Attachment Maintenace

[Chris McKeever]

a litle more info after some testing...

The 'magic' connector between files and nodes is through the
file_revisions table.
So I can figure out why some files get listed and some do not.

The next issue now is, why when I delete a file from the admin
interface, the revision history gets deleted from the table, but the
'file' table entry does not get deleted, nor does the file within in
filesystem ?

I am running this as the admin account, the permissions of the
filesystem allow the creation as the apache user, but it isnt
deleting.

Thanks


On 3/14/07, Chris McKeever <cgmckeever at gmail.com> wrote:
> I deleted a file from the node that it was uploaded to, however, it
> still exists in the /files directory.
>
> Looking at the SQL schema, it appears that the file sitll has an entry
> in the 'files' table, however it doesnt appear to be listed on the
> node.
>
> I haven't found the magic trick which tells drupal that a file has
> been removed from a node...
>
> So --
>
> A) are files supposed to be purged once they are deleted from the node?
> B) how does the node know which file to list - is there a bit field somewhere?
>
> Thanks
>