OrangeHRM Integration Issue



1.   When using  the attribute ATTR_AUTO_ACCESSOR_OVERRIDE you cannot use the field name "table_name" because it is reserved by Doctrine. You must choose another field name.  

CREATE TABLE IF NOT EXISTS `hs_hr_unique_id` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `last_id` int(10) unsigned NOT NULL,
  `table_name` varchar(50) NOT NULL,
  `field_name` varchar(50) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `table_field` (`table_name`,`field_name`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=43 ;

Solution : 
http://wildan.openthinklabs.com/2010/06/04/using-mysql-reserved-word-in-doctrine-schema/


Comments