vb.org Archive - incorrect date

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)

- - incorrect date (https://vborg.vbsupport.ru/showthread.php?t=323025)

chikuru

07-13-2016 02:31 PM

incorrect date

We recently move to a new server, and the date is incorrect. Now the posts(possible other data as well like PM, etc) have incorrect dates (but correct time)

How can we correct it using db query?
The date is 2 days advanced.. Its still incorrect at the moment..

Thanks!

Dragonsys

07-13-2016 02:51 PM

Quote:

Originally Posted by chikuru (Post 2573191)

Sounds like your new server has the wrong date set. Ask your server support and have them verify the serve date/time is correct, and what timezone it is set to, then adjust your Forums Date and Time settings accordingly.

Dave	07-13-2016 02:57 PM

If you're on a VPS/dedicated server, tell your host or whoever manages the server to setup a NTP client with the right timezone.

RichieBoy67

07-13-2016 03:04 PM

What is your server? Dedicated?

chikuru

07-14-2016 05:04 AM

Its a dedicated server.
Do I need to do anything from the database?
After I fix the server date, the dates in the forum is still correct like the thread date.. So I immediately reverted the settings and let the incorrect date remain until we have the right solution..

--------------- Added [DATE]1468514759[/DATE] at [TIME]1468514759[/TIME] ---------------

Quote:

Originally Posted by Dragonsys (Post 2573195)

what adjustments do i need to do in the forums?

--------------- Added [DATE]1468547820[/DATE] at [TIME]1468547820[/TIME] ---------------

UP.
Anyone?

Skyrider

07-18-2016 08:29 PM

Quote:

Originally Posted by chikuru (Post 2573234)

/admincp/options.php?do=options&dogroup=datetime

Take a look at Default Time Zone Offset option.

Lynne

07-19-2016 12:15 AM

If you fix the time on the server, it doesn't fix the time in the database since the database got it's time from the server originally. It will only fix the time on any posts made after you fixed the time on the server.

chikuru

07-19-2016 09:00 AM

Quote:

Originally Posted by Skyrider (Post 2573413)

/admincp/options.php?do=options&dogroup=datetime

Take a look at Default Time Zone Offset option.

Its GMT+10 Eastern Australia. What should I take note about it?

Quote:

Originally Posted by Lynne (Post 2573419)

Yes you are right.
Can you give me the database query to fix the incorrect date in the database?

All post from July 07 2016 to latest post should have minus 4 days date.
The time should remain the same..

All times are GMT. The time now is 07:59 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.03415 seconds Memory Usage 1,736KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (5)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (8)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.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 printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: