[chikuru]

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]

Originally Posted by chikuru

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!

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]

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]

What is your server? Dedicated?

[chikuru]

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 14 Jul 2016 at 16:45 ---------------

Originally Posted by Dragonsys

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.

what adjustments do i need to do in the forums?

--------------- Added 15 Jul 2016 at 01:57 ---------------

UP.
Anyone?

[Skyrider]

Originally Posted by chikuru

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 14 Jul 2016 at 16:45 ---------------



what adjustments do i need to do in the forums?

--------------- Added 15 Jul 2016 at 01:57 ---------------

UP.
Anyone?

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

Take a look at Default Time Zone Offset option.

[Lynne]

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]

Originally Posted by Skyrider

/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?

Originally Posted by Lynne

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.

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