#1619: ActAs Searchable on actAs I18n failed
-----------------------------------+--------------------------------------- -
 Reporter:  Garfield-fr            |       Owner:  jwage  
     Type:  defect                 |      Status:  new    
 Priority:  major                  |   Milestone:  Unknown
Component:  Searchable             |     Version:  1.0.3  
 Keywords:                         |    Has_test:  1      
 Mystatus:  Pending Core Response  |   Has_patch:  0      
-----------------------------------+--------------------------------------- -
 I would like to have a seachable behavior on i18n behavior but this
 functionality failed on save

 my schema:

 {{{
 Article:
   tableName:    article
   actAs:
     I18n:
       fields: [name, description]
       actAs:
         Searchable:
           fields: [name]
   columns:
     id:
       type: integer(3)
       primary:  true
       autoincrement:  true
     name:
       type: string(60)
     description:
       type: string(4000)

 }}}

 Insert error:
 {{{
 SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update
 a child row:
  a foreign key constraint fails (`incubator12/article_i18n`, CONSTRAINT
 `article_i18n_ibfk_1`
  FOREIGN KEY (`id`) REFERENCES `article_i18n_index` (`id`))
 }}}

--
Ticket URL: <http://trac.doctrine-project.org/ticket/1619>
Doctrine <http://www.phpdoctrine.org>
PHP Doctrine Object Relational Mapper

#1619: ActAs Searchable on actAs I18n failed
--------------------------+------------------------------------------------ -
  Reporter:  Garfield-fr  |       Owner:  jwage                
      Type:  defect       |      Status:  new                  
  Priority:  major        |   Milestone:  Unknown              
 Component:  Searchable   |     Version:  1.0.3                
Resolution:               |    Keywords:                      
  Has_test:  1            |    Mystatus:  Pending Core Response
 Has_patch:  0            |  
--------------------------+------------------------------------------------ -
Comment (by jj):

 This is not working for "Versionable", too.

 yaml schema:
 {{{
 Article:
     actAs:
         I18n:
             fields: [title,text]
             actAs:
                 Versionable:
                     fields: [title,text]
     columns:
         title: string(16)
         text: string(32)
         active: boolean
 }}}

 Insert error:

 {{{
 Fatal error: Uncaught exception 'Doctrine_Connection_Mysql_Exception' with
 message 'SQLSTATE[HY000]: General error: 1452 Cannot add or update a child
 row: a foreign key constraint fails (`test/article_translation`,
 CONSTRAINT `article_translation_ibfk_1` FOREIGN KEY (`id`) REFERENCES
 `article_translation_version` (`id`))' in
 C:\xampp\workspace\doctrine-1.0\Doctrine\Connection.php:1075 Stack trace:
 #0 C:\xampp\workspace\doctrine-1.0\Doctrine\Connection\Statement.php(244):
 Doctrine_Connection->rethrowException(Object(PDOException),
 Object(Doctrine_Connection_Statement)) #1
 C:\xampp\workspace\doctrine-1.0\Doctrine\Connection.php(1040):
 Doctrine_Connection_Statement->execute(Array) #2
 C:\xampp\workspace\doctrine-1.0\Doctrine\Connection.php(674):
 Doctrine_Connection->exec('INSERT INTO art...', Array) #3
 C:\xampp\workspace\doctrine-1.0\Doctrine\Connection\UnitOfWork.php(590):
 Doctrine_Connection->insert(Object(Doctrine_Table), Array) #4
 C:\xampp\workspace\doctrine-1.0\Doctrine\Connection\UnitOfWork.php(552):
 Doctrine_Connection in
 C:\xampp\workspace\doctrine-1.0\Doctrine\Connection.php on line 1075
 }}}

--
Ticket URL: <http://trac.doctrine-project.org/ticket/1619#comment:1>
Doctrine <http://www.phpdoctrine.org>
PHP Doctrine Object Relational Mapper

#1619: ActAs Searchable on actAs I18n failed
--------------------------+------------------------------------------------ -
  Reporter:  Garfield-fr  |       Owner:  jwage                
      Type:  defect       |      Status:  new                  
  Priority:  major        |   Milestone:  Unknown              
 Component:  Searchable   |     Version:  1.0.3                
Resolution:               |    Keywords:                      
  Has_test:  1            |    Mystatus:  Pending Core Response
 Has_patch:  0            |  
--------------------------+------------------------------------------------ -
Changes (by jwage):

  * milestone:  => Unknown

Old description:

New description:

 I would like to have a seachable behavior on i18n behavior but this
 functionality failed on save

 my schema:

 {{{
 Article:
   tableName:    article
   actAs:
     I18n:
       fields: [name, description]
       actAs:
         Searchable:
           fields: [name]
   columns:
     id:
       type: integer(3)
       primary:  true
       autoincrement:  true
     name:
       type: string(60)
     description:
       type: string(4000)

 }}}

 Insert error:
 {{{
 SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update
 a child row:
  a foreign key constraint fails (`incubator12/article_i18n`, CONSTRAINT
 `article_i18n_ibfk_1`
  FOREIGN KEY (`id`) REFERENCES `article_i18n_index` (`id`))
 }}}

--
Ticket URL: <http://trac.doctrine-project.org/ticket/1619#comment:3>
Doctrine <http://www.phpdoctrine.org>
PHP Doctrine Object Relational Mapper

#1619: ActAs Searchable on actAs I18n failed
-----------------------------------+--------------------------------------- -
 Reporter:  Garfield-fr            |       Owner:  jwage
     Type:  defect                 |      Status:  new  
 Priority:  major                  |   Milestone:  1.0.5
Component:  Searchable             |     Version:  1.0.3
 Keywords:                         |    Has_test:  1    
 Mystatus:  Pending Core Response  |   Has_patch:  0    
-----------------------------------+--------------------------------------- -
Changes (by jwage):

  * milestone:  Unknown => 1.0.5

--
Ticket URL: <http://trac.doctrine-project.org/ticket/1619#comment:4>
Doctrine <http://www.phpdoctrine.org>
PHP Doctrine Object Relational Mapper