my problem is close to this so Ill post here. After upgrade to 9.1.1 all new members joined date is Dec 31, 1969

not connected to the topic you tacked onto - that was a formatting issue.

any ideal on how i fix it.

That date means that zero or no data is being entered at registration.

Hard to say why - you need to check the registration and approval process with debugging switched on to determine where that error is occuring.

I would be surprised if there was a system bug, so maybe you have unresolved issues in your database, or even incorrect files.

I have this same problem - all dates were showing correctly in 9.0.6.1 but since the upgrade dates for existing members in the Members List page are showing as Dec 31, 1969. New members show correctly. Interestingly on the Your Account page for old members the date shows correctly only with no year.

Some change has obviously been made to the date format. Is there some file I need to change?

an _users* tables structure dump + an "old user" row dump will be useful in this case.

Nano,

I have attached a zip of the tables structure, one for the old database (9.0.6.1) and one for 9.1.1, along with one line of data from the old table.

Table_new_user.txt is missing the "data" ... what will help me will be "current" data for second userid and for the last user.

I recall something about phpnuke upgrades to dragonfly leaving the date in a non-unix format. So when those fields were converted to int(11) from var (or whatever they used to be). You used to be able to read them as plain text in the db.

I remember having to manually convert a lot of dates to unix date format - but that was 1-2 years ago.

Nano,

I've attached a file with a dump of the 2nd and the latest user. In my members list the 2nd user shows as having joined on Dec31, 1969 in the members' list whilst the last has the correct date (March this year).

could you pass here the output of

PHP:

echo setlocale(LC_ALL, NULL);

Gives:

C

No idea what that means!

Before go deeper into this ... is your problem showing up using "english" language? Is it the same for other languages as well?

Same in French and English

PS Congrats on the grandson! You'll be digging out the camera again!