| 1 |
On 09/21/14 09:40, Mick wrote: |
| 2 |
>On Sunday 21 Sep 2014 07:11:15 J. Roeleveld wrote: |
| 3 |
>> On 21 September 2014 07:33:43 CEST, Joseph <syscon780@×××××.com> wrote: |
| 4 |
>> >After recent upgrade my Orders in OsCommerce program date look funny: |
| 5 |
>> >"2014-0" |
| 6 |
>> > |
| 7 |
>> >I downgraded mysql to 5.1.70 but this is caused by it. |
| 8 |
>> > |
| 9 |
>> >I've two PHP installed: 5.3 and 5.5 |
| 10 |
>> >I tried switching to 5.3 it still the same date display "2014-0" |
| 11 |
>> |
| 12 |
>> What do you see when querying using native tools? |
| 13 |
> |
| 14 |
>Have you made any changes in your locale? I would think that this is not an |
| 15 |
>application specific setting, but picked up from your env. |
| 16 |
>-- |
| 17 |
>Regards, |
| 18 |
>Mick |
| 19 |
|
| 20 |
I think you are correct, some setting had changed but I don't know which. |
| 21 |
My locale as root: |
| 22 |
# locale -a |
| 23 |
C |
| 24 |
en_US |
| 25 |
en_US.iso88591 |
| 26 |
en_US.utf8 |
| 27 |
POSIX |
| 28 |
|
| 29 |
user: |
| 30 |
$ locale |
| 31 |
LANG=en_US.UTF-8 |
| 32 |
LC_CTYPE="en_US.UTF-8" |
| 33 |
LC_NUMERIC="en_US.UTF-8" |
| 34 |
LC_TIME="en_US.UTF-8" |
| 35 |
LC_COLLATE="en_US.UTF-8" |
| 36 |
LC_MONETARY="en_US.UTF-8" |
| 37 |
LC_MESSAGES="en_US.UTF-8" |
| 38 |
LC_PAPER="en_US.UTF-8" |
| 39 |
LC_NAME="en_US.UTF-8" |
| 40 |
LC_ADDRESS="en_US.UTF-8" |
| 41 |
LC_TELEPHONE="en_US.UTF-8" |
| 42 |
LC_MEASUREMENT="en_US.UTF-8" |
| 43 |
LC_IDENTIFICATION="en_US.UTF-8" |
| 44 |
LC_ALL=en_US.UTF-8 |
| 45 |
|
| 46 |
In Mysql database the date look normal: |
| 47 |
date_purchased: 2014-09-20 18:46:25 |
| 48 |
|
| 49 |
|
| 50 |
|
| 51 |
-- |
| 52 |
Joseph |
Archives