Put the having clause after the group by clause to resolve this upstream issue:

http://dev.kohanaframework.org/issues/2923

1 files changed, 4 insertions, 4 deletions

diff --git a/system/libraries/Database_Builder.php b/system/libraries/Database_Builder.php
index 62b2a163..e86ce379 100644
--- a/system/libraries/Database_Builder.php
+++ b/system/libraries/Database_Builder.php
@@ -1021,14 +1021,14 @@ class Database_Builder_Core {
 			$sql .= "\n".'WHERE '.$this->compile_conditions($this->where);
 		}
 
-		if ( ! empty($this->having))
+		if ( ! empty($this->group_by))
 		{
-			$sql .= "\n".'HAVING '.$this->compile_conditions($this->having);
+			$sql .= "\n".'GROUP BY '.$this->compile_group_by();
 		}
 
-		if ( ! empty($this->group_by))
+		if ( ! empty($this->having))
 		{
-			$sql .= "\n".'GROUP BY '.$this->compile_group_by();
+			$sql .= "\n".'HAVING '.$this->compile_conditions($this->having);
 		}
 
 		if ( ! empty($this->order_by))