Hi,
Looks like a SQL Problem. You should get a detailed explained error,
when you try to execute this query directly to your database:
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)
Maybe your online database is not correctly configured or has an old
version or it is somehow broken due to former deployment attempts?
If the database does not include real data yet, then you might drop
all of your tables and recall the build script.
- Frank
Am 11.01.2010 um 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
.
--
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.
