I'm having problems with innerJoins with i18n tables, the doctrine not
putting the schema name in front table names..

my query is:

 //busca as amenidades do hotel
    $q = new Doctrine_Query();
    $q->from('HotelFacility hf')
      ->innerJoin('hf.HotelFacilityType hft')
      ->innerJoin('hf.FacilityType ft')
     # ->innerJoin('hft.Translation hft8')
     # ->innerJoin('ft.Translation fttran')
      ->where('hf.hotel_id = ? and hf.value IS TRUE ', $this->id );

It's generating the sql:

SELECT
b.hotel_facility_type_id AS b__hotel_facility_type_id,
b.hotel_id AS b__hotel_id, b.facility_type_id AS b__facility_type_id,
b.value AS b__value, b2.id AS b2__id, b2.facility_type_id AS
b2__facility_type_id,
b2.type AS b2__type, b3.id AS b3__id
FROM booking.hotel_facility b
INNER JOIN booking.hotel_facility_type b2 ON b.hotel_facility_type_id
= b2.id
INNER JOIN booking.facility_type b3 ON b.facility_type_id = b3.id
WHERE (b.hotel_id = ? AND b.value IS TRUE)

but if I uncomment the innerJoin of translation tables, the table no
include the booking ( schema )

SELECT
b.hotel_facility_type_id AS b__hotel_facility_type_id, b.hotel_id AS
b__hotel_id, b.facility_type_id AS b__facility_type_id, b.value AS
b__value,
b2.id AS b2__id, b2.facility_type_id AS b2__facility_type_id, b2.type
AS b2__type, b3.id AS b3__id,
h.id AS h__id, h.name AS h__name, h.created_at AS h__created_at,
h.updated_at AS h__updated_at,
h.lang AS h__lang, f.id AS f__id, f.name AS f__name, f.created_at AS
f__created_at,
f.updated_at AS f__updated_at, f.lang AS f__lang
FROM booking.hotel_facility b
INNER JOIN booking.hotel_facility_type b2 ON b.hotel_facility_type_id
= b2.id
INNER JOIN booking.facility_type b3 ON b.facility_type_id = b3.id
INNER JOIN hotel_facility_type_translation h ON b2.id = h.id ---- NOT
USING SCHEMA
INNER JOIN facility_type_translation f ON b3.id = f.id  ---- NOT USING
SCHEMA
WHERE (b.hotel_id = ? AND b.value IS TRUE)

Is it a bug??

HotelFacilityType:
  tableName: booking.hotel_facility_type
  actAs:
    Timestampable: ~
    I18n:
      fields: [name, created_at, updated_at]
......

FacilityType:
  tableName: booking.facility_type
  actAs:
    Timestampable: ~
    I18n:
      fields: [name, created_at, updated_at]
.......

Couldn't hydrate. Found non-unique key mapping named 'lang'.

On 22 jun, 17:39, Nei Rauni Santos <nra...@gmail.com> wrote: