Eliminating Missing Attachments

[Lynne]

The problem with doing that is that it could cause issues with the filedata table. Every attachment has an attachment.filedataid field which links it to the filedata table. Every row in the filedata table has a refcount (the number of attachments that use that item) and you are doing nothing to remove the row in the filedata table (if it needs to be removed - if the refcount was 1 and then you remove the attachment, then the filedata row needs to be removed).

[Allthumbz]

The problem with doing that is that it could cause issues with the filedata table. Every attachment has an attachment.filedataid field which links it to the filedata table. Every row in the filedata table has a refcount (the number of attachments that use that item) and you are doing nothing to remove the row in the filedata table (if it needs to be removed - if the refcount was 1 and then you remove the attachment, then the filedata row needs to be removed).

That sounds very complicated for a non-SQL database person like me, is there any way for you to walk me through it, or should I just give up trying to delete the images this way?

Nelson

[Andy]

As Lynne pointed out the filedata table will have orphaned rows if you delete rows in the attachment table, I don't believe this will cause any problems though.

A simple query can be used to delete orphaned rows in the filedata table.

[Allthumbz]

As Lynne pointed out the filedata table will have orphaned rows if you delete rows in the attachment table, I don't believe this will cause any problems though.

A simple query can be used to delete orphaned rows in the filedata table.

Simple for you, unknown for me. I'm ignorant of SQL so if it takes more than deleting the attachment row in the database, I guess I should give it. I just thought it would be healthier for the database to eliminate thesemissing attachment errors.


Nelson

[Hartmut]

If you are not common with what has been written here regarding SQL queries, you should not try it yourself. Leaving this as it is will be no problem for the system.

[Allthumbz]

If you are not common with what has been written here regarding SQL queries, you should not try it yourself. Leaving this as it is will be no problem for the system.

Agreed, I cannot do the "simple" inquiry myself, so I had better leave it alone to prevent a disaster (although I DO back up each day!).

[Allthumbz]

Maybe one of you experts can help us out with a mod that does this. I will make a suggestion.