为什么我在Symfony 1.4上使用Doctrine进行“验证失败”？

Question

I have the following error while importing some data via Doctrine :

value1:19.022542
value2:497.795
value3:9466.541667
Caught exception: Validation failed in class DataPerDay

  27 fields had validation errors:

    * 1 validator failed on value1 (type)
    * 1 validator failed on value2 (type)
    * 1 validator failed on value3 (type)

I don't understand this validation error !! The fields are of type float, what could be going on here ?

schema.yml :

DataPerDay:
  connection: doctrine
  tableName: xp_data_per_day
  columns:
    id:
      type: integer(4)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: true
    inverter_id:
      type: integer(4)
      fixed: false
      unsigned: false
      primary: false
      notnull: true
      autoincrement: false
    (...)
    value1:
      type: float
      fixed: false
      unsigned: false
      primary: false
      notnull: false
      autoincrement: false
    (...)

Weirder still, I have the error on the production environnent, not on localhost :(

EDIT : in BaseDataPerDayFormFilter.class.php, the validators are :

'value1'      => new sfValidatorSchemaFilter('text', new sfValidatorNumber(array('required' => false))),

Is this ok ?

Answer 1

The error was not in schema.yml, but in databases.yml :

prod:
  doctrine:
    class: sfDoctrineDatabase
    param:
      profiler: false
      dsn: 'mysql:host=xxx.net;dbname=xxx'
      port: 3306
      username: xxx
      password: xxx
      encoding: UTF8
      attributes:
        quote_identifier: false
        use_native_enum: false
        idxname_format: %s_idx
        seqname_format: %s_seq
        tblname_format: %s
        validate: all

I don't know where this "validate: all" came from, but it was what was creating those errors.