This is a mysql specific error, because mysql only allows 64 bytes length (http://dev.mysql.com/doc/refman/5.0/en/identifiers.html). It seems that the SQL standard defines 128 bytes ( http://bugs.mysql.com/bug.php?id=13942) I think you should file a bug report for doctrine.
Am 12.01.2010 00:31, schrieb Mike Church: > > > On Jan 11, 12:30 pm, Georg Gell <geor...@have2.com> wrote: >> probably the key name is too long. Try if this works: >> ALTER TABLE sf_guard_group_permission ADD CONSTRAINT >> ggggg FOREIGN KEY (permission_id) REFERENCES sf_guard_permission(id) >> >> Am 11.01.2010 07:54, schrieb Mike Church: >> > > Wow! > > Thank you mysql for not telling me that there is a limit to the name > of a FK CONSTRAINT!!!!!! > > Thank you Georg. > > I will look into getting the sfDoctrineGuard plug in maintainers to > change it. > > Any suggestions on how I can change it? Editing data/sql/schema.sql > and doing ./symfony doctrine:insert-sql doesn't do it. Is the schema > coming from somewhere else and merged into ata/sql/schema.sql during > the insert? When I change the CONSTRAINTS to much shorter versions, > the do the SQL manually, it works. > > >
-- You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to symfony-us...@googlegroups.com. To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en.
