FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum » FUDforum Installation Issues » Dates all messed up...
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
Dates all messed up... [message #5204] Fri, 23 August 2002 05:17 Go to next message
aitrus is currently offline  aitrus   United States
Messages: 8
Registered: August 2002
Karma: 0
Junior Member
I recently converted from phpBB2 to FUD, and a good portion of my post dates now say December <something> of 2010. Now, I realize that I can't have the original date back, but is there an easy way to go through and at least reset the dates to today's date or something like that so that new posts appear at the beginning instead of the old posts with the 2010 date?

j
Re: Dates all messed up... [message #5212 is a reply to message #5204] Fri, 23 August 2002 11:39 Go to previous message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
UPDATE {SQL_TABLE_PREFIX}msg SET post_stamp={UNIX_TIMESTAMP} WHERE post_stamp>1262322060;
After running this query (change the data in {}) run the consistency checker, that'll take care of the problem.


FUDforum Core Developer
  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: Every account has been blocked from posting
Next Topic: instructions for installing in safe_mode?
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Nov 06 21:32:46 GMT 2024

Total time taken to generate the page: 0.02406 seconds