Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 13 Jul 2016, 16:31
chikuru chikuru is offline
 
Join Date: Nov 2011
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!
Reply With Quote
  #2  
Old 13 Jul 2016, 16:51
Dragonsys's Avatar
Dragonsys Dragonsys is offline
 
Join Date: Jan 2008
Real name: Eric
Originally Posted by chikuru View Post
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.
Reply With Quote
  #3  
Old 13 Jul 2016, 16:57
Dave Dave is offline
 
Join Date: Jun 2010
Real name: 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.
__________________
https://technidev.com - security, development, exploits, vBulletin
dave[at]technidev[dot]com

Contact me for custom vBulletin 3/4 work & server/website management.
Reply With Quote
  #4  
Old 13 Jul 2016, 17:04
RichieBoy67's Avatar
RichieBoy67 RichieBoy67 is offline
 
Join Date: Apr 2004
Real name: Richie
What is your server? Dedicated?
__________________

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

Reply With Quote
  #5  
Old 14 Jul 2016, 07:04
chikuru chikuru is offline
 
Join Date: Nov 2011
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 View Post
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?
Reply With Quote
  #6  
Old 18 Jul 2016, 22:29
Skyrider Skyrider is offline
 
Join Date: Feb 2006
Originally Posted by chikuru View Post
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.
Reply With Quote
  #7  
Old 19 Jul 2016, 02:15
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: 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.
__________________
Former vBulletin.org Staff Member

Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
  #8  
Old 19 Jul 2016, 11:00
chikuru chikuru is offline
 
Join Date: Nov 2011
Originally Posted by Skyrider View Post
/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 View Post
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..
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 08:29.

Layout Options | Width: Wide Color: