Previous Thread
Next Thread
Print Thread
Hop To
#41226 08/01/2004 9: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 9: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 10: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
Having issues going from 7.5.5. to 8X
by Mors - 10/22/2026 5:32 PM
Slow Queries - Any Ideas?
by BellaOnline - 10/16/2026 8:34 PM
Selling a Forum?
by ECNet - 10/10/2026 2:54 PM
Who's Online Now
0 members (), 592 guests, and 120 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 20261026)