joomla/joomla-cms — pull request #4330 by Bakual (2014-09-23 21:09:38+00:00)
Title: Clear limit for list count

Unfortunately https://github.com/joomla/joomla-cms/pull/3945 introduced a bug with pagination in `com_content` category view (list and blog). As soon as you change the page, the pagination vanishes.

The reason is that we now also pass the `limit` and `offset` properties of the query object to the `_getListCount` method. For some reason I couldn't tackle down yet those are set in `com_content` but not in other extensions like `com_contact` or `com_weblinks`.

However to get the count we should not use any limits anyway. It does make no sense to run a query `SELECT COUNT(*) LIMIT 10, 20`. Thus we should be able to safely clear the limit part since we want an unlimited total list anyway.

Please test with various lists if this doesn't introduce yet another unexpected side effect...