_________________________ Stilgar Are you ready for 7.3? "Yes, ladies and gentlemen, this is occasionally a fly-by-the-seat-of-your-pants operation. That is the designed behavior." - CC
Available: d/m/y | h:i A y/m/d | h:i A d/m/Y | H:i D M d Y | h:i A m/d/y | h:i A Y-m-d H:i:s
_________________________ Stilgar Are you ready for 7.3? "Yes, ladies and gentlemen, this is occasionally a fly-by-the-seat-of-your-pants operation. That is the designed behavior." - CC
#811 - 06/26/0611:33 AMRe: Post dates and Forum Join Dates all screwy
[Re: Stilgar]
Rick
Registered: 06/04/06
Posts: 7993
Loc: Aberdeen, WA
Ok, couple of things. Not causing your problem but your last date type is missing the |
Y-m-d H:i:s
Should be:
Y-m-d | H:i:s
as for your actual problem. I'd say your preference is using an old format from an earlier alpha before the date changes. Try going in and updating your preferences.
ok, changed that last date code. Change my defualt format. Even cleared cache. Still ahving the problem. Also inside a topic I am having the same thing happen. :s
_________________________ Stilgar Are you ready for 7.3? "Yes, ladies and gentlemen, this is occasionally a fly-by-the-seat-of-your-pants operation. That is the designed behavior." - CC
#813 - 06/26/0611:57 AMRe: Post dates and Forum Join Dates all screwy
[Re: Stilgar]
Rick
Registered: 06/04/06
Posts: 7993
Loc: Aberdeen, WA
You've got some goofy time format somewhere since it's starting off as the actual printed day, which is "l" for the php date format and it's not even in your list of dates.
I can't get to your site right now. Was this a fresh install or an upgrade from an earlier alpha. If it's an upgrade I'm guessing you forgot to run one of the altertables that expanded the date field
Run this DB query:
select USER_TIME_FORMAT from USER_PROFILE where USER_ID = x
This was a new install when we wnet to the first version of Beta
Edited by Stilgar (06/26/0612:03 PM)
_________________________ Stilgar Are you ready for 7.3? "Yes, ladies and gentlemen, this is occasionally a fly-by-the-seat-of-your-pants operation. That is the designed behavior." - CC
Ok, I ran it. Didn't fix the problem as far as I can tell. All new posts have the date formatted correctly, but the first posts do not and the Reg dates are still buggered.
No idea why the site is timing out. I'm getting to it with no problem.
This was a new install from the first Beta release
Edited by Stilgar (06/26/0612:10 PM)
_________________________ Stilgar Are you ready for 7.3? "Yes, ladies and gentlemen, this is occasionally a fly-by-the-seat-of-your-pants operation. That is the designed behavior." - CC
_________________________ Stilgar Are you ready for 7.3? "Yes, ladies and gentlemen, this is occasionally a fly-by-the-seat-of-your-pants operation. That is the designed behavior." - CC
#819 - 06/26/0612:22 PMRe: Post dates and Forum Join Dates all screwy
[Re: Stilgar]
Rick
Registered: 06/04/06
Posts: 7993
Loc: Aberdeen, WA
ok, well..I hate to break it to ya.....but there's no way that this was a fresh install. Maybe the code was uploaded but the database isn't new. You've got a date format prefence that hasn't been used since like alpha 5 or something like that.
Somewhere along the line you musta missed something. You should be able to fix it by going into your profile and choosing a different time format. Run that query afterwards again to make sure that it changed.
FYI, it might be easier to do a brand new install on a clean database
Yep, thanks. That fixed it. Another thing, on the Reg date in the User's Profile, it looks like this:
Quote:
Registered on:06/14/06 03:18 PM
but should look like:
Quote:
Registered on: 06/14/06 03:18 PM
I have no problem installing over again. I'll do that tonight. New database and all.
_________________________ Stilgar Are you ready for 7.3? "Yes, ladies and gentlemen, this is occasionally a fly-by-the-seat-of-your-pants operation. That is the designed behavior." - CC
Just throwing this out there, since I don't have the importer in front of me.
Rick, are you converting the old time preference to the new time preference when you do the import? It's possible that you just imported them as is and that's how he got "long" in his profile