[puertoblack2003]

Originally Posted by RichieBoy67

I am working on this for the request you posted and it is different from what you posted here. His site is missing attachments mostly before a certain time, not all. He has no attachment data in posts or anything else and I do not believe his issue occurred because of an upgrade.

As for your issue I have no idea how a simple upgrade would remove your attachment data and I have already done this 4.2.3 update on about 13 or 14 sites without any attachment issues. With that said I do not believe it to be global.

Are your attachments showing in the filedata table or post table? If not they are ever going to show in your posts even if they do exist in the attachments table.

thanks for the direction to resolve my issue. I compared filedata tables with my backup from a week ago. There's a big difference, so i restored my filedata.sql and everything is back. still have some cleaning up to do.But it's back. As i said all this happened with upgrade to 4.2.3. squidsk mentioned the issue and i will monitor it.

thanks for your help

Originally Posted by squidsk

The problem is related to a bug in vb that was fixed in 4.2.3 in one of the daily cleanup scripts. The end result of the bug was that attachments that were not attached correctly were not being cleaned up as intended. Once you install 4.2.3 the daily cleanup was working correctly and those incorrectly attached attachments got deleted.

thanks for the heads up.I have to figure out as to what incorrectly attach is, so i know if my members is doing something wrong. I have attachments back in 2004 that was removed, after the upgrade.