Dates all messed up... [message #5204] |
Fri, 23 August 2002 05:17 |
aitrus
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 |
Ilia
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
|
|
|