Could you submit it to the Doctrine user group ?
2009/12/11 micon <[email protected]>
> I think i found a serious bug in symfony/doctine!
> For me this was repeatable (i tried it with several schemas and
> different symfony application)
>
> Summary:
> When you use more than a certain number of I18n fields within a
> schema / model (in my case 7 fields) doctrine
> generates a Doctrine_Connection_Mysql_Exception.
>
> Description of the error:
>
> * I´m using symfony 1.3.1
>
> * My schema:
>
> options:
> charset: utf8
> collate: utf8_general_ci
> type: InnoDB
>
> Offer:
> actAs:
> I18n:
> fields: [offervalue1, offervalue2, offervalue3, offervalue4,
> offervalue5, offervalue6, offervalue7, offervalue8, offervalue9]
> columns:
> offername: { type: string(255) }
> offervalue1: { type: string(255) }
> offervalue2: { type: string(255) }
> offervalue3: { type: string(255) }
> offervalue4: { type: string(255) }
> offervalue5: { type: string(255) }
> offervalue6: { type: string(255) }
> offervalue7: { type: string(255) }
> offervalue8: { type: string(255) }
> offervalue9: { type: string(255) }
> offervalue10: { type: string(255) }
> offervalue11: { type: string(255) }
> offervalue12: { type: string(255) }
> offervalue13: { type: string(255) }
> offervalue14: { type: string(255) }
> offervalue15: { type: string(255) }
> offervalue16: { type: string(255) }
> offervalue17: { type: string(255) }
> offervalue18: { type: string(255) }
> offervalue19: { type: string(255) }
> offervalue20: { type: string(255) }
> offervalue21: { type: string(255) }
> offervalue22: { type: string(255) }
> offervalue23: { type: string(255) }
> offervalue24: { type: string(255) }
> offervalue25: { type: string(255) }
> offervalue26: { type: string(255) }
> offervalue27: { type: string(255) }
> offervalue28: { type: string(255) }
> offervalue29: { type: string(255) }
> offervalue30: { type: string(255) }
>
> * My form:
> class OfferForm extends BaseOfferForm
> {
> public function configure()
> {
> $this->embedI18n(array
>
> ('de','en','fr','it','us','hu','pl','nl','da','sv','es','ru','fi','cs','ja','ro','et','tr','ko'));
>
> $this->widgetSchema->setLabel('de', 'German');
> $this->widgetSchema->setLabel('en', 'English UK');
> $this->widgetSchema->setLabel('fr', 'French');
> $this->widgetSchema->setLabel('it', 'Italian');
> $this->widgetSchema->setLabel('us', 'English US');
> $this->widgetSchema->setLabel('hu', 'Hungarian');
> $this->widgetSchema->setLabel('pl', 'Polish');
> $this->widgetSchema->setLabel('nl', 'Dutch');
> $this->widgetSchema->setLabel('da', 'Danish');
> $this->widgetSchema->setLabel('sv', 'Swedish');
> $this->widgetSchema->setLabel('es', 'Spanish');
> $this->widgetSchema->setLabel('ru', 'Russian');
> $this->widgetSchema->setLabel('fi', 'Finnish');
> $this->widgetSchema->setLabel('cs', 'Czech');
> $this->widgetSchema->setLabel('ja', 'Japanese');
> $this->widgetSchema->setLabel('ro', 'Romanian');
> $this->widgetSchema->setLabel('et', 'Estonian');
> $this->widgetSchema->setLabel('tr', 'Turkish');
> $this->widgetSchema->setLabel('ko', 'Korean');
>
> }
> }
>
> * the error:
> --> when you create a new Offer everthing is ok
> --> when you try to update a Offer the following error message
> appears:
>
> 500 | Internal Server Error | Doctrine_Connection_Mysql_Exception
>
> SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or
> update a child row: a foreign key constraint fails (`mytest/
> offer_translation`,CONSTRAINT `offer_translation_id_offer_id` FOREIGN
> KEY (`id`) REFERENCES `offer` (`id`) ON DELETE CASCADE ON UPDATE
> CASCADE)
>
>
> If you reduce the number of i18n fields (here overvalue1 - overvalue7)
> everthing works fine!
> as soon as you use more then 7 fields the error appears. (but
> strangely the data will be saved correctly!)
>
> Please if there is anybody how can give me a hint how to solve this
> problem i would be really thankful (a large project depends on this
> and i have no clue how to solve this issue :-(( )
>
>
>
>
>
>
>
> --
>
> You received this message because you are subscribed to the Google Groups
> "symfony users" group.
> To post to this group, send email to [email protected].
> To unsubscribe from this group, send email to
> [email protected]<symfony-users%[email protected]>
> .
> For more options, visit this group at
> http://groups.google.com/group/symfony-users?hl=en.
>
>
>
--
Alexandre Salomé
http://alexandre-salome.fr
--
You received this message because you are subscribed to the Google Groups
"symfony users" 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.com/group/symfony-users?hl=en.
