I am trying to use getPage with rowboat to dump all rows in a custom table. The table has a total of 96 rows. I have specified &limit=`5` and &limit=`25` and for each the appropriate number of rows is returned but there are no paging controls generated. The[[+page.nav]] UL is empty.
I have read another thread that indicated moving the MODx installation to a different server may solve this problem. Unfortunately that is not an option for me.
I added var_dump($properties); to the end of the getPage snippet, here is the array:
array<br /> ’namespace’ => string ’’ (length=0)<br /> ’limit’ => int 5<br /> ’offset’ => int 0<br /> ’page’ => int 1<br /> ’pageVarKey’ => string ’page’ (length=4)<br /> ’totalVar’ => string ’total’ (length=5)<br /> ’pageLimit’ => int 5<br /> ’elementClass’ => string ’modSnippet’ (length=10)<br /> ’pageNavVar’ => string ’page.nav’ (length=8)<br /> ’pageNavTpl’ => string ’<li><a href=""></a></li>’ (length=78)<br /> ’pageActiveTpl’ => string ’<li><a class="active" href=""></a></li>’ (length=116)<br /> ’pageFirstTpl’ => string ’<li class="control"><a href="">First</a></li>’ (length=76)<br /> ’pageLastTpl’ => string ’<li class="control"><a href="">Last</a></li>’ (length=75)<br /> ’pagePrevTpl’ => string ’<li class="control"><a href=""><<</a></li>’ (length=79)<br /> ’pageNextTpl’ => string ’<li class="control"><a href="">>></a></li>’ (length=79)<br /> ’cache’ => boolean false<br /> ’cache_key’ => string ’resource’ (length=8)<br /> ’cache_handler’ => string ’xPDOFileCache’ (length=13)<br /> ’cache_expires’ => int 0<br /> ’element’ => string ’Rowboat’ (length=7)<br /> ’table’ => string ’ccutbl_bob_umpschd’ (length=18)<br /> ’sortBy’ => string ’id’ (length=2)<br /> ’tpl’ => string ’EventSchdRpt.Umpdata.Tpl’ (length=24)<br /> ’total’ => boolean false<br /> ’toPlaceholder’ => string ’’ (length=0)<br /> ’qs’ => &<br /> array<br /> empty<br /> ’pageCount’ => int 1<br /> ’firstItem’ => int 1<br /> ’lastItem’ => int 0<br /> ’pageUrl’ => string ’index.php?id=31’ (length=15)
PageCount says 1, it should be 20.
Any help you can provide will be appreciated.
Thanks.