[gentoo-user] MySQL date look funny: "2014-0"

[gentoo-user] MySQL date look funny: "2014-0"

[Joseph]

After recent upgrade my Orders in OsCommerce program date look funny: "2014-0"

I downgraded mysql to 5.1.70 but this is caused by it.

I've two PHP installed: 5.3 and 5.5 
I tried switching to 5.3 it still the same date display  "2014-0"

-- 
Joseph

Re: [gentoo-user] MySQL date look funny: "2014-0"

[J. Roeleveld]

On 21 September 2014 07:33:43 CEST, Joseph <syscon780@gmail.com> wrote:
>After recent upgrade my Orders in OsCommerce program date look funny:
>"2014-0"
>
>I downgraded mysql to 5.1.70 but this is caused by it.
>
>I've two PHP installed: 5.3 and 5.5 
>I tried switching to 5.3 it still the same date display  "2014-0"

What do you see when querying using native tools?
-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.

Re: [gentoo-user] MySQL date look funny: "2014-0"

[Mick]

[-- Attachment #1: Type: Text/Plain, Size: 612 bytes --]

On Sunday 21 Sep 2014 07:11:15 J. Roeleveld wrote:
> On 21 September 2014 07:33:43 CEST, Joseph <syscon780@gmail.com> wrote:
> >After recent upgrade my Orders in OsCommerce program date look funny:
> >"2014-0"
> >
> >I downgraded mysql to 5.1.70 but this is caused by it.
> >
> >I've two PHP installed: 5.3 and 5.5
> >I tried switching to 5.3 it still the same date display  "2014-0"
> 
> What do you see when querying using native tools?

Have you made any changes in your locale?  I would think that this is not an 
application specific setting, but picked up from your env.
-- 
Regards,
Mick

[-- Attachment #2: This is a digitally signed message part. --]
[-- Type: application/pgp-signature, Size: 473 bytes --]

Re: [gentoo-user] MySQL date look funny: "2014-0"

[Joseph]

On 09/21/14 09:40, Mick wrote:
>On Sunday 21 Sep 2014 07:11:15 J. Roeleveld wrote:
>> On 21 September 2014 07:33:43 CEST, Joseph <syscon780@gmail.com> wrote:
>> >After recent upgrade my Orders in OsCommerce program date look funny:
>> >"2014-0"
>> >
>> >I downgraded mysql to 5.1.70 but this is caused by it.
>> >
>> >I've two PHP installed: 5.3 and 5.5
>> >I tried switching to 5.3 it still the same date display  "2014-0"
>>
>> What do you see when querying using native tools?
>
>Have you made any changes in your locale?  I would think that this is not an
>application specific setting, but picked up from your env.
>-- 
>Regards,
>Mick

I think you are correct, some setting had changed but I don't know which. 
My locale as root:
# locale -a
C
en_US
en_US.iso88591
en_US.utf8
POSIX

user:
$ locale
LANG=en_US.UTF-8
LC_CTYPE="en_US.UTF-8"
LC_NUMERIC="en_US.UTF-8"
LC_TIME="en_US.UTF-8"
LC_COLLATE="en_US.UTF-8"
LC_MONETARY="en_US.UTF-8"
LC_MESSAGES="en_US.UTF-8"
LC_PAPER="en_US.UTF-8"
LC_NAME="en_US.UTF-8"
LC_ADDRESS="en_US.UTF-8"
LC_TELEPHONE="en_US.UTF-8"
LC_MEASUREMENT="en_US.UTF-8"
LC_IDENTIFICATION="en_US.UTF-8"
LC_ALL=en_US.UTF-8

In Mysql database the date look normal:
date_purchased: 2014-09-20 18:46:25



-- 
Joseph