The Arcive of Official vBulletin Modifications Site.

SnapOff Racing · #1 07-28-2009, 08:17 PM

OK I dunno wtf happened but today when I got up the date on my forum said July 29 when in reality today is the 28th. I checked the server and it had the incorrect date. Not really sure how the hell this happened but I did see that windows did update the date and time last night so I'm thinking that must have caused it to be incorrect. Perhaps there was an issue with the time server or something I dunno.

In any case now I have a fixed the issue but now all the posts that were made today BEFORE I fixed the issue all show TOMORROWS date. So now that the issue is fixed whenever someone makes a post in a thread that had the incorrect date, their post goes to the top of the thread.

How can I fix this issue aside from manually editing the dateline of every single thread and post that has the incorrect date. Is there perhaps a script that I can run that will subtract 86,400 seconds (24 hours) from all the posts/threads that have the incorrect date?

Any ideas? I have disabled my forum right now until I can get this issue resolved.

Lynne · #2 07-28-2009, 08:22 PM

Quote:

Originally Posted by SnapOff Racing

How can I fix this issue aside from manually editing the dateline of every single thread and post that has the incorrect date. Is there perhaps a script that I can run that will subtract 86,400 seconds (24 hours) from all the posts/threads that have the incorrect date?

When this happened on my site once, I actually did go in and manually change the posts. I tried to only do the ones that were important (like the first post in a thread). I suppose if you went into the database, you could get the postid range for the incorrect time posts and then run a query that only effects the posts within that range. I think I went in and temporarily change the time between posts and the time between searches limits for the day.

SnapOff Racing · #3 07-28-2009, 08:35 PM

OMG this is going to really suck! I'm about to just revert to the last saved backup that I have which is from like 10 hours ago but I really don't wanna do that either

Anymore ideas from anyone else who has been in similar situations?

Marco van Herwaarden · #4 07-30-2009, 10:32 AM

I doubt anything can be done anymore as the current date-time already catched up with the bad date-time yesterday. Therefor you can not see the difference anymore between posts made yesterday and today.

Next time it is better to leave the server time incorrect until you have found a way to correct the posts made (which is possible).

SnapOff Racing · #5 09-13-2009, 09:23 AM

Yeah your right about that cause I ended up running an sql query that was able to subtract 86400 seconds from all my threads, posts, and joindate's. But since I had already manually edited a lot of them I had to go back and re-manually edit them again. So your definitely right about just leaving it like it is and then doing the entire database all at once.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.03624 seconds Memory Usage 2,188KB Queries Executed 11 (?)
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 (1)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)navbar (3)navbar_link (120)option (5)post_thanks_box (5)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (5)post_thanks_postbit_info (5)postbit (5)postbit_onlinestatus (5)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_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 post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

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