Details

    • Type: Bug Bug
    • Status: Open
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: I18n
    • Labels:
      None
    • Environment:
      Symfony 1.4.0, PHP 5.2.6 & 5.3.1

      Description

      hi everyone

      I'm trying to use the Doctrine i18n behavior but ... something wrong happen!

      I have this Doctrine_Connection_Mysql_Exception :

      SQLSTATE[42S22]: Column not found: 1054 Unknown column 'p.label' in 'field list' ( ie : linked screenshot )

      with this request :


      Doctrine_Query::create()->from('OrderProduct o')
      ->leftJoin('o.Product p')
      ->addWhere('o.order_id = ?', $currentOrderId)
      ->orderBy('o.created_at ASC')
      ->execute();

      I don't understand why doctrine try to get the label field from "Product", this field is in the Translation table :s

      Here an extract from my schema.yml :

      Product:
      tableName: product
      actAs:
      I18n:
      fields: [label, label_2]
      columns:
      code:

      {type: string(64), notnull: true, primary: true}

      label:

      {type: string(64)}

      label_2:

      {type: string(64)}

      i don't know if my problem is in my code ( i don't think ), in Doctrine or in Symfony implementation of doctrine and thats why i post this message.

      If you want more details ask me I have one working copy "freezed" just for this bug ( and for my work i use a system without i18n behavior :s )

      thx in advance

        Activity

        There are no comments yet on this issue.

          People

          • Assignee:
            Jonathan H. Wage
            Reporter:
            Fabien MEYNARD
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated: