DB_dataobjects problem with Insert

[panos100m]

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
[code=text]
DataObjects_tes t: CONNECT: Checking for database database_ in options
DataObjects_tes t: CONNECT: NEW CONNECTION
DataObjects_tes t: CONNECT: mysql://__MUNGED__@loca lhost/testdb 3f7988ed345b6d7 c1c02f017c09f70 b9
DataObjects_tes t: CONNECT: __MUNGED__
DataObjects_tes t: QUERY: INSERT INTO test (Name , Surname , Address , Country ) VALUES ('' , '' , '' , '-1' )
DataObjects_tes t: query: QUERY DONE IN 0.0011560916900 6 seconds
[/code]
Notice that in the insert statement you only have Name,Surname,Ad dress,Country.. .
[code=php]
$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");
[/code]
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
[code=mysql]
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;
[/code]
Any help will be really appreciated

Thanks

[panos100m]

Hi

Thanks for the reply

The problem was thet i modified the database but i havent generated the classs for the newly modfied tabels that why the insert didnt work :-)