I found this http://jonocode.wordpress.com/2009/07/11/adding-sf_guard_user_profile-to-the-sfdoctrineguardplugin/ but still get the issue, can't fix it...
My complete schema and eror are here http://pastebin.com/m4a2812bd in case anyone wants to help.. thanks.. On Mon, Feb 8, 2010 at 3:07 PM, Filipe <filipepimentasi...@gmail.com> wrote: > 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<symfony-users%2bunsubscr...@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.