FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum » How To » Reset timestamps? (Had wrong servertime after a forum move)
Show: Today's Messages :: Unread Messages :: Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
Message by Ernesto is ignored  [reveal message]  [reveal all messages by Ernesto]  [stop ignoring this user] Go to next message
Message by Ernesto is ignored  [reveal message]  [reveal all messages by Ernesto]  [stop ignoring this user] Go to previous messageGo to next message
Re: Reset timestamps? [message #38166 is a reply to message #38104] Sun, 22 July 2007 15:42 Go to previous messageGo to next message
Ilia is currently offline  Ilia   
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
remove from buddy list
ignore all messages by this user
Time being wrong usually is a problem on the server because the server's time is done. You can fix that but running ntp command and synchronizing server time from some reliable time server.

FUDforum Core Developer
Re: Reset timestamps? [message #38178 is a reply to message #38103] Mon, 23 July 2007 06:49 Go to previous messageGo to next message
Ernesto is currently offline  Ernesto   Sweden
Messages: 413
Registered: August 2005
Karma: 0
Senior Member
remove from buddy list
stop ignoring messages by this user
Sorry, I did not explain correctly:
After moving the forum to a new server, the servers internal hardware clock was wrong, so we corrected it by your above suggested method. However, since the forum had been running a little while with the wrong servertime, the forums timestamps for last read / unread got messed up when we corrected the serverstamp. so for one hour, noone could see if they had read posts, nor mark then as read, nor did new posts show up as unread for that period of time.

So, what if the servertime would have been years off, how would I have corrected the issue with the timestamps in the forum then? Where are they stored, in which table, what would be the easiest way?


Re: Reset timestamps? [message #38187 is a reply to message #38178] Mon, 23 July 2007 19:06 Go to previous message
Ilia is currently offline  Ilia   
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
remove from buddy list
ignore all messages by this user
The timestamps for messages are stored inside msg table, in the post_stamp field. You'd need to update the table and then run the consistency checker.

FUDforum Core Developer
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: Global configuration rollback
Next Topic: How to add a user that can view only single forum?
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jan 27 22:14:20 EST 2022

Total time taken to generate the page: 0.00852 seconds