views:

10

answers:

0

Hi.

For a form I want to retrieve all entries of a table. Therefore I use the getChoices method of the sfWidgetFormDoctrineChoice class.

    protected function getPaymentTypes(){
    $typesWidget = new sfWidgetFormDoctrineChoice(
        array(
            'model'=>'PaymentType',
            'method'=>'getName',
            'order_by'=>array('name','desc')
        )
    );

The app is under i18n, so the *payment_type* table has just the ID field - all the data like the "name"-field is in the translation table: *payment_type_translation*

Why is Symfony/Doctrine creating a wrong sql-query and returns a "Undefined column" Error?

SELECT b.id AS b_id, b.name AS b_name FROM payment_type b