Re: belongsToMany issue

Il giorno lunedì 26 ottobre 2015 18:19:01 UTC+1, John Andersen ha scritto:

Check your model associations - is any of them relying on CakePHP identifying the keys?
Check your queries - is any of them specifying the offending column?

Enjoy, John

On Monday, 26 October 2015 18:44:29 UTC+2, lorenzoshake wrote:

i 've a strange assoc problem:

class Achievements

{

        $this->belongsToMany('SocialUsers', [

            'foreignKey' => 'achievement_id',

            'targetForeignKey' => 'user_id',

            'joinTable' => 'achievements_users',

            'through'=>'AchievementsUsers'

        ]);

 ...

if i delete all cache i raise error:

 Column not found: 1054 Unknown column 'AchievementsUsers.social_user_id' in 'field list' 

but if i reload the page all works fine ( until the next cache delete)

It's like targetForeignKey was not readed first time execution.

I've a lot of this belongsToMany but only here there is this issue

Some suggests?!

if do  a query:

$user =  SocialUsers->find()->where(...)contain( ... 'Achievements')->first(); 

if I remove 'Achievements' from contain  all works fine

the assotiation in SocialUsers is:

$this->belongsToMany('Achievements', [

'className'=>'Achievements',

            'joinTable' => 'achievements_users',

            'foreignKey' => 'user_id',

            'targetForeignKey'=>'achievement_id',

            

        ]);

don't know why doesn't works with Achievments in contain!

--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP

---
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscribe@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/d/optout.