PluginSift
PluginsThemesCompare
Directory
  • Plugins
  • Themes
  • Compare Plugins
Plugin Comparisons
  • SEO
  • Security
  • Ecommerce
  • Page Builders
  • Caching
  • Backup
  • Forms
  • Analytics
Resources
  • About
  • Contact
  • llms.txt

© 2026 PluginSift. Data sourced from WordPress.org. · [email protected]

  1. Home
  2. Plugins
  3. Count
  4. Count Pagination Fix for MySQL
Count Pagination Fix for MySQL icon

Count Pagination Fix for MySQL

Fix for pagination issues under MySQL v8.0 and later where SQL_CALC_FOUND_ROWS and FOUND_ROWS are no longer supported.

By leendertvb·Count·Free
00
·10 active installs·Updated 5 months ago
DownloadCompare

As of April 2026, Count Pagination Fix for MySQL is a WordPress count plugin with 10 active installations and a 0/5 rating0. It has been downloaded 1.4K+ times in total. Requires WordPress 6.0+ and PHP 7.0+. Available on WordPress.org since 2024. Top alternative: Simple Download Monitor.

0/5Rating
10active installs
1.4K+total downloads
2 yearssince 2024

Overview

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.

Read full description on WordPress.org

Ratings & Reviews

00 reviews
5 ★
0
4 ★
0
3 ★
0
2 ★
0
1 ★
0

Compatibility

WordPress6.0+ requiredTested up to 6.8.5
PHP7.0+ required

Top Alternatives to Count Pagination Fix for MySQL

Simple Download Monitor icon
Simple Download Monitor
4.620K+ installsUpdated 1 week ago
ViewCompare
Post View Count icon
Post View Count
4.64.0K+ installsUpdated 7 months ago
ViewCompare
GravityWP – Count icon
GravityWP – Count
52.0K+ installsUpdated 5 months ago
ViewCompare
AJAX Hits Counter + Popular Posts Widget icon
AJAX Hits Counter + Popular Posts Widget
4.91.0K+ installsUpdated 5 years ago
ViewCompare
Posts Character Count Admin icon
Posts Character Count Admin
4.31.0K+ installsUpdated 11 years ago
ViewCompare
View all count plugins →

Frequently Asked Questions

Changelog

1.1.5

Release date: 2025-10-21

Confirmed compatibility with WordPress 6.8.3.

View full changelog on WordPress.org

Contributors

jorisvstjorisvstleendertvbleendertvbarnodeleeuwarnodeleeuw
Plugin Info
Version
1.1.5
Last Updated
Oct 21, 2025
WP Requires
6.0+
Tested Up To
6.8.5
PHP Requires
7.0+
Active Installs
10
Downloads
1.4K+
Added
Feb 13, 2024
Business
Free

Tags

countmysqlfound_rowspaginationsql_calc_found_rows

Developer

L
leendertvb
2 plugins0.0M+ total installs
View all plugins →

Quick Compare

Count Pagination Fix for MySQL vs Simple Download Monitor→Count Pagination Fix for MySQL vs Post View Count→Count Pagination Fix for MySQL vs GravityWP – Count→

Plugin data sourced from WordPress.org. Analysis and metrics by PluginSift.