php - Symfony sfDoctrineGuard 插入 SQL 错误 1005

Question

我刚刚安装了带有 Doctrine ORM 的 Symfony 1.4。

我正在寻找安装插件 sfDoctrineGuard。我按照这里的说明进行操作: http://www.symfony-project.org/plugins/sfDoctrineGuardPlugin

在这一步之前一切正常:symfony主义:insert-sql

当我收到错误时:

SQLSTATE[HY000]: General error: 1005 Can't create table 'kickboxing.#sql-2b5b_a8f' (error 150) Failing Query "ALTER TABLE profile ADD CONSTRAINT profile_sf_guard_user_id_sf_guard_user_id FOREIGN KEY (sf_guard_user_id) REFERENCES sf_guard_user(id)

它似乎确实创建了一些表:

简介sf_guard_忘记密码sf_guard_groupsf_guard_group_permissionsf_guard_permissionsf_guard_remember_keysf_guard_用户sf_guard_用户组sf_guard_user_permission

有什么想法吗？

更新:我发现这确实与学说/symfony 无关。问题似乎出在 mysql 上，我在 MySQL 中运行了上面的 alter 命令，当然我得到了同样的错误。

作为引用，我已经安装了 Debian Squeeze 和 mysql 5。

更新2:当我运行时

SHOW INNODB STATUS;

我明白

---

LATEST FOREIGN KEY ERROR

110927 7:58:35 Error in foreign key constraint of table _kickboxing/#sql-2b5b_a86: FOREIGN KEY (sf_guard_user_id) REFERENCES sf_guard_user(id): Cannot find an index in the referenced table where the referenced columns appear as the first columns, or column types in the table and the referenced table do not match for constraint. Note that the internal storage type of ENUM and SET changed in tables created with >= InnoDB-4.1.12, and such columns in old tables cannot be referenced by such columns in new tables. See http://dev.mysql.com/doc/refman/5.1/en/innodb-foreign-key-constraints.html for correct foreign key definition.

Answer 1

看起来像是 mySql 问题。您可以通过登录 mysql 控制台并运行来获得错误的完整(更好)描述

show innodb status

然后查找最新的外键错误以了解出了什么问题