Cakephp 2.0 weird array_merge error when using contain

Question

I have a weird error when using contain to limit my data to only what I need. Here is my contain

$this->Movie->contain(array(
        'Review' => array(
            'fields' => array('id', 'title', 'spoilers', 'body', 'created'),
            'User' => array(
                'fields' => array('id', 'username'),
                'Profile' => array('fields' => array('id', 'image_thumb_small'))
            ),
            'order' => 'Review.created DESC',
            'limit' => 2,
        ),
        'Movieupdates' => array(
            'User' => array('Profile' => array('fields' => 'image_thumb_small')),
            'order' => 'Movieupdates.created DESC',
            'limit' => 2
        ),
        'Actor' => array(
            'fields' => array('name', 'slug', 'image_thumb'),
        ),
        'Genre' => array(
            'fields' => array('name', 'id'),
        )
    ));

The problem is that Cakephp throws me two errors:

Warning (2): array_merge() [function.array-merge]: Argument #1 is not an array [CORE\Cake\Model\Behavior\ContainableBehavior.php, line 400]

Warning (2): array_unique() expects parameter 1 to be array, null given [CORE\Cake\Model\Behavior\ContainableBehavior.php, line 400]

I think the problem has to do with the following line (in contain: Review -> User):

'fields' => array('id', 'username'),

If I remove that everything is fine, but then again I dont want all the data from User, especially not the passwords so I have to limit that.

What is wrong with my Contain? The error suggest that I should be using an array somewhere, but I have no idea where.

Edit added query outcome

Not sure this is your problem but, I don't think you can use any conditions like order and limit. Those are supposed to be in your `find()` statement. Only use conditions and fields. — Tim Joyce, Dec 08 '12 at 13:26
You actually can use order and limit in contain. It works and there is actually an example in the Cakebook that uses an order in a contain array: http://book.cakephp.org/2.0/en/core-libraries/behaviors/containable.html So I doubt that is the problem, I am using read() instead of find(). But that should also not cause the problem.... — Dakuipje, Dec 08 '12 at 13:32
Okay, I do see order is in there but I do not see limit, http://api20.cakephp.org/view_source/containable-behavior#line-302 lines 302 - 314 — Tim Joyce, Dec 08 '12 at 13:34
Hmm I see, but deleting the limit doesnt solve my problem. Weird thing is the limit is actually working quite well in the contain...... — Dakuipje, Dec 08 '12 at 13:44
Nothing else really sticks out. Have you tried using the dot syntax for those fields, `'fields' => array('User.id', 'User.username')` — Tim Joyce, Dec 08 '12 at 13:49
Can you try something for a sec. Remove the nested `Profile` array and just use `'User' => array('id', 'username')`? I'm thinking, if that works, you can do `'User' => array('id', 'username', 'Profile.id', 'Profile. image_thumb_small')` — Tim Joyce, Dec 08 '12 at 14:00
That creates the exact same error. This also creates the same error: `'User' => array('fields' => array('id', 'username'))` — Dakuipje, Dec 08 '12 at 14:06
No, without the `fields` index... just `'User' => array('id', 'username')`... Or maybe that's what you are saying you did — Tim Joyce, Dec 08 '12 at 14:08
But the nested Profile array does its job just fine, weird cause it seems like the exact same piece of code...... — Dakuipje, Dec 08 '12 at 14:09
Just delete your Profile table... It's 1 to 1 anyway... you don't need it... half kidding :D — Tim Joyce, Dec 08 '12 at 14:11
Maybe do a `pr($this->Movie->find('first'));` and let us see the output of that.. Maybe there is something we are missing that we would see with that — Tim Joyce, Dec 08 '12 at 14:14
Haha, with the ammount of profile options I have I really want to keep them separate .... — Dakuipje, Dec 08 '12 at 14:16
I added the pr outcome in the question. Now that I look at that it seems like the Contain is actually working, but I still get the errors :S I deleted the passwords. — Dakuipje, Dec 08 '12 at 14:23
Yes, it is working. However, It appears that Profile is not working. — Tim Joyce, Dec 08 '12 at 14:33
Yeah i just noticed it. Actually did forget an array, guess ive been coding for too many straight hours. Thnx a lot :) — Dakuipje, Dec 08 '12 at 14:34

score 1 · Answer 1 · answered Dec 08 '12 at 14:33

1

Solved it, I had an error in my contain. Stupid one.

'User' => array('Profile' => array('fields' => 'image_thumb_small')),

Should have been:

'User' => array('Profile' => array('fields' => array('image_thumb_small'))),

answered Dec 08 '12 at 14:33

Dakuipje

91
5

Cakephp 2.0 weird array_merge error when using contain

1 Answers1