| Reset timestamps? [message #38103] |
Wed, 18 July 2007 19:19  |
Ernesto
Messages: 413
Registered: August 2005
Karma: 0
|
Senior Member |
add to 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.
Ginnunga Gaming
[Updated on: Wed, 18 July 2007 19:21] Report message to a moderator |
|
|
|
|
|
|
|
| Re: Reset timestamps? [message #38178 is a reply to message #38103] |
Mon, 23 July 2007 06:49  |
Ernesto
Messages: 413
Registered: August 2005
Karma: 0
|
Senior Member |
add to 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?
Ginnunga Gaming
|
|
|
|
|
|
Calendar
Search
Help
Members
Control Panel
Logout [ CommonCrawl [Bot] ]
Home
]