Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

node.js - MongoError: Can't canonicalize query: BadValue bad order array [2]

I have a database with the following document structure:

{
    "_id" : ObjectId("520bea012ab230549e749cff"),
    "Day" : 1,
    "Time" : 54,
    "State" : "Vermont",
    "Airport" : "BTV",
    "Temperature" : 39,
    "Humidity" : 57,
    "Wind Speed" : 6,
    "Wind Direction" : 170,
    "Station Pressure" : 29.6,
    "Sea Level Pressure" : 150
}

I need to find the most high 'Temperature' for each 'State' (i.e. e.g. there are 100 document with 'State':'Vermont') and add entry 'month_high':true into this document (that has the most high temperature)

Here is my code: http://pastebin.com/UbACLbSF

But when I run the program in shell I get the following error:

MongoError: Can't canonicalize query: BadValue bad order array [2]

like image 309
Dennis Avatar asked Aug 14 '15 17:08

Dennis


1 Answers

You should be passing in an object, not an array

cursor.sort({"State": 1, "Temperature": -1});
like image 134
Yuri Zarubin Avatar answered Sep 27 '22 17:09

Yuri Zarubin