3. http://stackoverflow.com/questions/22748000/mongodb-2-6-0-rc2-and-php-1-4-5-find-id-in
    5. A simple query like this:
    7. $a = array('_id' => array( '$in' => array_values($ids) ) );
    8. var_dump($a);
    9. $cursor2 = $data->find( $a );
    10. works in mongodb 2.4.9, however, in 2.6.0-rc2 returns this:
    12. Type: MongoCursorException
    13. Code: 17287
    14. Message: Can't canonicalize query: BadValue $in needs an array
    15. The output from var_dump:
    17. array(1) {
    18.  ["_id"]=>
    19.  array(1) {
    20.    ["$in"]=>
    21.    array(10) {
    22.      [0]=>
    23.      object(MongoId)#57 (1) {
    24.        ["$id"]=>
    25.        string(24) "52214d60012f8aab278eacb6"
    26.      }
    27.      [1]=>
    28.      object(MongoId)#58 (1) {
    29.        ["$id"]=>
    30.        string(24) "52214d60012f8aab278eaca8"
    31.      }
    32.      [2]=>
    33.      object(MongoId)#59 (1) {
    34.        ["$id"]=>
    35.        string(24) "52214d60012f8aab278eaca7"
    36.      }
    37.   }
    38. }
    39. }
    40. I wonder if this is a Mongo or PHP related?
    42. THanks!
    44. php mongodb mongodb-php
    45. shareimprove this question
    46. asked Mar 30 '14 at 18:28
    48. Pavel
    49. 1831112
    50. add a comment
    51. 2 Answers
    52. active oldest votes
    53. up vote
    54. 9
    55. down vote
    56. This... is a change in MongoDB 2.6.0, no longer accepting bson object in the $in clause.
    58. This particular issue is being tracker as a PHP driver bug at https://jira.mongodb.org/browse/PHP-1051
    60. The MongoDB PHP Driver will serialize an PHP Array into BSON Array (accepted by the $in operator) when the PHP array is: Sequential numerically indexed, starting from 0
    62. This means that if you have an array like:
    64. $array = array($id0, $id1, $id2, $id3, $id4);
    65. and then you
    67. unset($array[0]);
    68. You actually wind up with:
    70. $array = array(1 => $id1, 2 => $id2, 3 => $id3, 4 => $id);
    71. Which does not start with index 0. The MongoDB PHP driver therefore converts this into a BSON Object... Leading to validation error in MongoDB as it expected an array.
    73. Now, since the MongoDB PHP driver does not do parse your MongoDB query we cannot know which array should be exempted from this serialization rule.
    75. The workaround is, as mentioned above, is to ensure your PHP arrays are numerically indexed, starting from 0. The easiest way to do that is to run
    77. array_values($values);
    78. shareimprove this answer
    79. edited Jul 31 at 9:43
    81. Kevin Yan
    82. 586315
    83. answered Apr 9 '14 at 0:49
    85. bjori
    86. 1,276158
    88. -1 Sorry, but check the code in question, array_values is used already. - Imran Naqvi Aug 28 '14 at 9:52
    90. This answer helped me with a problem I had using jenssegers/laravel-mongodb vendor for Laravel. I am posting an issue on their Gitgub account with a reference to this answer for support. Thanks! - rayVenues Sep 30 '14 at 12:28
    91. add a comment
    93. up vote
    94. 2
    95. down vote
    96. After debugging it with mongo, I've noticed the following:
    98. ... query: { _id: { $in: { 0: ObjectId('52214d60012f8aab278eaad1') ...
    100. but it should be
    102. ... query: { _id: { $in: [ ObjectId('52214d60012f8aab278eaad1') ...
    104. So, I would suggest doing array_values($VAR) before calling $in, I'm guess Mongo 2.4.9 is more lenient to the fact that $ids can be either object or an array, make sure you use arrays in mongo 2.6 ;)
    106. shareimprove this answer
    107. answered Apr 3 '14 at 21:35
    109. Pavel
    110. 1831112
    112. nice catch with array_values - Thiago F Macedo Apr 24 '14 at 13:17
    114. -1, Sorry but please check in the code, array_values is used. - Imran Naqvi Aug 28 '14 at 9:50
    115. add a comment