Re: Strange bug with DBDO and php 4.3.11

never mind, bad on our end, support didnt compile our php properly yet again, in fact they freaked it too many times and i had to go in and do it coz everything was down lol. Was wierd it would do that though ? On 04/11/2005, at 7:33 PM, Dan Rossi wrote:

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 ? -- PEAR General Mailing List (http://pear.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php