Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 08 Jul 2015, 05:05
puertoblack2003's Avatar
puertoblack2003 puertoblack2003 is offline
 
Join Date: Aug 2005
Attachment Issues After Upgrade

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
__________________
Android Custom Creations
Reply With Quote
  #2  
Old 08 Jul 2015, 05:54
RichieBoy67's Avatar
RichieBoy67 RichieBoy67 is offline
 
Join Date: Apr 2004
Real name: Richie
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?
__________________

Let us take care of your forum, seo, seo reports, maintenance, what ever you need.

Reply With Quote
  #3  
Old 08 Jul 2015, 06:01
puertoblack2003's Avatar
puertoblack2003 puertoblack2003 is offline
 
Join Date: Aug 2005
Originally Posted by RichieBoy67 View Post
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
__________________
Android Custom Creations

Last edited by puertoblack2003; 09 Jul 2015 at 05:13.
Reply With Quote
  #4  
Old 15 Jul 2015, 04:50
puertoblack2003's Avatar
puertoblack2003 puertoblack2003 is offline
 
Join Date: Aug 2005
not sure if this is a global issue with other users but in this post http://www.vbulletin.org/forum/showt...45#post2550145 he apparently has the same issue as me.
__________________
Android Custom Creations
Reply With Quote
  #5  
Old 15 Jul 2015, 05:35
RichieBoy67's Avatar
RichieBoy67 RichieBoy67 is offline
 
Join Date: Apr 2004
Real name: Richie
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.
__________________

Let us take care of your forum, seo, seo reports, maintenance, what ever you need.


Last edited by RichieBoy67; 15 Jul 2015 at 06:20.
Reply With Quote
  #6  
Old 15 Jul 2015, 16:52
squidsk's Avatar
squidsk squidsk is offline
 
Join Date: Nov 2010
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.
Reply With Quote
  #7  
Old 15 Jul 2015, 17:33
puertoblack2003's Avatar
puertoblack2003 puertoblack2003 is offline
 
Join Date: Aug 2005
Originally Posted by RichieBoy67 View Post
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 View Post
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.
__________________
Android Custom Creations
Reply With Quote
  #8  
Old 15 Jul 2015, 18:12
RichieBoy67's Avatar
RichieBoy67 RichieBoy67 is offline
 
Join Date: Apr 2004
Real name: Richie
Originally Posted by squidsk View Post
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?
__________________

Let us take care of your forum, seo, seo reports, maintenance, what ever you need.

Reply With Quote
  #9  
Old 11 Aug 2015, 06:41
TexArkana TexArkana is offline
 
Join Date: Mar 2007
Originally Posted by RichieBoy67 View Post
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.
Reply With Quote
  #10  
Old 11 Aug 2015, 18:09
RichieBoy67's Avatar
RichieBoy67 RichieBoy67 is offline
 
Join Date: Apr 2004
Real name: Richie
Originally Posted by TexArkana View Post
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.
__________________

Let us take care of your forum, seo, seo reports, maintenance, what ever you need.

Reply With Quote
  #11  
Old 11 Aug 2015, 20:34
squidsk's Avatar
squidsk squidsk is offline
 
Join Date: Nov 2010
Sorry forgot about this thread. Here's the link to the article that describes incorrectly attached attachments.

http://experienced-people.net/forums...chment-Problem


This becomes a problem due to the bug in versions pre 4.2.3 as described here. You'll need to be logged into vb.com to see the issue in the tracker. Basically invalid attachments were not deleted, so looked valid, but once you upgraded to 4.2.3 all those invalid attachments that had not been deleted all of a sudden get deleted in one fell swoop and it looks like you lost a tonne of attachments.
Reply With Quote
  #12  
Old 11 Aug 2015, 20:50
puertoblack2003's Avatar
puertoblack2003 puertoblack2003 is offline
 
Join Date: Aug 2005
Originally Posted by squidsk View Post
Sorry forgot about this thread. Here's the link to the article that describes incorrectly attached attachments.

http://experienced-people.net/forums...chment-Problem


This becomes a problem due to the bug in versions pre 4.2.3 as described here. You'll need to be logged into vb.com to see the issue in the tracker. Basically invalid attachments were not deleted, so looked valid, but once you upgraded to 4.2.3 all those invalid attachments that had not been deleted all of a sudden get deleted in one fell swoop and it looks like you lost a tonne of attachments.
thanks for additional info. I will monitor this for future upgrade, thankfully i always do backups.
__________________
Android Custom Creations
Reply With Quote
  #13  
Old 09 Dec 2015, 19:21
ArjanL ArjanL is offline
 
Join Date: Mar 2015
A bump, but maybe a clue for people converting.
I lost over 9000 attachments due to this, only the last 35 or so attachments were present. And actually I think it is a bug in the upgrade script. I upgraded from 3.8.9 to 4.2.3.
Some time later all my attachments were gone.

So, I did a new upgrade andpayed attention to the two known tables.
What I noticed that for all attachments but the last couple, the fields for height width and refcount had no value or "0" actually.
So, it seems to me that not all records are updated correctly in the upgrade process.
EDIT: Reason for this opinion: For the records missing the Refcount data, also the height and width fields contained no data, wehre the ones that did have a Refcount, also had a value in this field.

For who is planning an upgrade:
For this problem you can just go ahead. But disable the "Hourly Cleanup 2" first thing after the upgrade, and do not run update counters. Set the refcount to 1 as described here: https://www.vbulletin.org/forum/showthread.php?t=320246

Then you can enable the disabled task again. And do all other things you have to do after the upgrade.

Last edited by ArjanL; 09 Dec 2015 at 19:57.
Reply With Quote
  #14  
Old 10 Dec 2015, 17:52
squidsk's Avatar
squidsk squidsk is offline
 
Join Date: Nov 2010
Originally Posted by ArjanL View Post
A bump, but maybe a clue for people converting.
I lost over 9000 attachments due to this, only the last 35 or so attachments were present. And actually I think it is a bug in the upgrade script. I upgraded from 3.8.9 to 4.2.3.
Some time later all my attachments were gone.

So, I did a new upgrade andpayed attention to the two known tables.
What I noticed that for all attachments but the last couple, the fields for height width and refcount had no value or "0" actually.
So, it seems to me that not all records are updated correctly in the upgrade process.
EDIT: Reason for this opinion: For the records missing the Refcount data, also the height and width fields contained no data, wehre the ones that did have a Refcount, also had a value in this field.
My only comment on this is that it isn't anything in the upgrade script for 4.2.3 since that script does not touch the filedata table. The data is already corrupt in the table before the upgrade, it's just that the upgrade actually reveals the problem because filedata is actually being deleted.

For who is planning an upgrade:
For this problem you can just go ahead. But disable the "Hourly Cleanup 2" first thing after the upgrade, and do not run update counters. Set the refcount to 1 as described here: https://www.vbulletin.org/forum/showthread.php?t=320246

Then you can enable the disabled task again. And do all other things you have to do after the upgrade.
Actually at this point I'd just hold out for a bit until 4.2.4 is released as it fixes the issue with corrupt refcounts in the filedata table.
Reply With Quote
  #15  
Old 10 Dec 2015, 18:52
ArjanL ArjanL is offline
 
Join Date: Mar 2015
Originally Posted by squidsk View Post
My only comment on this is that it isn't anything in the upgrade script for 4.2.3 since that script does not touch the filedata table. The data is already corrupt in the table before the upgrade, it's just that the upgrade actually reveals the problem because filedata is actually being deleted.
In that case I am curious what does make the tabel, because it isn't in my 3.8.8 database....
Anyway, whatever creates or updates that database, does not set all refcounts and width and height fields, but in my case only the last 34. And I am able to reprodues that over and over again by upgrading the database from 3.8.8 to 4.2.3
This because vB support just told me that doing the upgrade again would fix my problem, not telling that the Refcount and cleanup job were the actual problem.

Originally Posted by squidsk View Post
Actually at this point I'd just hold out for a bit until 4.2.4 is released as it fixes the issue with corrupt refcounts in the filedata table.
Lets hope it fixes the missing height and width fields as well, because, then though I have my attachments back, they do not show up in the messages itself, due to the missing height and width data. vB support confirmed that the missing height and width data is the cause of that problem. Unfortunately they were not able to supply a fix for it.
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 04:11.

Layout Options | Width: Wide Color: