"Undefined index: result" - When calling Model aggregation methods

[jmshelby]

When I try to call any of the Model's aggregate functions (static calls to count, min, max, sum ...) I get this error message from the Builder.

In this example I have a simple class called Characters extending your base model, and its empty (no specialization code). Here is the logged output of the results array from the call to collection->aggregate()

(
    [errmsg] => no such cmd: aggregate
    [bad cmd] => Array
        (
            [aggregate] => characters
            [pipeline] => Array
                (
                    [0] => Array
                        (
                            [$group] => Array
                                (
                                    [_id] => 
                                    [*] => Array
                                        (
                                            [$sum] => 1
                                        )

                                )

                        )

                )

        )

    [ok] => 0
)

[jmshelby]

Okay -- digging into this more, it turns out that the aggregate function in MongoDB is new as of version 2.2 (of the mongod service). So if you're using this package, you'll want make sure you're using the latest version of the service.

@jenssegers --> Might be good to add this to the documentation ;)

If you're on ubuntu, like I am, you need to install from the 10Gen aptitude repo, as the default one (just using apt-get install mongodb) will give you a quite older version, 2.0.4 in my case.

http://docs.mongodb.org/manual/reference/method/db.collection.aggregate/