From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from lists.gentoo.org (pigeon.gentoo.org [208.92.234.80]) by finch.gentoo.org (Postfix) with ESMTP id AC07313838B for ; Sun, 21 Sep 2014 14:50:21 +0000 (UTC) Received: from pigeon.gentoo.org (localhost [127.0.0.1]) by pigeon.gentoo.org (Postfix) with SMTP id 99A57E0992; Sun, 21 Sep 2014 14:50:14 +0000 (UTC) Received: from mail143c7.megamailservers.com (mail121c7-2520.megamailservers.com [69.49.98.23]) (using TLSv1.1 with cipher ECDHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by pigeon.gentoo.org (Postfix) with ESMTPS id A6AB0E08BF for ; Sun, 21 Sep 2014 14:50:13 +0000 (UTC) X-POP-User: admin@sys-concept.com X-VIP: 69.49.109.100 Received: from syscon7.localdomain (S01060050da7ae68c.ed.shawcable.net [68.149.90.13]) by mail143c7.megamailservers.com (8.13.6/8.13.1) with ESMTP id s8LEoAWV023458 for ; Sun, 21 Sep 2014 10:50:12 -0400 Received: by syscon7.localdomain (Postfix, from userid 1000) id C910620021A; Sun, 21 Sep 2014 08:50:28 -0600 (MDT) Date: Sun, 21 Sep 2014 08:50:28 -0600 From: Joseph To: gentoo-user@lists.gentoo.org Subject: Re: [gentoo-user] MySQL date look funny: "2014-0" Message-ID: <20140921145028.GC4334@syscon7> References: <20140921053343.GB4334@syscon7> <6df95ae1-054a-4b76-bb2b-807642b001bd@email.android.com> <201409210940.51732.michaelkintzios@gmail.com> Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-user@lists.gentoo.org Reply-to: gentoo-user@lists.gentoo.org MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1; format=flowed Content-Disposition: inline In-Reply-To: <201409210940.51732.michaelkintzios@gmail.com> User-Agent: Mutt/1.5.22 (2013-10-16) X-CTCH-RefID: str=0001.0A02020A.541EE5A4.0037,ss=1,re=0.000,recu=0.000,reip=0.000,cl=1,cld=1,fgs=0 X-CTCH-VOD: Unknown X-CTCH-Spam: Unknown X-CTCH-Score: 0.000 X-CTCH-Rules: X-CTCH-Flags: 0 X-CTCH-ScoreCust: 0.000 X-CSC: 0 X-CHA: v=2.1 cv=cZDr8BzM c=1 sm=1 tr=0 a=C3ZDv51cNVt4vJz/79I2xQ==:117 a=C3ZDv51cNVt4vJz/79I2xQ==:17 a=SDcUNfBxAAAA:8 a=BDKbP5mgAAAA:8 a=Unq3plm5DvEA:10 a=M1kyBYkWWGkA:10 a=5_XZrzhQcY0A:10 a=jfKIMf1CAAIA:10 a=nDghuxUhq_wA:10 a=8nJEP1OIZ-IA:10 a=pGLkceISAAAA:8 a=bm6I1S1ZjKIWRXuXlQsA:9 a=wPNLvfGTeEIA:10 a=MSl-tDqOz04A:10 X-Origin-Country: CA X-Archives-Salt: f825a4b8-6ba8-45af-9736-cdb4d4aeaff0 X-Archives-Hash: bd3152b12ce6cd983e01b107d7103d16 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 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