mongodb $and expression must be a nonempty array

Question

I'm new to mongo and I'm getting an error. Both $user_id and $this->_id are non empty (valid mongo id).

$criteria = array( 
    '$and' => array( 
        array('parent_id' =>$this->_id), 
        '$or' => array(
            array('user_id' => $user_id),
            array('from_user_id' => $user_id)
        )               
    ) 
);

the error says

$and expression must be a nonempty array

Any clue?

Neil Lunn · Accepted Answer · 2014-04-10 08:16:46Z

3

You have not defined your array properly:

$criteria = array(
  '$and' => array(
    array('parent_id' => $this->_id ),
    array('$or' => array(
      array('user_id' => $user_id ),
      array('from_user_id' => $user_id ) 
    ))

) );

Try to check your structures before submitting as a query to make sure they format as you expect:

echo json_encode( $criteria, JSON_PRETTY_PRINT ) ."\n";

answered Apr 10, 2014 at 8:16

Neil Lunn

151k36 gold badges356 silver badges327 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

kriscondev Over a year ago

Thanks for this answer. I know now how to validate the structure of my query by using json_encode with JSON_PRETTY_PRINT

Collectives™ on Stack Overflow

mongodb $and expression must be a nonempty array

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related