try to delete all tables and next symfony:doctrine.... Gabo
2010/1/11 Mike Church <mchu...@gmail.com> > 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<symfony-users%2bunsubscr...@googlegroups.com> > . > For more options, visit this group at > http://groups.google.com/group/symfony-users?hl=en. > > > >--
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.
