Issue:%TOTALPAGES% is incorrect when allowUnlimitedResults=true

From FollowTheScore
Revision as of 08:43, 28 July 2010 by Nx (talk | contribs) (Problem: source of the problem)
Jump to: navigation, search
Description:
Extension / Version: DPL   /   ?
Type / Status: Bug   /   open

Problem

If you set allowUnlimitedResults to true (the global variable doesn't work, so I did it in DPLSetup.php), and use count to limit a query, %TOTALPAGES% will be limited (i.e. if you set the count to 10 and there are more than 10 pages, it will still be 10, i.e. the same as %PAGES%) -- Nx / talk 07:34, 28 July 2010 (UTC)

I think I know what the problem is, you forgot SQL_CALC_FOUND_ROWS, see http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#function_found-rows -- Nx / talk 07:43, 28 July 2010 (UTC)

Reply