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

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

kenjis
Administrator
Posts: 3,671
Threads: 96
Joined: Oct 2014
Reputation: 231

04-13-2024, 08:11 PM

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

Messages In This Thread

Pagination with group by return oci_execute(): ORA-00979: not a GROUP BY expression - by just - 04-12-2024, 01:31 PM

RE: Pagination with group by return oci_execute(): ORA-00979: not a GROUP BY expression - by kenjis - 04-12-2024, 06:09 PM

RE: Pagination with group by return oci_execute(): ORA-00979: not a GROUP BY expression - by just - 04-13-2024, 08:00 PM

RE: Pagination with group by return oci_execute(): ORA-00979: not a GROUP BY expression - by kenjis - 04-13-2024, 08:11 PM

RE: Pagination with group by return oci_execute(): ORA-00979: not a GROUP BY expression - by just - 04-13-2024, 08:36 PM

RE: Pagination with group by return oci_execute(): ORA-00979: not a GROUP BY expression - by kenjis - 04-13-2024, 08:56 PM