Ticket #711 (closed defect: fixed)
Doctrine::generateModelsFromDb does not recognize MySQL 'bit' type
| Reported by: | karlkatzke | Owned by: | somebody |
|---|---|---|---|
| Priority: | critical | Milestone: | 0.10.3 |
| Component: | Other | Version: | 0.10.0 |
| Severity: | Keywords: | ||
| Cc: | Has Test: | ||
| Status: | Has Patch: |
Description (last modified by karlkatzke) (diff)
With a table that has a 'bit' datatype, I get an error that 'bit' datatype is an unknown database attribute type.
[04-Jan-2008 18:55:12] PHP Fatal error: Uncaught exception 'Doctrine_DataDict_Exception' with message 'unknown database attribute type: bit' in /Users/karlkatzke/work/corpworlds/library/Doctrine-Beta2/Doctrine-1.0.0/lib/Doctrine/DataDict/Mysql.php:379
Stack trace:
#0 /Users/karlkatzke/work/corpworlds/library/Doctrine-Beta2/Doctrine-1.0.0/lib/Doctrine/Import/Mysql.php(128): Doctrine_DataDict_Mysql->getPortableDeclaration(Array)
#1 /Users/karlkatzke/work/corpworlds/library/Doctrine-Beta2/Doctrine-1.0.0/lib/Doctrine/Import.php(218): Doctrine_Import_Mysql->listTableColumns('log_logins')
#2 /Users/karlkatzke/work/corpworlds/library/Doctrine-Beta2/Doctrine-1.0.0/lib/Doctrine.php(671): Doctrine_Import->importSchema('/Users/karlkatz...', Array)
#3 /Users/karlkatzke/work/corpworlds/html/export.php(13): Doctrine::generateModelsFromDb('/Users/karlkatz...')
#4 {main}
thrown in /Users/karlkatzke/work/corpworlds/library/Doctrine-Beta2/Doctrine-1.0.0/lib/Doctrine/DataDict/Mysql.php on line 379
This is in 1.0 beta 2.
BIT is a valid mysql datatype as fo 5.0.3, according to http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html
Table creation SQL:
CREATE TABLE `corpworlds`.`log_logins` ( `id` int(11) NOT NULL auto_increment, `datetime` timestamp NOT NULL default CURRENT_TIMESTAMP, `login` varchar(40) default NULL, `user_id` int(10) default NULL, `ip_address` varchar(25) NOT NULL, `browser` varchar(100) default NULL, `os` varchar(100) default NULL, `success` bit(1) NOT NULL default '', PRIMARY KEY (`id`), KEY `fk_user_id_logins` (`user_id`), CONSTRAINT `fk_user_id_logins` FOREIGN KEY (`user_id`) REFERENCES `acl_users` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Log of all logins that happened.'
Change History
Note: See
TracTickets for help on using
tickets.