#20448·phpmyadmin

[Bug]: Pagination count is not accurate

Author: liviuconcioiuCreated Aug 24, 2026Updated Sep 5, 2026
LabelsBug

Describe the bug

Pagination count is not accurate when using WHERE and also when there are hundreds of thousands of rows.

It adds 1 more page than it should.

How to Reproduce

  1. Go to https://demo.phpmyadmin.net/master-config/public/index.php?route=/database/structure&db=world&server=1

  2. Run:

sql
CREATE TABLE `test` (
  `id` int(10) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=FIXED;

INSERT INTO `test` (`id`) SELECT `seq` FROM seq_1_to_982289;

SELECT * FROM `test` WHERE `id` >= 82290;
  1. Go to last page

Expected behavior

Exact pagination count.

Screenshots

https://github.com/user-attachments/assets/c2dc1eab-7858-4564-b7e3-4326815f5dd0

Database Server

MariaDB

phpMyAdmin version

5.2.4-dev, 6.0.0-dev