This forum is in READ-ONLY mode.
You can look around, but if you want to ask a new question, please use the new forum.
Home » support » symfony 1.3 and 1.4 » Doctrine actAs: i18n
Doctrine actAs: i18n [message #103320] Fri, 30 July 2010 20:42
fmeynard  is currently offline fmeynard
Messages: 2
Registered: July 2010
Location: Bordeaux
Junior Member
hi everyone Smile

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)}


If someone have an idea Very Happy

Thx in advance

Previous Topic:createing embeded form
Next Topic:one model with different forms
Goto Forum:
  

powered by FUDforum - copyright ©2001-2004 FUD Forum Bulletin Board Software