Attachment Issues After Upgrade

[puertoblack2003]

I upgraded last Friday to the latest version.I have never had this issue before.Until one of my forum members pm m,e that they were unable to download a file.That i had already uploaded.When i checked the thread, the file is missing.I though it'll be a database issue. So i checked the file number and it's in the database.I have about 27 gig of attachments.When i tried and rebuild attachment, It only rebuild one photo that i uploaded on Sunday.

So, how can i resolve this issue. Database structure is fine with all attachment listed. File structure points to where i have selected it. Not sure where else to go to fix it.

T.I.A

[RichieBoy67]

Would you mind posting the link?

27gigs is a ton of attachments to be serving from your database. The file system is much better, faster, etc for attachment storage i think.

What version of php and mysql do you have?

[puertoblack2003]

Originally Posted by RichieBoy67

Would you mind posting the link?

27gigs is a ton of attachments to be serving from your database. The file system is much better, faster, etc for attachment storage i think.

What version of php and mysql do you have?

i should have mentioned file system, which I'm on.I checked the db thinking it was wiped.


php-5.5.26
mysql - 5.6.25

site

[puertoblack2003]

not sure if this is a global issue with other users but in this post https://vborg.vbsupport.ru/showthrea...45#post2550145 he apparently has the same issue as me.

[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.

[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.

[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.

[RichieBoy67]

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 information but what exactly do you mean by incorrectly attached? Are you sure this is a bug and is this listed?

[TexArkana]

Originally Posted by RichieBoy67

Thanks for the information but what exactly do you mean by incorrectly attached? Are you sure this is a bug and is this listed?

Did you ever find out what was meant by incorrectly attached? We seem to be experiencing a similar problem.

Thanks.

[RichieBoy67]

Originally Posted by TexArkana

Did you ever find out what was meant by incorrectly attached? We seem to be experiencing a similar problem.

Thanks.

In this case this was not the issue as his attachments were lost before he did the upgrade. I suspect someone pruned them.