CREATE TABLE IF NOT EXISTS `test` (
`id` int(11) NOT NULL,
`test` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
INSERT INTO `test` (`id`, `test`) VALUES
(1, '1'),
(2, '1');
SELECT * FROM `test` GROUP BY test
This query yields one row, but the message above the table says there are 2 rows. This also affects the calculation of the number of pages, so you can go to pages that don't actually exist.
Fix: https://github.com/phpmyadmin/phpmyadmin/pull/1135