W dniu 5 kwietnia 2010 17:51 użytkownik Jonathan Wage <[email protected]> napisał: > Hi, > > You can report the issue on http://www.doctrine-project.org/jira with an > explanation and test case if possible.
Ok, I'll make a test case > We'll work to get it addressed in the > next release. BTW. Changing string size also doesn't work here. Regards, Michal > > - Jon > > 2010/4/1 Michał Piotrowski <[email protected]> >> >> Hi, >> >> I have two problems with doctrine:migrate here (symfony 1.4). >> >> The first is caused by an empty onUpdate declaration >> >> $this->createForeignKey('comment', 'comment_game_id_game_id', >> array( >> 'name' => 'comment_game_id_game_id', >> 'local' => 'game_id', >> 'foreign' => 'id', >> 'foreignTable' => 'game', >> 'onUpdate' => '', >> 'onDelete' => 'CASCADE', >> )); >> >> >> - SQLSTATE[42601]: Syntax error: 7 BŁĄD: błąd składni w lub blisko "ON" >> LINE 1: ...EIGN KEY (game_id) REFERENCES game(id) ON UPDATE ON DELETE ... >> ^. >> Failing Query: "ALTER TABLE comment ADD CONSTRAINT >> comment_game_id_game_id FOREIGN KEY (game_id) REFERENCES game(id) ON >> UPDATE ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE" >> >> It generates "ON UPDATE ON DELETE ". I guess that >> getAdvancedForeignKeyOptions in >> plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Export.php >> should be fixed. >> >> The second issue appears while migrating down >> >> $this->removeIndex('rate', 'rate_game_id', array( >> 'fields' =>. >> array( >> 0 => 'game_id', >> ), >> )); >> >> >> [Doctrine_Connection_Pgsql_Exception] >> SQLSTATE[25P02]: In failed sql transaction: 7 BŁĄD: current >> transaction is aborted, commands ignored until end of transaction >> block. Failing Query: "DROP INDEX rate_game_id_idx" >> >> Caused by >> $name = >> $this->conn->quoteIdentifier($this->conn->formatter->getIndexName($name)); >> in >> plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Export.php >> because index name is "rate_game_id" not "rate_game_id_idx" >> >> IMHO these issues are quite serious for doctrine:migrate users. >> >> Regards, >> Michal > > > > -- > Jonathan H. Wage (+1 415 992 5468) > Open Source Software Developer & Evangelist > sensiolabs.com | jwage.com | doctrine-project.org | symfony-project.org > > You should follow me on Twitter: http://www.twitter.com/jwage > > You can contact Jonathan about Doctrine, Symfony and Open-Source or for > training, consulting, application development, or business related questions > at [email protected] > -- If you want to report a vulnerability issue on symfony, please send it to security at symfony-project.com You received this message because you are subscribed to the Google Groups "symfony developers" 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-devs?hl=en To unsubscribe, reply using "remove me" as the subject.
