NYCPHP Meetup

[FB`]

Except your last field as you showed it earlier doesn't look like a
timestamp(14):

INSERT INTO `cat_49` (`cat_49_id`, `cat_49_content_area`,
`cat_49_parent`, `cat_49_name`, `cat_49_description`,
`cat_49_sort_num`, `cat_49_active`, `cat_49_added`, `cat_49_updated`)
VALUES (1, 49, 0, 0x414652494341, '', 0, 'y', '2004-01-05 09:34:22',
2004-01-06 13:03:44);

-- i would expect 20040106130344 there...

FB`

----- Original Message ----- 
From: "Marc Antony Vose" <suzerain at suzerain.com>
To: "NYPHP Talk" <talk at lists.nyphp.org>
Sent: Tuesday, April 06, 2004 4:33 PM
Subject: Re: [nycphp-talk] phpMyadmin's dumps won't import into...phpMyAdmin?


> >  > Isn't this a bug?
> >>
> >
> >What does the CREATE TABLE look like?  (do it anyway)
> >
> >Are you sure the structure is ok? What are the results when you analyze
the
> >table?
> >
> >>  desc cat_49
> >
> >Sounds like your table is exporting a different type than expected.
> >
> >- Jon
> >
>
>
> hmmm...well, php is dumping this create table statement for the same
> table referenced in my last email:
>
> CREATE TABLE `cat_49` (
>    `cat_49_id` int(11) unsigned NOT NULL auto_increment,
>    `cat_49_content_area` int(11) unsigned NOT NULL default '49',
>    `cat_49_parent` int(11) NOT NULL default '0',
>    `cat_49_name` tinyblob,
>    `cat_49_description` blob,
>    `cat_49_sort_num` tinyint(4) NOT NULL default '0',
>    `cat_49_active` enum('y','n') NOT NULL default 'n',
>    `cat_49_added` datetime default NULL,
>    `cat_49_updated` timestamp(14) NOT NULL,
>    PRIMARY KEY  (`cat_49_id`)
> ) TYPE=MyISAM AUTO_INCREMENT=7 ;
>
>
> i don't see anything particularly strange there.
>
>
> -- 
> Marc Antony Vose
> http://www.suzerain.com/
>
> I'm looking for something in an *after dinner* burrito.
> -- Homer Simpson
> _______________________________________________
> 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:42:01 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 B3881A85E9
	for <talk at lists.nyphp.org>; Tue,  6 Apr 2004 16:42:00 -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:41:55 -0700
Message-ID: <41EE526EC2D3C74286415780D3BA9F870142790D 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: AcQcFoTwhkX5tBI2SmO/wSo/2nWboAAAK2IA
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:42:01 -0000


>    `cat_49_added` datetime default NULL,
>    `cat_49_updated` timestamp(14) NOT NULL,

Here's the problem...

The datetime is being exported as a standard datetime string (with the
spaces, hypens, etc).

The timestamp column should be exported as a number, such as:

20040106130344

This is why it isn't getting quoted.  Yet, the format that's being
captured by phpMyAdmin is of the string, per above.  Spaces, but not
quoted, thus your error.

Why this is happening I'm not sure.  I'd bet it's a bug in phpMyAdmin.
To see if it's a problem with mysql or phpmyadmin, run these queries
just as testers:

SELECT cat_49_added FROM cat_49 LIMIT 1

SELECT cat_49_updated FROM cat_49 LIMIT 1


The results of each should be differently formatted.  Are they?

H