Thank you very much!

Run this query for me please and pass the output here:

Code::

show variables where variable_name like '%time_zone'

Nano,

Is that an SQL query? I get a message:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where variable_name like %time_zone' at line 1

then try

Code::

show variables like '%time_zone'

That returned this:

Code::

Variable_name Value system_time_zone EDT time_zone SYSTEM

just to be sure that you updated even your languages, english from the core package and others lang from our downloads section that have been updated one month ago i think and are 9.1.2.1 compatibles

Nano,

OK - was just going to try and upgrade to the latest version 9.1.2.1 - can I just overwrite everything with the new version for an upgrade from 9.1.1? That should ensure I have the latest language files too?

There are no language changes from 9.1.1 and 9.2.1, but you are welcome to upgrade to 9.2.1 to get the latest improvements.

OK - have just upgraded my test server to the latest version - so presumably have the latest language files. Dates still showing as before...

If you still have the old db back, could you please try to do an upgrade again to see if that happen again, if that happen again add this on top of your install.php (existing code in includes/functions/language.php)

PHP:

<?php if (!setlocale(LC_TIME, 'en_US.UTF-8')) { if (!setlocale(LC_TIME, 'en_US.utf8')) { if (!setlocale(LC_TIME, 'en_US')) { if (!setlocale(LC_TIME, 'english') && PHPVERS >= 43) { setlocale(LC_TIME, array('en', 'eng', 'ISO-8859-1')); } } }}

Mm, OK. How do I get the old database back? Back up the new, insert the old? Do I need to have all my 9.0.6.1 files back in place to do the insert? This sounds like a bit of a nightmare!

No, just create a test database and put your backup in there.
Then modify config.php to connect to that database.

ok - will try this tomorrow - got to fly home from India first!

OK - I pointed config.php to a backup of the old database, recreated the install directory and php file and ran install again. It did the db update and the members all show the correct joining date.

Getting the hang of this I then exported an UPDATE query of the old users, updating the regdate with the version that had been fixed on my test database. Hey presto - all working now!

I have no idea why it didn't work before, but want to thank you guys for this. All I need to do know is update to the latest version and I'll be off and running again...

so all is working without the "setlocale()" hack previously posted by me?

yes - I just ran the update on the old database again which updated the table. I then exported the user_id and regdate fields and updated my new table. All working now with no other hack.

No idea what happened in the first place - looking at my 9.1.1 user table it had a blank entry originally for the regdate.