What am I doing wrong? I keep getting errors rebuilding and also importing
fixtures..

Schema
# config/doctrine/schema.yml
Organization:
  actAs: { Timestampable: ~ }
  columns:
    sf_guard_user_id: { type: integer(5) }
    name: { type: string(255), notnull: true, unique: true }
    first_name:   { type: string(255) }
    last_name:    { type: string(255), notnull: true }
    phone:        { type: string(20) }
    mobile:       { type: string(20) }
    email:        { type: string(255), notnull: true }
    logo:         { type: string(255) }
    is_active:    { type: boolean, notnull: true, default: 1 }
  relations:
    User:
      class: sfGuardUser
      type: one


Error:

>> doctrine  created tables successfully



  SQLSTATE[HY000]: General error: 1005 Can't create table
'./zd2/#sql-6d40_252e2.frm' (errno: 150). Failing Query: "ALTER TABLE
organization ADD CONSTRAINT organization_sf_guard_user_id_sf_guard_user_id
FOREIGN KEY (sf_guard_user_id) REFERENCES sf_guard_user(id)". Failing Query:
ALTER TABLE organization ADD CONSTRAINT
organization_sf_guard_user_id_sf_guard_user_id FOREIGN KEY
(sf_guard_user_id) REFERENCES sf_guard_user(id)

-- 
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.

Reply via email to