UBB.threads PHP Forum Software Community Forums UBB.threads 7 Bug Reports Non Bugs Post dates and Forum Join Dates all screwy

On my forum summery:

As my Reg date:

I didn't change the default date display.

That may be the problem. Need to knoww what you have for your default date format and probably your list of available formats just to be safe.

Default:
m/d/y | h:i A

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

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

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

x is your userid.

ok, so run this since my id is 2:

select USER_TIME_FORMAT from USER_PROFILE where USER_ID = 2

--

Ok, I ran it and got this:


This was a new install when we wnet to the first version of Beta

Bleh, forgot the table prefix:

select USER_TIME_FORMAT from ubbt_USER_PROFILE where USER_ID = x

Was this an upgrade or did you do a fresh install? And nope, still can't get to your site, just get a timeout.

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

Well, it wasn't supposed to fix it I was looking for what you got back when running that query.

oh.. lol!

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:


but should look like:

I have no problem installing over again. I'll do that tonight. New database and all.

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