The Arcive of Official vBulletin Modifications Site.

puertoblack2003 · #1 07-08-2015, 02:05 AM

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 · #2 07-08-2015, 02:54 AM

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 · #3 07-08-2015, 03:01 AM

Quote:

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 · #4 07-15-2015, 01:50 AM

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 · #5 07-15-2015, 02:35 AM

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 · #6 07-15-2015, 01:52 PM

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 · #7 07-15-2015, 02:33 PM

Quote:

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

Quote:

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 · #8 07-15-2015, 03:12 PM

Quote:

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 · #9 08-11-2015, 03:41 AM

Quote:

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 · #10 08-11-2015, 03:09 PM

Quote:

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.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04936 seconds Memory Usage 2,276KB Queries Executed 13 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)ad_showthread_firstpost (1)ad_showthread_firstpost_sig (1)ad_showthread_firstpost_start (6)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)navbar (3)navbar_link (120)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (10)post_thanks_box (3)post_thanks_box_bit (10)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (3)post_thanks_postbit (10)post_thanks_postbit_info (10)postbit (10)postbit_onlinestatus (10)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_postinfo_query fetch_postinfo fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start fetch_musername post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start post_thanks_function_fetch_thanks_bit_start post_thanks_function_show_thanks_date_start post_thanks_function_show_thanks_date_end post_thanks_function_fetch_thanks_bit_end post_thanks_function_fetch_post_thanks_template_start post_thanks_function_fetch_post_thanks_template_end pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

Благодарность от:
puertoblack2003

Благодарность от:
puertoblack2003

Благодарность от:
RichieBoy67

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!