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

        return $this;

Code:

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

        return $this;

Hi, im new to this forum, i tried to make pagination,  everything work without group by.  
can i get some help?

im using 4.4.6 version.

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

ci-phpunit-test | CodeIgniter Testing Guide | CodeIgniter 3 to 4 Upgrade Helper

Hi Kenjis, thanks for reply.
i tried to var dump. and show query looks fine.

event good without pagination from models. any specific Hints?

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?

ci-phpunit-test | CodeIgniter Testing Guide | CodeIgniter 3 to 4 Upgrade Helper

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')

See https://codeigniter4.github.io/CodeIgnit...er-groupby

ci-phpunit-test | CodeIgniter Testing Guide | CodeIgniter 3 to 4 Upgrade Helper