HABTM CakePHP no results for related model

Question

I have problem with HABTM models. When I try to fetch any related model f.e. like this:

$this->Tagi->find('first');

I dont get any results for associated model. Result looks like this:

array(
    'Tagi' => array(
        'id' => '1',
        'nazwa' => 'sth'
        ),
    'Instytucje' => array()
)

I am sure that there should be result, I've double checked it, even

$this->Tagi->getDataSource()->getLog(false, false) 

shows correct query, that fetches right results. If you have any idea whats wrong plz give me a hint.

Tagi model:

public $hasAndBelongsToMany = array(
    'Instytucje' =>
        array(
            'className' => 'Instytucje.Instytucje',
            'joinTable' => 'instytucje-tagi',
            'foreignKey' => 'tag_id',
            'associationForeignKey' => 'instytucja_id',
            'unique'=> true
        )
);

Instytucje model:

public $hasAndBelongsToMany = array(
    'Tagi' =>
        array(
            'className' => 'Instytucje.Tagi',
            'joinTable' => 'instytucje-tagi',
            'foreignKey' => 'instytucja_id',
            'associationForeignKey' => 'tag_id',
            'unique'=> true
        )
);

EDIT: Main problem is that HABTM refers to AppModel causing error:

Error: Table app_models for model AppModel was not found in datasource prod.

Which can be bypassed by adding $useTable in AppModel, which results in prior problem.

SOLVED When using naming convention far beyond this Cake use, you have use third model with $useTable pointed on reference table. Moreover its important to correctly point Cake to classes inside plugins.

Answer 1

I think you're problem relates to the fact that you are not using CakePHP's naming conventions. From the look of the query being generated Cake doesn't know how to correctly alias the join table, hence getting an AppModel alias in your query. I suspect that this is causing issues when Cake tries to build the results array from the query.

This might not work, but try creating a model for the joins table called InstytucjeTagi; then update your associations to use this using the with key:-

Tagi model:

public $hasAndBelongsToMany = array(
    'Instytucje' =>
        array(
            'className' => 'Instytucje.Instytucje',
            'joinTable' => 'instytucje-tagi',
            'with' => 'InstytucjeTagi',
            'foreignKey' => 'tag_id',
            'associationForeignKey' => 'instytucja_id',
            'unique'=> true
        )
);

Instytucje model:

public $hasAndBelongsToMany = array(
    'Tagi' =>
        array(
            'className' => 'Instytucje.Tagi',
            'joinTable' => 'instytucje-tagi',
            'with' => 'InstytucjeTagi',
            'foreignKey' => 'instytucja_id',
            'associationForeignKey' => 'tag_id',
            'unique'=> true
        )
);

If this doesn't fix it try using the afterFind() callback in the Tagi model to check what Cake is returning:-

afterFind($results, $primary = false) {
    parent::afterFind($results, $primary);
    // Print out the $results to check what Cake is returning.
    debug($results);
    return $results;
}