[TYPO3-core] RFC #9861: Second page of results in list-module with ordering flaw

Christoph Niewerth niwi at schwarzbu.ch
Thu Jan 22 17:44:52 CET 2009


Christian Kuhn wrote:
> Hi.
> 
> I found a solution to solve this bug without additional db queries. Here 
> is a new RFC with proper description.
> 
> 
> This is a SVN patch request.
> 
> Type: Bugfix
> 
> Branches: trunk, 4.2-branch
> 
> Bugtracker Reference: http://bugs.typo3.org/view.php?id=9861
> 
> Problem:
> If you have more than 20 content elements you get browser [21 - xx]
> If you click you are on the second page.
> The first item (is item no.21) misses an up-icon for sorting.
> If you click on the up-sorting of item no.22 it will be no.1 and not 
> visible on this page.
> See attached screenshot.
> 
> Solution:
> For proper sorting of the first two elements on page > 1 the uids of the 
> last and second last elements of the previous page must be known and 
> initialized to $prevUid and $prevPrevUid.
> The patch lets makeQueryArray() fetch two more rows (LIMIT 18,103 
> instead of 20,101), and initializes the two variables with the uids from 
> the first two rows.
> 
> 
> Cheers
> Christian
> 
> ------------------------------------------------------------------------
> 

+1 on reading
+1 testing on trunk


More information about the TYPO3-team-core mailing list