NYCPHP Meetup

[Marc Antony Vose]

>  > 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