NYCPHP Meetup

[Chris Bielanski]

That's pretty much what I was expecting to hear but I wanted to get the
details. Danke :)

> -----Original Message-----
> From: Hans Zaunere [mailto:hans not junk at nyphp.com]
> Sent: Tuesday, April 06, 2004 4:48 PM
> To: NYPHP Talk
> Subject: RE: [nycphp-talk] phpMyadmin's dumps won't import
> into...phpMyAdmi n?
> 
> 
> 
> > Does this mean it might be resolved by altering (if possible) 
> > the original
> > or destination table structures to use datetime data 
> instead of mixing
> > datetime and timestamp?
> 
> That would "fix" it but for the wrong reasons, and potentially break
> other dependencies that the column is expected to be a TIMESTAMP (like
> timestamping).
> 
> H
> 
> _______________________________________________
> talk mailing list
> talk at lists.nyphp.org
> http://lists.nyphp.org/mailman/listinfo/talk
> 

>From hans not junk at nyphp.com  Tue Apr  6 16:58:39 2004
Return-Path: <hans not junk at nyphp.com>
Received: from ehost011-1.exch011.intermedia.net (unknown [64.78.21.3])
	by virtu.nyphp.org (Postfix) with ESMTP id 2AC56A85E9
	for <talk at lists.nyphp.org>; Tue,  6 Apr 2004 16:58:39 -0400 (EDT)
X-MimeOLE: Produced By Microsoft Exchange V6.5.6944.0
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Subject: RE: [nycphp-talk] phpMyadmin's dumps won't import into...phpMyAdmin?
Date: Tue, 6 Apr 2004 13:58:36 -0700
Message-ID: <41EE526EC2D3C74286415780D3BA9F8701427933 at ehost011-1.exch011.intermedia.net>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: [nycphp-talk] phpMyadmin's dumps won't import into...phpMyAdmin?
Thread-Index: AcQcGPNhL3XQL+B4RCi1S2G5nOANhwAAPiGg
From: "Hans Zaunere" <hans not junk at nyphp.com>
To: "NYPHP Talk" <talk at lists.nyphp.org>
X-BeenThere: talk at lists.nyphp.org
X-Mailman-Version: 2.1.2
Precedence: list
Reply-To: NYPHP Talk <talk at lists.nyphp.org>
List-Id: NYPHP Talk  <talk.lists.nyphp.org>
List-Unsubscribe: <http://lists.nyphp.org/mailman/listinfo/talk>,
	<mailto:talk-request at lists.nyphp.org?subject=unsubscribe>
List-Archive: <http://lists.nyphp.org/pipermail/talk>
List-Post: <mailto:talk at lists.nyphp.org>
List-Help: <mailto:talk-request at lists.nyphp.org?subject=help>
List-Subscribe: <http://lists.nyphp.org/mailman/listinfo/talk>,
	<mailto:talk-request at lists.nyphp.org?subject=subscribe>
X-List-Received-Date: Tue, 06 Apr 2004 20:58:39 -0000


> So, maybe the bug is not in phpMyAdmin.  I also thought the timestamp=20
> should be coming out as a timestamp integer, but I figured phpMyAdmin=20
> knew more about this stuff than me.
>=20
> Anyway, the two results are NOT differently formatted.

Although, you ran the SQL still through phpMyAdmin....

> I need to investigate this more and find out why the timestamp isn't=20
> coming out as a timestamp...maybe I can appeal to the sysadmin to=20
> grant me temporary access to this account.

Next step:

-- write a tiny PHP script to run those two queries directly against
MySQL.
-- get on the mysql shell from somewhere and run those queries directly
against MySQL

Point is, bypass phpmyadmin completely.

H