plugin-icon

Count Pagination Fix for MySQL

Door leendertvb·
Fix for pagination issues under MySQL v8.0 and later where SQL_CALC_FOUND_ROWS and FOUND_ROWS are no longer supported.
count
FOUND_ROWS
mysql
Waardering
Een beoordeling toevoegen
Versie
1.1.5
Actieve installaties
10
Laatst bijgewerkt
Oct 21, 2025
Count Pagination Fix for MySQL

As per MySQL documentation the FOUND_ROWS function in conjunction with the SQL_CALC_FOUND_ROWS function are deprecated as of MySQL version 8.0.17. This causes the pagination in WordPress to be broken, both in the front-end as well as in the back-end, resulting in just showing page 1 only.

This plugin solves the issue WordPress is facing when run under newer versions of MySQL database. By hooking into the query that is used to calculate the number of found posts, we return the right amount of posts found so the pagination can be built up correctly again.

Gratisop Business abonnement
Aan de slag
Door te installeren, ga je akkoord met de Servicevoorwaarden van WordPress.com en de voorwaarden voor plugins van derden.
Getest tot
WordPress 6.8.3
Deze plugin kan worden gedownload, zodat je hem op je kan gebruiken.
Downloaden