Thank's to everyone. That resolves my problem. But I still have one question:
Why is my system the only one which has this problem? Gareth McCumskey schrieb: > Instead of loc_type: '100200000' try loc_type: 100200000 (no > quotes). Your database might not be allowing you to insert a string > (which is what it might interpret it as) if the field type is only for > integers. > > 2009/9/28 Paul Richert <[email protected] > <mailto:[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 -~----------~----~----~----~------~----~------~--~---
