Biasanya error paging terjadi ketika ada query yang memakai distinct pad laravel, disini saya pake laravel 5.8
tambahkan ini
$columns
$total = $this->getCountForPagination($columns);
pada /var/www/html/lpse/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php
ubntuk querynya
$dt = $sql->distinct(‘namatabel’)->paginate(5,[‘namatabel’]);
semoga berguna
referensi :
- https://github.com/laravel/framework/pull/27107/commits/b982a4d2c65673648c67ee82e5b5d2d6bcb20efb
- https://stackoverflow.com/questions/41283083/distinct-with-pagination-in-laravel-5-2-not-working
- http://jtdz-solenoids.com/stackoverflow_/questions/41283083/distinct-with-pagination-in-laravel-5-2-not-working