Pagination with group by return oci_execute(): ORA-00979: not a GROUP BY expression

Check the SQL statement, then you may know something.
https://codeigniter4.github.io/CodeIgnit...ql-queries

If you get ORA-00979, the SQL statement is wrong.
So you need to fix the SQL statement.

> event good without pagination from models.

What do you mean?


i tried, without pagination, and its execute well. no error without ->paginate()
is there other ->groupBy() 
to grouping on builder?

---

        return $this;

Code:

$this->builder()
            ->select(‘name, address’)
            ->selectSum('TOTAL’)
            ->groupBy(‘name’, ‘address')
            ->limit($limit,  $offset);

        return $this;

Hi Kenjis, thanks for pointing me out.
its done by change : 
 

Code:

->groupBy(‘name’, ‘address')

into 
 -
  ->groupBy(‘name,address')