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: > Hi Folks: > > I have been trying to deploy, I have everything working right locally. > > Now without implying I've tried everything I can tell you all that I > am at the end of my rope. When I use the svn version of > sfDoctrineGuard from: > > http://svn.symfony-project.com/plugins/sfDoctrineGuardPlugin/trunk > (currently revision 26468) > > and symfony 1.4 > > Then do a > > ./symfony doctrine:build --all --env=prod > > I get: > > SQLSTATE[HY000]: General error: 1005 Can't create table './quicksand- > staging/#sql-899_274.frm' (errno: 121). Failing Query: "ALTER TABLE > sf_guard_group_permission ADD CONSTRAINT > sf_guard_group_permission_permission_id_sf_guard_permission_id FOREIGN > KEY (permission_id) REFERENCES sf_guard_permission(id)". Failing > Query: ALTER TABLE sf_guard_group_permission ADD CONSTRAINT > sf_guard_group_permission_permission_id_sf_guard_permission_id FOREIGN > KEY (permission_id) REFERENCES sf_guard_permission(id) > > Any ideas? I'm using integer(4) for any fields holding sfGuardUser > ids (which fixed it when I was using 1.2 - and was a major pain and > took a long time to find). I tried straight integer as well. > > This is a constraint inside the sfDoctrineGuard plugin, isn't it? > > And yes, I'm clearing the cache. Etc. Is there a special unblemished > version of sfDoctrineGuard I need to use? > > It burns me that it runs locally. Actually, kills me. > > Thanks for any input. >
-- 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.