Problem with Zend_Paginator and group by in query

[silasrm]

Hi guys,

Zend_Paginator has a serious error when using group by in query. He loses himself by counting the lines.
Simples solution: reset count after cloning query.

// Zend/Paginator/Adapter/DbSelect.php:207
$rowCount = clone $this->_select;
$rowCount->__toString(); // Workaround for ZF-3719 and related
$rowCount->reset(Zend_Db_Select::LIMIT_COUNT); // <--- this

[BorislavSabev]

@silasrm you realize that ZF1 is End-Of-Life since the 28th of September 2018, right?
Noone will ever act on this issue.

[froschdesign]

@BorislavSabev
We leave this type of issue report open, such as help for others.