Previous Thread
Next Thread
Print Thread
Hop To
#41226 08/01/2004 5:33 PM
Joined: Jun 2006
Posts: 73
C
journeyman
journeyman
C Offline
Joined: Jun 2006
Posts: 73
My server went down for a few minutes and started up with an incorrect date: 1969! I didn't notice it until just now, and several people have posted new topics or replies with the false date. Is there any way to correct this?

#41227 08/01/2004 5:47 PM
Joined: Jun 2006
Posts: 742
enthusiast
enthusiast
Joined: Jun 2006
Posts: 742
You'd have to put a new date:

UPDATE w3t_Posts
SET B_Posted = xxxxxxxxxxx
WHERE B_Number = yyyyy

Where I have xxxx - that's the date - in epoch time. Epoch time is the number of seconds from January 1 1970. I've got a time converter here:
http://www.joshuapettit.com/time.php

Where i have yyyy that's the post number.


Joshua Pettit
Web Developer
www.ThreadsDev.net | www.JoshuaPettit.com
#41228 08/01/2004 6:08 PM
Joined: Jun 2006
Posts: 73
C
journeyman
journeyman
C Offline
Joined: Jun 2006
Posts: 73
Thanks again Josh! That did the trick.


Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
PHP 8 bug in membermanage.tmpl
by phoenix011235 - 09/08/2026 7:47 PM
Are any of these legitmate?
by Baldeagle - 09/06/2026 1:37 PM
8.0.1 Patch Changelog Discussion
by isaac - 11/26/2025 1:34 PM
Upgraded to ver8 - now can't login
by phoenix011235 - 10/24/2024 8:50 AM
Who's Online Now
0 members (), 563 guests, and 80 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Ride safe!
Ride safe!
by Morgan, December 7
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Powered by UBB.threads™ PHP Forum Software 8.1.0
(Snapshot build 20260527)