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.
