Hi,

I am a newbie. I was trying to import a database and got errors about varbinary attribute type. None of the tables use varbinary though. Is database importing supposed to work with view? Or am I doing something wrong?

PHP Fatal error:  Uncaught exception 'Doctrine_DataDict_Exception' with message 'unknown database attribute type: varbinary' in C:Program FilesPHPPEARDoctrinelibDoctrineDataDictMysql.php:402
Stack trace:
#0 C:Program FilesPHPPEARDoctrinelibDoctrineImportMysql.php(151): Doctrine_DataDict_Mysql->getPortableDeclaration(Array)
#1 C:Program FilesPHPPEARDoctrinelibDoctrineImport.php(388): Doctrine_Import_Mysql->listTableColumns('1x2_grp')
#2 C:Program FilesPHPPEARDoctrinelibDoctrine.php(682): Doctrine_Import->importSchema('ve1', Array, Array)
#3 C:Program FilesApache Software FoundationApache2.2htdocsve1doctimport.php(13): Doctrine::generateModelsFromDb('ve1')
#4 {main}
  thrown in C:Program FilesPHPPEARDoctrinelibDoctrineDataDictMysql.php on line 402

1x2_grp is a view created by:

CREATE OR REPLACE VIEW ve1.1x2_grp AS SELECT mid, avg(o1) as o1_avg, avg(ox) as ox_avg, avg(o2) as o2_avg, concat(DATE(srcstamp), '-', lpad(time_to_sec(srcstamp) DIV 600, 4, '0')) AS grp;

1x2 is a table created by:

CREATE TABLE  `ve1`.`1x2` (
  `mid` int(10) unsigned NOT NULL,
  `srcstamp` datetime NOT NULL,
  `o1` double(7,5) unsigned NOT NULL,
  `ox` double(7,5) unsigned NOT NULL,
  `o2` double(7,5) unsigned NOT NULL,
  PRIMARY KEY  USING BTREE (`mid`,`srcstamp`),
  CONSTRAINT `FK_1x2_mid` FOREIGN KEY (`mid`) REFERENCES `match` (`mid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;