DB_dataobjects problem with Insert

[Trace]

Hi

I am using DB_dataobjects and pear .
I noticed that for some of my tables my insert statement doesnt work
correclty ..


Those tableas are tables that i changed recently (i removed the space
and added "_" and now i removed the underscore also)


So this is the output


DataObjects_tes t: CONNECT: Checking for database database_ in options
DataObjects_tes t: CONNECT: NEW CONNECTION
DataObjects_tes t: CONNECT: mysql://root:pvcllc@loc alhost/testdb
3f7988ed345b6d7 c1c02f017c09f70 b9
DataObjects_tes t: CONNECT: a:1:{s:
32:"3f7988ed345 b6d7c1c02f017c0 9f70b9";O:8:"DB _mysql":8:{s:
10:"autocommit" ;b:1;s:8:"dbsyn tax";s:5:"mysql ";s:3:"dsn";a:9 :{s:
7:"phptype";s:5 :"mysql";s:8:"d bsyntax";s:5:"m ysql";s:8:"user name";s:
4:"root";s:8:"p assword";s:6:"p vcllc";s:8:"pro tocol";s:3:"tcp ";s:
8:"hostspec";s: 9:"localhost";s :4:"port";b:0;s :6:"socket";b:0 ;s:
8:"database";s: 8:"testdb";}s:8 :"features";a:7 :{s:5:"limit";s :
5:"alter";s:8:" new_link";s:5:" 4.2.0";s:7:"num rows";b:1;s:
8:"pconnect";b: 1;s:7:"prepare" ;b:0;s:3:"ssl"; b:0;s:
12:"transaction s";b:
1;}s:9:"fetchmo de";i:1;s:22:"f etchmode_object _class";s:
8:"stdClass"; s:
7:"options";a:8 :{s:16:"result_ buffering";i:50 0;s:10:"persist ent";b:
0;s:
3:"ssl";b:0;s:5 :"debug";i:0;s: 14:"seqname_for mat";s:6:"%s_se q";s:
8:"autofree";b: 0;s:11:"portabi lity";i:0;s:8:" optimize";s:
11:"performance ";}s:13:"was_co nnected";b:1;}}
DataObjects_tes t: QUERY: INSERT INTO test (Name , Surname , Address ,
Country ) VALUES ('' , '' , '' , '-1' )
DataObjects_tes t: query: QUERY DONE IN 0.0011560916900 6 seconds


Notice that in the insert statement you only have
Name,Surname,Ad dress,Country.. .


$test = new DataObjects_tes t;
DB_DataObject:: debugLevel(5);


session_start() ;


$test->Name=$_REQUE ST['name'];
$test->Surname=$_REQU EST['surname'];


$test->Address=$_REQU EST['address'];
$test->Country=$_REQU EST['country'];
$test->Addedby=$_SESS ION['user'] ;
$test->Date_Added=dat e("d/m/y");


But you dont have Date_Added and Addedby .. i think it might be
somnething to do with the character encoding in the particular
columns
but not sure.. i renamed the tables using MySQL GUI Querty manager


and here are the tables in question


DROP TABLE IF EXISTS `testdb`.`test` ;
CREATE TABLE `testdb`.`test` (
`Name` varchar(50) default NULL,
`Surname` varchar(50) character set utf8 default NULL,
`Address` varchar(50) default NULL,
`Country` varchar(50) character set utf8 default NULL,
`City` varchar(50) character set utf8 default NULL,
`Phone Landline` varchar(50) character set utf8 default NULL,
`Genre` varchar(50) character set utf8 default NULL,
`Email` varchar(200) character set utf8 default NULL,
`Rates` varchar(50) character set utf8 default NULL,
`Extra Info` varchar(50) character set utf8 default NULL,
`Web Address` text character set utf8,
`Proffesion` varchar(50) character set utf8 default NULL,
`Phone Mobile` varchar(50) character set utf8 default NULL,
`Address Street` varchar(50) character set utf8 default NULL,
`Adress Postcode` varchar(50) character set utf8 default NULL,
`Nickname` varchar(50) character set utf8 default NULL,
`Description/Other Info` varchar(100) character set utf8 default
NULL,
`Addedby` varchar(50) default NULL,
`Date_Added` varchar(50) default NULL,
`Date Contacted` varchar(50) character set utf8 default NULL,
`Picture` varchar(50) character set utf8 default NULL,
`Id` int(10) unsigned NOT NULL auto_increment,
PRIMARY KEY (`Id`)
) ENGINE=MyISAM AUTO_INCREMENT= 1190 DEFAULT CHARSET=latin1
ROW_FORMAT=DYNA MIC;


Any help will be really appreciated


Thanks