Active Record - Group by DATE_FORMAT()

[eluser]Karinsson[/eluser]
I know this is an old thread but i ran into the exact same problem, found this page on the first google search, and the fix above did not solve it.

It worked for me by simply parsing the group_by parameter as an array instead of a string as the comma in the DATE_FORMAT function will cause the string to be exploded.

Parsing a SQL function as a string returns an error (if the string has one or more commas)

Code:

$this->db->group_by("DATE_FORMAT(date, '%x-%v')";

// Generates GROUP BY DATE_FORMAT(date, `'%x-%v')`

Parsing a SQL function in an array does not

Code:

$this->db->group_by(array("DATE_FORMAT(date, '%x-%v')");

// Generates GROUP BY DATE_FORMAT(date, '%x-%v')