Re: [symfony-users] Re: sfDoctrineGuardPlugin fails query upon doctrine:build --all

2010-06-05 Thread James Wheaton
I tried this out; the sfGuardUserProfile part of my config/doctrine/schema.yml looks like this: sfGuardUserProfile: tableName: sf_guard_user_profile columns: user_id: type: bigint(20) notnull: true default: unsigned: false primary: false unique: false

[symfony-users] Re: sfDoctrineGuardPlugin fails query upon doctrine:build --all

2010-06-05 Thread pghoratiu
Taking a look at plugins/sfDoctrineGuardPlugin/config/doctrine/schema.yml, all of the id columns use integer(4). Isn't this what the user_id type should be? = It should be type: integer(4) columns: user_id: type: integer(4) notnull: true gabriel -- If you want

[symfony-users] Re: sfDoctrineGuardPlugin fails query upon doctrine:build --all

2010-06-04 Thread pghoratiu
Not sure if this solves it, check the type of data for id's used in FK references in the schema: int(4) or int It should be of the same type for the FK to work. gabriel On Jun 3, 11:25 pm, Wheaton, James S jwhea...@purdue.edu wrote: I’m in the midst of updating to symfony 1.4.1-stable; using

[symfony-users] Re: sfDoctrineGuardPlugin fails query upon doctrine:build --all

2010-06-04 Thread slau
I had that too quite a while ago. The corresponding user_id fields need to have the same field definition. There was a change from INT(11) to BIGINT My profile schema looks now like that and everything is fine. sfGuardUserProfile: tableName: sf_guard_user_profile columns: user_id: