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
Version 7.7.5 Images suddenly not displaying
by Stovebolt - 05/04/2024 11:19 AM
Bots
by Outdoorking - 04/13/2024 5:08 PM
Can you add html to language files?
by Baldeagle - 04/07/2024 2:41 PM
Do I need to rebuild my database?
by Baldeagle - 04/07/2024 2:58 AM
This is not a bug, but a suggestion
by Baldeagle - 04/05/2024 11:25 PM
Who's Online Now
1 members (1 invisible), 939 guests, and 146 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20240501)