MySql - problem "Column 2 is not numeric" Opcje

[laresistance]

Mam taki skrypcik w modelu a wywala mi błąd "Column 2 is not numeric".
Ktoś ma pojęcie o co chodzi?

[PHP] pobierz, plaintext 
    function jakasFunkcja()
    {
        $data = array();
        $data[] = array('Rok','Miesiąc','Ilość');
        $query = "SELECT 
                to_char(data_aaa, 'YYYY') AS rok,
                to_char(data_aaa, 'MM') AS miesiac,
         	count(1) as ilosc
        FROM ".$this->APP->config->getVar('db_tables','tabeleczka')."
        WHERE to_char(data_aaa, 'YYYY')='11' AND to_char(data_aaa, 'MM') ='2010'
        GROUP by rok, miesiac
        ORDER BY ilosc DESC";
        //var_dump($query);
        //echo $query;
        $result = $this->APP->db->query($query);
        if (DB::isError($result))
            die($result->getDebugInfo());
 
        while ($row = $result->fetchRow())
        {
            $tmp = array();
            $tmp[] = $row[0];
            $tmp[] = (int)$row[1];
            $tmp[] = (int)$row[2];
 
            $data[] = $tmp;
        }
 
 
        return json_encode($data);
[PHP] pobierz, plaintext 

[bpskiba]

A w taki sposób

[PHP] pobierz, plaintext 
$query = "SELECT
                            year(data_aaa) AS rok,
                            month(data_aaa) AS miesiac,
                            count(1) as ilosc
                       FROM ".$this->APP->config->getVar('db_tables','tabeleczka')."
                      WHERE year(data_aaa)=2010 AND month(data_aaa) =7
                      GROUP by rok, miesiac
                      ORDER BY ilosc DESC";
[PHP] pobierz, plaintext 

[laresistance]

próbowałem, nie działa

[bpskiba]

czemu nie działa?
Jaki błąd powstaje?

[toaspzoo]

count(1) as ilosc

?

[laresistance]

coś źle z tym countem?