Audit files "not in database": Re-attach files

I like this idea and have thought about it before, but audit files isn't getting much of my attention at the moment.

I'll try to get round to doing something on this at some point, but not sure when!

+1 to this request. This is currently high on my priority, and will try to see if I can contribute anything in terms of code. The reason for this is that there is a _huge_ bug in the Drupal blogapi that uploads images and attachments as part of blog publishing - but does _not_ populate the "files" table.

The way I see myself doing this is doing a foreach() search for the file name (escaped to match) in the contents of every row in the "node_revision" table (with a "limit of 1") and populate the "files" table.

Good point on the editable field - it would make manual corrections much easier.

Meanwhile, had a really bad time trying to track through the Drupal code (this is the first time I've delved into Drupal code), going on a merry-go-round through blogapi.module, upload.module, image.module, file.module, image_assist.module, node.module and everything in between trying to see where the "files" table insertion code came from (eventually found in the image.module)...

Therein lies an "issue" though; from a "narrow" point of view in regards to "Image" nodes, there appears to be different "types" in the "files" table ("_original", "thumbnail", "preview") - and these "type" names are actually stored in the "files" table.

From a simple search in attempting to manually clean up my own "files" table, it appears that some of these "thumbnail" files are larger in size than the original - so file size is _not_ the way to differentiate originals from thumbnails from previews. This may not be an issue as I have seen a "rebuild" function in the image.module - so as long as there are originals (and we can identify them), it should be something we can work around.

I did this and more, I was reminded today that I never got around to contributing it. Attached is a massive patch against HEAD, with is Drupal 6-compatible - there's no branch for 6 yet so the Version on this issue doesn't reflect the contents of the patch.

"needs work" because it doesn't scale - the reports need to be paged. But hopefully this can be helpful to people, and maybe someone can refine it.

Helps to attach the patch...

OK, I've created two branches, 6.x-2.x which is functionally equivalent to 5.x-2.x (safest way for existing users to upgraade), and 6.x-3.x for development of these new features.

Hi mikeryan,

Thanks for the hard work on this - tried installing it, and it appears that the patch doesn't contain any updates for the auditfiles.install, references.admin.inc and unreferenced.admin.inc files...

Haven't tried any functionality as yet though.

Was committed ages ago