[TYPO3-mvc] IRRE and intermediate tables

[Franz Koch]

Hey,

> When i read this message i think that extbase work with an IRRE
> intermediate table, but not ... wiht me ;)

yes, it's working, but only if used correctly ;)

> Here is my TCA:
>
> 'tours' =>  array(
> 	'exclude' =>  0,
> 	'l10n_mode' =>  'exclude',
> 	'label' =>  'Tours',
> 	'config' =>  array(
> 		'type' =>  'inline',
> 		'foreign_table' =>  'tx_pucapi_domain_model_tourperformance',
> 		'foreign_field' =>  'uid_foreign',
> 		'foreign_label' =>  'uid_local',
> 		'maxitems' =>  99999
> 	),
> ),
>
> The backend work nicely, but in FE, I have an SQL error:
>
> Unknown column 'tx_pucapi_domain_model_tour.uid_foreign' in 'where clause'


This is no configuration for a intermediate table, but one for NOT using 
one and directly map the foreign_table using the field 
tx_pucapi_domain_model_tourperformance.uid_foreign as relation field. 
It's strange that this config is working in the BE correctly as you say.

In order to use a intermediate (MM) table, you have to configure it in 
your TCA (see "MM" section in [1]).

[1] 
http://typo3.org/documentation/document-library/core-documentation/doc_core_api/4.3.0/view/4/2/#id2529282

-- 
kind regards,
Franz Koch