#1477: unknown database attribute type: varbinary
-----------------------------------+----------------------------------------
Reporter: ve1itas | Owner: jwage
Type: defect | Status: new
Priority: minor | Milestone:
Component: Import/Export | Version: 1.0
Keywords: | Has_test: 0
Mystatus: Pending Core Response | Has_patch: 0
-----------------------------------+----------------------------------------
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
Files\PHP\PEAR\Doctrine\lib\Doctrine\DataDict\Mysql.php:402
Stack trace:
#0 C:\Program Files\PHP\PEAR\Doctrine\lib\Doctrine\Import\Mysql.php(151):
Doctrine_DataDict_Mysql->getPortableDeclaration(Array)
#1 C:\Program Files\PHP\PEAR\Doctrine\lib\Doctrine\Import.php(388):
Doctrine_Import_Mysql->listTableColumns('1x2_grp')
#2 C:\Program Files\PHP\PEAR\Doctrine\lib\Doctrine.php(682):
Doctrine_Import->importSchema('ve1', Array, Array)
#3 C:\Program Files\Apache Software
Foundation\Apache2.2\htdocs\ve1doct\import.php(13):
Doctrine::generateModelsFromDb('ve1')
#4 {main}
thrown in C:\Program
Files\PHP\PEAR\Doctrine\lib\Doctrine\DataDict\Mysql.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;
}}}
--
Ticket URL: <http://trac.phpdoctrine.org/ticket/1477>
Doctrine <http://www.phpdoctrine.org>
PHP Doctrine Object Relational Mapper
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"doctrine-svn" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.co.uk/group/doctrine-svn?hl=en-GB
-~----------~----~----~----~------~----~------~--~---
