Although this topic seams not to be new at all, I stuck with it now
for two days:
I have a working application with the sfDoctrineGuard plugin.
Now I want to extend the user table using a model which extends the
user-informations.

I get an error when trying to build-all using this schema:

sf_guard_user_profile:
  actAs: [Timestampable]
  className: sfGuardUserProfile
  columns:
    id:
      type: integer(4)
      primary: true
      autoincrement: true
    user_id:
      type: integer(4)
      primary: true
    first_name: string(20)
    last_name: string(20)
    email: string(255)
  relations:
    sfGuardUser:
      local: user_id
      onDelete: CASCADE


Error
Message
  SQLSTATE[HY000]: General error: 1005 Can't create table
'quickfit.#sql-53d_28f' (errno: 150). Failing Query: "ALTER TABLE
sf_guard_user_profile ADD CONSTRAINT
sf_guard_user_profile_user_id_sf_guard_user_id FOREIGN KEY (user_id)
REFERENCES sf_guard_user(id) ON DELETE CASCADE". Failing Query: ALTER
TABLE sf_guard_user_profile ADD CONSTRAINT
sf_guard_user_profile_user_id_sf_guard_user_id FOREIGN KEY (user_id)
REFERENCES sf_guard_user(id) ON DELETE CASCADE



-- 
If you want to report a vulnerability issue on symfony, please send it to 
security at symfony-project.com

You received this message because you are subscribed to the Google
Groups "symfony users" group.
To post to this group, send email to symfony-users@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

Reply via email to