same problem here

On Feb 8, 7:16 pm, Samuel Morhaim <samuel.morh...@gmail.com> wrote:
> 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