Also, try making loc_type a big int because I bleieve that 100200000 might
be to large a number for a regular int

2009/9/28 Paul Richert <[email protected]>

> Hello everyone,
> I get an "validation error" when i try to load my fixtures. The error is
> a "type error".
> In the attechment i send you the schema.yml and the fixtures file.
>
> When I do a "doctrine:build-all-reload" symfony only imports the first
> entry in the fixtures an then quits with a validation error on the
> "loc_type" field.
>
> We are many people working on the same project, but I'm the only one
> getting this error.
>
> I'm usind symfony 1.28 on PHP 5.2.6 and mysql 5.0.75 on an Ubuntu 9.04
> (64Bit) System.
>
> I hope anyone can help me.
> Thanks to everyone.
>
> >
>
> Location:
>  Location_1:
>    loc_id: '105'
>    loc_type: '100200000'
>    level: '0'
>    name: Deutschland
>    slug: deutschland
>    population: null
>    root_id: '1'
>    lft: '1'
>    rgt: '10636'
>    latitude: null
>    longitude: null
>  Location_2:
>    loc_id: '117'
>    loc_type: '100300000'
>    level: '1'
>    name: Nordrhein-Westfalen
>    slug: nordrhein-westfalen-bundesland
>    population: '17996621'
>    root_id: '1'
>    lft: '2'
>    rgt: '10635'
>    latitude: '0'
>    longitude: '0'
>  Location_3:
>    loc_id: '181'
>    loc_type: '100400000'
>    level: '2'
>    name: Düsseldorf
>    slug: duesseldorf-regierungsbezirk
>    population: null
>    root_id: '1'
>    lft: '3'
>    rgt: '1536'
>    latitude: '0'
>    longitude: '0'
>  Location_4:
>    loc_id: '182'
>    loc_type: '100400000'
>    level: '2'
>    name: Köln
>    slug: koeln-regierungsbezirk
>    population: null
>    root_id: '1'
>    lft: '1537'
>    rgt: '5518'
>    latitude: '0'
>    longitude: '0'
>  Location_5:
>    loc_id: '183'
>    loc_type: '100400000'
>    level: '2'
>    name: Münster
>    slug: muenster-regierungsbezirk
>    population: null
>    root_id: '1'
>    lft: '5519'
>    rgt: '6648'
>    latitude: '0'
>    longitude: '0'
>  Location_6:
>    loc_id: '180'
>    loc_type: '100400000'
>    level: '2'
>    name: Detmold
>    slug: detmold-regierungsbezirk
>    population: null
>    root_id: '1'
>    lft: '6649'
>    rgt: '8176'
>    latitude: '0'
>    longitude: '0'
>  Location_7:
>    loc_id: '179'
>    loc_type: '100400000'
>    level: '2'
>    name: Arnsberg
>    slug: arnsberg-regierungsbezirk
>    population: null
>    root_id: '1'
>    lft: '8177'
>    rgt: '10634'
>    latitude: '0'
>    longitude: '0'
>  Location_8:
>    loc_id: '422'
>    loc_type: '100500000'
>    level: '3'
>    name: Düsseldorf
>    slug: duesseldorf-landkreis
>    population: null
>    root_id: '1'
>    lft: '4'
>    rgt: '79'
>    latitude: '51.2167'
>    longitude: '6.76667'
>
> detect_relations: false
> Location:
>  columns:
>    loc_id:
>      type: integer(11)
>      notnull: true
>    loc_type:
>      type: integer(11)
>      notnull: true
>    level:
>      type: integer(11)
>      notnull: true
>    name:
>      type: string(255)
>      notnull: true
>    slug:
>      type: string(255)
>      notnull: true
>    population:
>      type: integer(11)
>      notnull: false
>  actAs:
>    NestedSet:
>      hasManyRoots: true
>      rootColumnName: root_id
>    Geographical:
>  indexes:
>    nestedset:
>      fields: [lft,rgt,level]
>    slug:
>      fields: [slug]
>    loc_id:
>      fields: [loc_id]
>    name:
>      fields: [name]
>    loc_type:
>      fields: [loc_type]
>



-- 
Gareth McCumskey
http://garethmccumskey.blogspot.com
twitter: @garethmcc

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"symfony users" group.
To post to this group, send email to [email protected]
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