In order for your relationships to autocomplete, you must follow naming
patterns. So if you have a class named User and Contact and Contact has a
user_id, it can auto complete the relationship definition. Another example
would be User.user_profile_id = UserProfile.id

- Jon

On Wed, Nov 26, 2008 at 3:09 AM, Necho <[EMAIL PROTECTED]> wrote:

>
> Hello!
>
> I have a problem with my schema.yml. When i start the command line :
> symfony doctrine:build-all, I have an error :
>
> sqlstate 42000 Syntax error or access violation: 1072 Key column
> 'envdomaine_id doesn't exist in table. Failing query.
>
> My schema.yml :
>
> Envdomaine:
>  tableName:            envdomaine
>  columns:
>    id:
>      type:             integer(8)
>      notnull:          true
>      autoincrement:    true
>      primary:          true
>    DesignationDomaine:
>      type:             string(40)
>    Remarque:
>      type:             string(2147483647)
>    created_at:
>      type:             timestamp
>    updated_at:
>      type:             timestamp
>    EnrARCHIVE:
>      type:             boolean
>      notnull:          true
>  relations:
>    Envpersonnel:
>      local:            id
>      foreign:          Domaine_id
>    Envservice:
>      local:            id
>      foreign:          Domaine_id
>    Envsite:
>      local:            id
>      foreign:          Domaine_id
>  options:
>    type: INNODB
>
> Envpersonnel:
>  tableName:            envpersonnel
>  columns:
>    id:
>      type:             integer(8)
>      notnull:          true
>      autoincrement:    true
>      primary:          true
>    NumeroPersonnel:
>      type:             string(25)
>    InitialesPersonnel:
>      type:             string(6)
>    NomPersonnel:
>      type:             string(40)
>    PrenomPersonnel:
>      type:             string(30)
>    Domaine_id:
>      type:             integer(8)
>    Service_id:
>      type:             integer(8)
>    Site_id:
>      type:             integer(8)
>  relations:
>    Envdomaine:
>    Envservice:
>    Envsite:
>  options:
>    type: INNODB
>
> Envservice:
>  tableName:            envservice
>  columns:
>    id:
>      type:             integer(8)
>      notnull:          true
>      autoincrement:    true
>      primary:          true
>    CodeService:
>      type:             string(40)
>    DesignationService:
>      type:             string(80)
>    Domaine_id:
>      type:             integer(8)
>  relations:
>    Envdomaine:
>    Envpersonnel:
>      local:            id
>      foreign:          Service_id
>  options:
>    type: INNODB
>
> Envsite:
>  tableName:            envsite
>  columns:
>    id:
>      type:             integer(8)
>      notnull:          true
>      autoincrement:    true
>      primary:          true
>    DesignationSite:
>      type:             string(80)
>    Domaine_id:
>      type:             integer(8)
>  relations:
>    Envdomaine:
>    Envpersonnel:
>      local:            id
>      foreign:          Site_id
>  options:
>    type: INNODB
>
> Help me please !
> >
>


-- 
Jonathan H. Wage
Open Source Software Developer & Evangelist
http://www.jwage.com
http://www.doctrine-project.org
http://www.symfony-project.org

--~--~---------~--~----~------------~-------~--~----~
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 [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/symfony-users?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to