Strange bug with DBDO and php 4.3.11

From: Date: Fri, 04 Nov 2005 08:33:31 +0000
Subject: Strange bug with DBDO and php 4.3.11
Groups: php.pear.general 
Request: Send a blank email to pear-general+get-21771@lists.php.net to get a copy of this message
Hi there, I am experiencing a strange bug with php 4.3.11 and Mysql 4.1.10 combos. A table that generates perfect under php 5.1 has suddently become flawed under php 4.3.11. Here is the strucutred thats generated and obviously throws out formbuilder in the meantime.
var $customerID;                      // date(138495728)  not_null primary_key multiple_key
    var $customer_name;                   // year(138495824)  unique_key unsigned zerofill
    var $domain;                          // null(138495920)  not_null primary_key unique_key multiple_key blob unsigned zerofill binary enu
m set auto_increment timestamp
    var $access_code;                     // time(138496000)  unique_key unsigned zerofill
    var $monthly_price;                   // year(138496096)  primary_key multiple_key
    var $bandwidth_limit;                 // unknown(138496192)  not_null primary_key multiple_key
    var $exceed_price;                    // datetime(138496288)  primary_key multiple_key
    var $contact_name;                    // datetime(138496384)  unique_key unsigned zerofill
    var $city;                            // real(138496480)  unique_key unsigned zerofill
    var $state;                           // real(138496560)  unique_key unsigned zerofill
    var $post_code;                       // int(138496640)  unique_key unsigned zerofill
    var $country;                         // timestamp(138496736)  unique_key unsigned zerofill
    var $phone;                           // real(138496816)  unique_key unsigned zerofill
    var $email;                           // real(138496896)  unique_key unsigned zerofill
    var $billing_email;                   // year(138496976)  unique_key unsigned zerofill
    var $tech_email;                      // date(138497072)  unique_key unsigned zerofill
    var $address;                         // timestamp(138497168)  not_null primary_key unique_key multiple_key blob unsigned zerofill binar
y enum set auto_increment timestamp
    var $company;                         // timestamp(138497248)  unique_key unsigned zerofill
    var $icq;                             // int(138497320)  unique_key blob
    var $mas_customer_key;                // unknown(138497392)  unique_key unsigned zerofill
    var $fax_number;                      // date(138497504)  unique_key unsigned zerofill
    var $feedclient_typeID;               // unknown(138497600)  unique_key
Some return unknown, some are null, the rest are date and times which should be varchars , any ideas ?

« previous php.pear.general (#21771) next »