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 :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
Reset timestamps? [message #38103] Wed, 18 July 2007 19:19 Go to next message
Ernesto is currently offline  Ernesto   Sweden
Messages: 413
Registered: August 2005
Karma: 0
Senior Member
remove from buddy list
ignore all messages by this user
After moving the forum, the servertime was way off, and I THINK due to that, all the "mark as read" etc are not working correctly due to incorrect timestamps, so no users can see properly which are new posts or not.

Is there a way to reset that timestamp? (I think that was the thing that causes this problem?)

I ran the consistency checker and the mysql optimizer, but it doesnt seem to work.

I tried searching, but I cant find it.


[Updated on: Wed, 18 July 2007 19:21]

Report message to a moderator

Re: Reset timestamps? [message #38104 is a reply to message #38103] Wed, 18 July 2007 19:23 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
ignore all messages by this user
Clock caught up just now, so the problem solved itself, but it would still be nice with an answer if it happens in the future =)

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
add to 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
ignore all 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
add to 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: Mon Feb 17 06:17:55 EST 2020

Total time taken to generate the page: 0.00644 seconds