RESOLVED: * reason for doctrine error was my webserver the sushoshin patch made problems - i just found the error because i switched from apache to nginx + fastcgi which gave me better logging information ... got this message: " 2010/01/09 17:16:26 [error] 9824#0: *16 FastCGI sent in stderr: "ALERT - configured POST variable limit exceeded - dropped variable 'offer[tr][machine_model]' (attacker '10.0.0.1', file '/var/www/ felderweb/nr1-devel/web/backend_dev.php')"
i changed the config files of suhosin to: [suhosin] suhosin.request.max_vars = 1000 suhosin.post.max_vars = 1000 and everthing worked fine (at least until now ...) On Dec 11 2009, 1:42 pm, micon <[email protected]> wrote: > 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]. For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en.
