Docstoc

Zend Framework Issue Tracker

Document Sample
Zend Framework Issue Tracker Powered By Docstoc
					Zend Framework Issue Tracker
Displaying 174 issues at 03/Mar/13 7:18 PM.
     Project          Key                     Summary              Issue Type     Status   Priority     Resolution
Zend Framework ZF-12497 Zend\Custom\Paginator\Adapter\DbSele Bug                Closed     N/A      Issue Moved
                             ct not reseting order in count()




                                                                                                                     1 of 868
Zend Framework   ZF-9731   Zend_Paginator::toJson() returns an        Bug   Open   Major   Unresolved
                           object of objects instead of an array of
                           objects




                                                                                                        2 of 868
Zend Framework   ZF-10318 Paginator requires Adapter in constructor Improvement   Open   Minor   Unresolved




Zend Framework   ZF-10571 Zend_Paginator limitation of the use of   Bug           Open   Major   Unresolved
                          cache backends




                                                                                                              3 of 868
Zend Framework   ZF-10165 Zend_Paginator should clear previous   Improvement   Open   Major   Unresolved
                          page data




Zend Framework   ZF-10298 Zend_Pagination_Adapter_Array          Bug           Open   Major   Unresolved
                          getItems functions resets array keys




                                                                                                           4 of 868
Zend Framework   ZF-8072   Add getItemsByPageRange function       Improvement               Closed   Minor   Won't Fix




Zend Framework   ZF-5348   Rewrite Zend_Paginator_DbSelect &      Unit Tests: Improvement   Closed   Major   Won't Fix
                           Zend_Paginator_DbTableSelect tests for
                           all database adapters




                                                                                                                         5 of 868
Zend Framework   ZF-7588   Expose sorting/grouping functionality   Improvement   Closed   Minor   Won't Fix
                           from pagination adapters




                                                                                                              6 of 868
Zend Framework   ZF-10599 Wrong limit statement when using   Bug   Open   Major   Unresolved
                          db_select and paginator




                                                                                               7 of 868
Zend Framework   ZF-10659 Zend_Paginator_Adapter_DbSelect         Bug   Open   Major   Unresolved
                          incorrect items on the last page with
                          mssql




                                                                                                    8 of 868
Zend Framework   ZF-6461   Split                                  Improvement   Closed   N/A   Duplicate
                           Zend_Db_Table_Row_Abstract::findDep
                           endentRowset to allow direct access to
                           the Zend_Db_Table_Select object




                                                                                                           9 of 868
Zend Framework   ZF-12211 Zend_Paginator Cache with DbSelect   Bug   Open   Major   Unresolved
                          adapter




                                                                                                 10 of 868
Zend Framework   ZF-11318 Zend_Paginator cache ( related to ZF-   Bug   Closed   Major   Duplicate
                          10447 )




                                                                                                     11 of 868
Zend Framework   ZF-6989   Zend_Paginator DbSelect should not use Bug   Resolved   Major   Fixed
                           Select object in serialization




                                                                                                   12 of 868
Zend Framework   ZF-10447 Paginator and cache   Bug   Closed   Major   Duplicate




                                                                                   13 of 868
Zend Framework   ZF-11668 Zend_Paginator still buggy in release-   Bug   Closed   Major   Duplicate
                          1.11.7




                                                                                                      14 of 868
Zend Framework   ZF-11996 Invalid query is generated by DbAdapter Bug   Open   Major   Unresolved
                          for queries grouped by aliases




                                                                                                    15 of 868
Zend Framework   ZF-8441   Wrong count of records when using       Bug   Resolved   Major   Fixed
                           DISTINCT in paginator's select object




                                                                                                    16 of 868
Zend Framework   ZF-9947   Zend_Paginator - problem with   Bug   Reopened   Minor   Unresolved
                           _getCacheInternalId




                                                                                                 17 of 868
Zend Framework   ZF-11777 Zend_Paginator_Adapter_Interface -   Improvement   Open   Minor   Unresolved
                          getItems()'s param




                                                                                                         18 of 868
Zend Framework   ZF-11765 A query with group by and sum() does   Bug             Open       Major   Unresolved
                          not show any result




Zend Framework   ZF-11417 Example code not valid in [Getting     Docs: Problem   Resolved   Major   Fixed
                          Started with Zend_Paginator]




                                                                                                                 19 of 868
Zend Framework   ZF-10704 Zend_Paginator_Adapter_DbSelect   Bug   Resolved   Major   Fixed
                          empty binds




                                                                                             20 of 868
Zend Framework   ZF-11682 Paginator DBselect adapter not propperly Bug   Open   Major   Unresolved
                          counting rows when using DISTINCT()




                                                                                                     21 of 868
Zend Framework   ZF-4032   Paginator DBselect adapter not propperly Improvement   Resolved   Major   Fixed
                           counting rows when using DISTINCT()




                                                                                                             22 of 868
Zend Framework   ZF-11672 Paginator SerializableLimitIterator throws Bug   Open   Major   Unresolved
                          OutOfBoundsException




                                                                                                       23 of 868
Zend Framework   ZF-11572 Problem with Zend_Paginator and Cache Bug   Open   Major   Unresolved




                                                                                                  24 of 868
Zend Framework   ZF-11429 Zend_Paginator_Adapter_DbSelect             Bug           Open      Major   Unresolved
                          returns incorrect results after page 1 on
                          DB2 IBM i/iSeries/AS/400




Zend Framework   ZF-7661   add method setViewPartial                  Improvement   Postponed Minor   Unresolved
                           setScrollingStyle




                                                                                                                   25 of 868
Zend Framework   ZF-11305 Zend_Paginator - getItemsByPage()        Bug   Closed   Major   Duplicate
                          does not return the right number of item
                          for the last page using
                          Zend_Paginator_Adapter_DbSelect and
                          MSSQL




                                                                                                      26 of 868
Zend Framework   ZF-7434   Too many pages with empty content   Bug   Resolved   Major   Fixed




                                                                                                27 of 868
Zend Framework   ZF-11242 Zend_Paginator + Cache + Adapters   Bug   Open   Major   Unresolved
                          DbSelect or DbTableSelect




                                                                                                28 of 868
Zend Framework   ZF-7203   DB Select object doest not work with   Bug   Open   N/A   Unresolved
                           Paginator if UNION is applied in the
                           query




                                                                                                  29 of 868
Zend Framework   ZF-10947 Zend_Paginator_Adapter_DbSelect-        Bug   Resolved   Critical   Fixed
                          >getCountSelect() - the count query
                          produced by this method fails if the
                          original Zend_Db_Select contains "order
                          by" (and using
                          Zend_Db_Adapter_Sqlsrv)




                                                                                                      30 of 868
Zend Framework   ZF-11040 paginator should be flexible with table   Performance Improvement   Open       Major   Unresolved
                          with a lots of data




Zend Framework   ZF-11087 Zend/Paginator tests flawed with oci8     Unit Tests: Problem       Resolved   Major   Fixed
                          turn off




                                                                                                                              31 of 868
Zend Framework   ZF-10260 Zend_Paginator adapter's count()-       Bug   Open   Major   Unresolved
                          method is called twice when using the
                          paginationcontrol view helper




                                                                                                    32 of 868
Zend Framework   ZF-8886   Improve lazy loading of page count   Improvement   Open   Major   Unresolved




                                                                                                          33 of 868
Zend Framework   ZF-10884 Zend_Paginator - Row count column not Bug   Resolved   Major   Fixed
                          found




                                                                                                 34 of 868
Zend Framework   ZF-7316   Cleaning all the code   Coding Standards Violation   Resolved   Trivial   Fixed




                                                                                                             35 of 868
Zend Framework   ZF-10747 Trying to pass extra parameters to   Docs: Problem   Resolved   Major   Not an Issue
                          Pagination Link.




                                                                                                                 36 of 868
Zend Framework   ZF-9989   Zend_Paginator_Adapter_DbSelect::set   Improvement   Resolved   Trivial   Not an Issue
                           RowCount




                                                                                                                    37 of 868
Zend Framework   ZF-10643 Zend_Paginator_Adapter_Interface   Bug   Resolved   Trivial   Fixed
                          contains commented count()




                                                                                                38 of 868
Zend Framework   ZF-10555 Segmentation fault on tests   Unit Tests: Problem   Closed   Major   Not an Issue




                                                                                                              39 of 868
Zend Framework   ZF-10582 Zend_PaginatorTest::testArrayAccessIn   Bug   Closed   Major   Fixed
                          ClassSerializableLimitIterator failed




                                                                                                 40 of 868
Zend Framework   ZF-10390 _getCacheInternalId() only uses adapter Bug   Resolved   Major   Fixed
                          name not values




Zend Framework   ZF-8476   lastItemNumber is greater than        Bug    Closed     Minor   Fixed
                           totalItemCount when using
                           Zend_Paginator_Adapter_Null




                                                                                                   41 of 868
Zend Framework   ZF-9174   Default Page Range                  Improvement   Resolved   Trivial   Fixed

Zend Framework   ZF-9940   Zend_Paginator get the same Cache   Bug           Closed     Major     Fixed
                           Data




                                                                                                          42 of 868
Zend Framework   ZF-10261 Zend_Paginator adapter's count()-       Bug           Closed     Major     Duplicate
                          method is called twice when using the
                          paginationcontrol view helper




Zend Framework   ZF-10180 Add Default Page Range As Static        Improvement   Resolved   Trivial   Duplicate
                          Property




                                                                                                                 43 of 868
Zend Framework   ZF-10187 Zend_View_Helper_Partial clears        Bug    Resolved   Major   Not an Issue
                          Variable on Clone




Zend Framework   ZF-9396   Zend_Paginator::getItem doesn't handle Bug   Resolved   Major   Fixed
                           pages returned as
                           Zend_Paginator_SerializableLimitIterator
                           correctly




                                                                                                          44 of 868
Zend Framework   ZF-9920   Zend_Paginator should offer        New Feature    Resolved   N/A     Duplicate
                           setDefaultPageRange()




Zend Framework   ZF-5785   Zend_Paginator should offer        New Feature    Resolved   Major   Fixed
                           setDefaultItemCountPerPage()




Zend Framework   ZF-10127 Wrong return type of                 Improvement   Resolved   Major   Fixed
                          Zend_Paginator_AdapterAggregate::get
                          PaginatorAdapter()




                                                                                                            45 of 868
Zend Framework   ZF-4936   multiple paginator instances with the   Improvement   Postponed Major   Unresolved
                           same view script




                                                                                                                46 of 868
Zend Framework   ZF-5189   Zend_Paginator_Adapter_DbSelect - no Improvement   Resolved   Major   Fixed
                           way to bind data to placeholders




                                                                                                         47 of 868
Zend Framework   ZF-9935   Same cache in Zend_Paginator for   Bug           Resolved   Critical   Fixed
                           different items




Zend Framework   ZF-7732   Zend_Pageinator :                  Improvement   Closed     Major      Fixed
                           clearPageItemCache()'s var
                           "$cleanTags" is not required.




                                                                                                          48 of 868
Zend Framework   ZF-8019   Zend_Paginator get Cache ID Error    Bug   Resolved   Major   Fixed




Zend Framework   ZF-7379   Problem with Zend_Paginator Cache.   Bug   Resolved   Major   Fixed




                                                                                                 49 of 868
Zend Framework   ZF-8731   Zend_Paginator bug with caching   Bug   Resolved   Critical   Fixed




                                                                                                 50 of 868
Zend Framework   ZF-5376   Allow Zend_Paginator to Accept An      Improvement   Resolved   Major   Fixed
                           Infinite Item Count Per Page




Zend Framework   ZF-8656   getPagesInRange($lowerBound,            Bug          Resolved   Blocker Fixed
                           $upperBound) gets floats passed instead
                           of int




                                                                                                           51 of 868
Zend Framework   ZF-4233   Add support for modules to                      Improvement                  Resolved   Major     Fixed
                           PaginationControl




Zend Framework   ZF-9029   Multiple files in library/ or in tests/ don't   Coding Standards Violation   Resolved   Trivial   Fixed
                           have the svn:keywords=id




                                                                                                                                     52 of 868
Zend Framework   ZF-7335   Multiple files in library/ or in tests/ don't   Coding Standards Violation   Resolved   Trivial   Fixed
                           have the svn:keywords=id




                                                                                                                                     53 of 868
Zend Framework   ZF-8126   using cache with paginator                Bug              Closed     Major   Not an Issue




Zend Framework   ZF-5476   ZF-5442 Fix all spelling, grammar and     Sub-task: Docs   Resolved   Minor   Won't Fix
                           formatting issues for Zend_Paginator in
                           the reference guide




                                                                                                                        54 of 868
Zend Framework   ZF-8992   Zend_Paginator and cache. How can I        Community Driven Feature   Closed   Major   Not an Issue
                           read the datas that I have sent to cache




                                                                                                                                 55 of 868
Zend Framework   ZF-9260   Paginator (NULL adapter) fails when   Bug   Resolved   Major   Duplicate
                           number of items is 0.




                                                                                                      56 of 868
Zend Framework   ZF-4151   Iterator with zero items throws   Bug   Resolved   Major   Fixed
                           OutOfBoundsException




                                                                                              57 of 868
Zend Framework   ZF-5278   Zend_Paginator_Adapter_DbSelect           Bug   Resolved   Major   Fixed
                           throws 'Integrity constraint violation'
                           when tables with distinct and foreign
                           keys are joined




                                                                                                      58 of 868
Zend Framework   ZF-5620   Column 'xxx' in field list is ambiguous   Bug                Resolved   Minor     Fixed




Zend Framework   ZF-8728   incorrect case in code example to create Docs: Improvement   Resolved   Trivial   Won't Fix
                           a Zend_Cache instance

Zend Framework   ZF-7686   Default view for Zend_Paginator should    Improvement        Closed     Major     Incomplete
                           offer




                                                                                                                          59 of 868
Zend Framework   ZF-8084   Segmentation Fault with             Bug   Resolved   Major   Fixed
                           Zend_Paginator_Adapter_Iterator +
                           Zend_Cache




Zend Framework   ZF-7689   Paginator DBSelect Adapter          Bug   Closed     Major   Not an Issue




                                                                                                       60 of 868
Zend Framework   ZF-7259   problem method getCountSelect()         Bug    Closed     Major     Not an Issue




Zend Framework   ZF-7020   Zend_Paginator_ScrollingStyle_Elastic is Bug   Resolved   Trivial   Fixed
                           only "elastic" near first pages, but not
                           near last pages




                                                                                                              61 of 868
Zend Framework   ZF-7127   Problem with Where-clause in select for   Bug   Resolved   Major   Fixed
                           paginator




                                                                                                      62 of 868
Zend Framework   ZF-7615   Zend_Paginator bug   Bug   Closed   Trivial   Not an Issue




                                                                                        63 of 868
Zend Framework   ZF-3719   Using Zend_Db_Table_Select objects     Bug   Resolved   Major   Duplicate
                           with Zend_Paginator throws exception
                           "No table has been specified for the
                           FROM clause"




Zend Framework   ZF-6746   Cache in Zend_Paginator not working    Bug   Resolved   Major   Fixed




                                                                                                       64 of 868
Zend Framework   ZF-7602   Patch to add IteratorAggregate like   Patch   Resolved   Major   Fixed
                           behaviour to Zend_Paginator




                                                                                                    65 of 868
Zend Framework   ZF-7287   Paginator doesn't use                 Bug   Resolved   Critical   Fixed
                           "_defaultItemCountPerPage" and show
                           all items instead of only
                           _itemCountPerPage




                                                                                                     66 of 868
Zend Framework   ZF-7207   Warning: Division by zero   Bug   Resolved   Major   Fixed




                                                                                        67 of 868
Zend Framework   ZF-7299   Zend_Paginator wrong query when   Bug   Closed   Major   Not an Issue
                           getting number of results




                                                                                                   68 of 868
Zend Framework   ZF-3873   Zend_Paginator sets an incorrect     Bug   Resolved   Major   Fixed
                           lastItemNumber when using the Null
                           adapter.




                                                                                                 69 of 868
Zend Framework   ZF-5427   Identify last item of last page   Improvement   Resolved   Minor   Fixed




                                                                                                      70 of 868
Zend Framework   ZF-5341   Zend_View_Helper_PaginationControl::s Docs: Problem   Resolved   Major     Fixed
                           etDefaultViewPartial() documention does
                           not mention that it can take a module in
                           its argument




Zend Framework   ZF-7132   Zend_Pagintor : error with smarty    Docs: Problem    Resolved   Trivial   Fixed
                           integration




                                                                                                              71 of 868
Zend Framework   ZF-7366   Zend_Paginator does not use cached   Bug   Resolved   Major   Duplicate
                           Zend_Db_Select correctly




                                                                                                     72 of 868
Zend Framework   ZF-7100   Zend_Paginator can raise a divide by 0   Bug           Resolved   Major   Fixed
                           warning




Zend Framework   ZF-7046   Clean up DbSelect adapter code           Improvement   Resolved   Minor   Fixed




                                                                                                             73 of 868
Zend Framework   ZF-6562   Zend_Paginator_Adapter_DbSelect fails Bug                Resolved   Major     Fixed
                           on HAVING clause




Zend Framework   ZF-5561   setRowCount() needs more             Docs: Improvement   Resolved   Trivial   Fixed
                           documentation




                                                                                                                 74 of 868
Zend Framework   ZF-6330   Zend_Paginator_Adapter_DbSelect        Bug   Resolved   Critical   Fixed
                           make incorrect SQL query when use join
                           keyword




                                                                                                      75 of 868
Zend Framework   ZF-5295   Failure on Oracle database              Bug             Resolved   Critical   Fixed




Zend Framework   ZF-7045   Refactor building of the count query into Improvement   Resolved   Minor      Fixed
                           its own method in the DbSelect adapter




                                                                                                                 76 of 868
Zend Framework   ZF-5956   Zend_Paginator factory chokes when   Bug   Resolved   Major   Fixed
                           Zend_Db_Select has UNION




                                                                                                 77 of 868
Zend Framework   ZF-6805   Zend_View_Helper_PaginationControl   Improvement   Postponed Major   Unresolved
                           should render with no partial set




                                                                                                             78 of 868
Zend Framework   ZF-5319   Zend_Paginator_Adapter_DbSelect-    Bug   Closed   Minor   Not an Issue
                           >setRowCount() does not behave as
                           expected.




                                                                                                     79 of 868
Zend Framework   ZF-6279   Zend_Paginator Db_Select should use       Improvement   Resolved   Major   Won't Fix
                           FOUND_ROWS by default when using
                           Mysqli adapter




Zend Framework   ZF-4962   An iterator cannot be used with foreach   Bug           Resolved   Major   Won't Fix
                           by reference




                                                                                                                  80 of 868
Zend Framework   ZF-5400   Zend_Paginator_ScrollingStyle_Elastic      Bug   Resolved   Minor   Won't Fix
                           getPages() does not return balanced
                           page ranges for the first and last page.




                                                                                                           81 of 868
Zend Framework   ZF-6812   Zend_Paginator unserialize makes UTF- Bug   Closed   Major   Not an Issue
                           8 chars broken




                                                                                                       82 of 868
Zend Framework   ZF-6794   Constant ROW_COUNT_COLUMN is    Bug   Resolved   Major   Fixed
                           used case-sensitive in method
                           setRowCount().




                                                                                            83 of 868
Zend Framework   ZF-4801   Allow Zend_Paginator to cache its data   Improvement   Resolved   Major   Fixed
                           throught a Zend_Cache_Core instance




Zend Framework   ZF-5676   toJson() method does not working for     Bug           Resolved   Major   Fixed
                           DbTableSelect adapter




                                                                                                             84 of 868
Zend Framework   ZF-5853   Use constant instead of string in    Improvement   Resolved   Trivial   Fixed
                           DbSelect adapter

Zend Framework   ZF-5231   Zend_Paginator_Adapter_DbSelect does Bug           Resolved   Major     Fixed
                           not take into account aliased tables when
                           Zend_Db_Select::DISTINCT is active
                           inside count() method




Zend Framework   ZF-5233   Zend_Paginator_Adapter_DbSelect does Improvement   Resolved   Major     Duplicate
                           not take into account aliased tables when
                           Zend_Db_Select::DISTINCT is active
                           inside count() method




                                                                                                               85 of 868
Zend Framework   ZF-5519   Allow a plugin to process the results from New Feature   Resolved   Major   Fixed
                           the adapter




                                                                                                               86 of 868
Zend Framework   ZF-5397   Zend_Paginator::paginationControl not   Improvement   Resolved   Major   Not an Issue
                           supported when short_open_tag = Off




                                                                                                                   87 of 868
Zend Framework   ZF-5349   Pass null value to      Improvement   Resolved   Minor   Not an Issue
                           setItemCountPerPage()




                                                                                                   88 of 868
Zend Framework   ZF-4878   Allow scrolling style be an object   Improvement   Resolved   Minor   Fixed




                                                                                                         89 of 868
Zend Framework   ZF-4675   Zend_Paginator_Adapter_Interface::getIt Bug   Resolved   Minor   Fixed
                           ems has wrong parameters




                                                                                                    90 of 868
Zend Framework   ZF-4716   Paginator_Adapter_Interface::getItems   Docs: Problem   Resolved   Trivial   Fixed
                           method is commented incorrectly.




Zend Framework   ZF-4607   Allow Paginator's factory to set the   Improvement      Resolved   Minor     Fixed
                           DbTableSelect adapter when supplying a
                           Zend_Db_Table_Select object




                                                                                                                91 of 868
Zend Framework   ZF-4564   Unittests error   Unit Tests: Problem   Resolved   Major   Fixed




                                                                                              92 of 868
Zend Framework   ZF-4613   Passing a Zend_Db_Select Object to   Bug   Resolved   Major   Fixed
                           Zend_Paginator when using Oracle
                           results in an Error




                                                                                                 93 of 868
Zend Framework   ZF-4665   make itemCountPerPage available to       Improvement           Resolved   Minor     Fixed
                           view partials




Zend Framework   ZF-4676   Zend_Paginator_Adapter_Interface is      Docs: Problem         Resolved   Trivial   Fixed
                           missing documentation for count() that
                           used to be there




Zend Framework   ZF-4831   testToJson(Zend_PaginatorTest) unit      Unit Tests: Problem   Resolved   Major     Fixed
                           tests problem




                                                                                                                       94 of 868
Zend Framework   ZF-4683   Add toJson support to Zend_Paginator    Improvement   Resolved   Minor   Fixed


Zend Framework   ZF-4818   function arg validation not deep enought Bug          Resolved   Major   Fixed
                           in Zend_View_Helper_Paginationcontrol




Zend Framework   ZF-4800   setting itemCountPerPage to zero shows Bug            Resolved   Major   Fixed
                           a PHP warning




                                                                                                            95 of 868
Zend Framework   ZF-4794   Zend_Paginator_Adapter_DbSelect_Ora Bug              Resolved   Minor   Fixed
                           cleTest and
                           Zend_Paginator_Adapter_DbTableSelect
                           _OracleTest fails




Zend Framework   ZF-4742   Provide a convenient method to fetch   Improvement   Resolved   Minor   Fixed
                           total number of records




Zend Framework   ZF-4679   Allow page cache to be fetched and     Improvement   Resolved   Minor   Fixed
                           cleared



                                                                                                           96 of 868
Zend Framework   ZF-4640   No mention of DbTable-adapter in       Docs: Problem       Resolved   Major   Duplicate
                           reference guide



Zend Framework   ZF-3809   Update documentation with additional   Docs: Improvement   Resolved   Minor   Fixed
                           info
Zend Framework   ZF-4610   Add Zend_Paginator support to          Improvement         Resolved   Minor   Not an Issue
                           Zend_View_Helper_PartialLoop




                                                                                                                        97 of 868
Zend Framework   ZF-4052   Bug with join queries?             Bug   Resolved   Minor   Not an Issue




Zend Framework   ZF-4094   Row count column not found Error   Bug   Resolved   Major   Fixed




                                                                                                      98 of 868
Zend Framework   ZF-4177   sql syntax exception when paginator         Bug   Resolved   Minor   Fixed
                           used with select-distinct query




Zend Framework   ZF-3727   Clear limitoffset and limitcount parts in   Bug   Resolved   Major   Fixed
                           Dbselect adapter when getting the total
                           items count




                                                                                                        99 of 868
Zend Framework   ZF-3722   Add to paginator possibility to get item   Improvement   Resolved   Minor   Fixed
                           count per page




Zend Framework   ZF-3720   Setting the current page number causes Bug               Resolved   Major   Fixed
                           the items to be fetched prematurely




                                                                                                               100 of 868
Zend Framework   ZF-3944   Class name                              Docs: Improvement   Resolved   Trivial   Fixed
                           Zend_Paginator_Adapter_array
                           inconsistent with ZF Coding Standards




                                                                                                                    101 of 868
Zend Framework   ZF-4001   Zend_Paginator_Adapter_DbSelect         Bug           Resolved   Major   Fixed




Zend Framework   ZF-4512   Zend_Paginator::factory() refactoring   Improvement   Resolved   Minor   Fixed




                                                                                                            102 of 868
Zend Framework   ZF-4519   inconsistent variable names in   Docs: Improvement   Resolved   Major   Fixed
                           Zend_Paginator 34.2.1. example




                                                                                                           103 of 868
Zend Framework   ZF-3775   DbSelect adapter not returning Rowsets Improvement   Resolved   Minor   Fixed
                           on Db_Table_Select




                                                                                                           104 of 868
Zend Framework   ZF-4276   Zend_Paginator with                     Bug   Resolved   Major   Cannot Reproduce
                           Zend_Paginator_Adapter_DbSelect
                           (maybe with others, too) displays all
                           found results on each page




                                                                                                         105 of 868
Zend Framework   ZF-4321   Add Lucene pagination docs            New Feature           Resolved   Minor     Won't Fix




Zend Framework   ZF-4430   Add info to describe passing parameters Docs: Improvement   Resolved   Trivial   Duplicate
                           to the zend paginator partial




                                                                                                                        106 of 868
Zend Framework   ZF-4328   two paginators in same view (bug:      Bug   Resolved   Major   Fixed
                           second paginator has data from first
                           paginator)




                                                                                                   107 of 868
Zend Framework   ZF-4384   Alternative count method for DbSelect   Improvement   Resolved   Major   Won't Fix




                                                                                                                108 of 868
Zend Framework   ZF-4378   Casting to string bug in          Bug   Resolved   Minor   Not an Issue
                           Zend_Paginator_Adapter_DbSelect




                                                                                                     109 of 868
Zend Framework   ZF-4193   Filter / Validate The Page Number on   Improvement   Resolved   Major   Fixed
                           setCurrentPageNumber()




                                                                                                           110 of 868
Zend Framework   ZF-4207   Zend_Paginator should only force         Patch   Resolved   Minor   Fixed
                           adapter results to implement Traversable




                                                                                                       111 of 868
Zend Framework   ZF-4153   The PaginationControl view helper           Improvement   Resolved   Minor   Fixed
                           should check for "paginator", if possible




                                                                                                                112 of 868
Zend Framework   ZF-4176   Add/include user parameters in   New Feature   Resolved   Major   Not an Issue
                           pagination_control




                                                                                                            113 of 868
Zend Framework   ZF-4048   Paginator dies on ->setPageRange(0)   Bug   Resolved   Minor   Won't Fix




                                                                                                      114 of 868
Zend Framework   ZF-3725   Array adapter doesn't preserve keys   Improvement   Resolved   Trivial   Not an Issue




                                                                                                                   115 of 868
Zend Framework   ZF-4154   Change a code example in the               Improvement   Resolved   Trivial   Fixed
                           documentation to better reflect
                           recommended usage




Zend Framework   ZF-4178   Reiterate in documentation that the        Task          Resolved   Minor     Duplicate
                           DbSelect adapter only selects the
                           required rows
Zend Framework   ZF-4037   Default scrolling style not honored        Bug           Resolved   Major     Fixed


Zend Framework   ZF-4179   In fact, just dedicate a whole paragraph   Task          Resolved   Minor     Duplicate
                           to the DbSelect adapter.




                                                                                                                     116 of 868
Zend Framework   ZF-4035   Zend_Paginator lacks an easy way to   Improvement   Resolved   Major   Not an Issue
                           pass search params




Zend Framework   ZF-4031   Can't pass a variable to the          Improvement   Resolved   Major   Not an Issue
                           paginationControl() template




                                                                                                                 117 of 868
Zend Framework   ZF-4029   To Make Data Grid   New Feature   Resolved   Major   Won't Fix




                                                                                            118 of 868
Zend Framework   ZF-3948   I guess Zend_Paginator_Adapter_Array   Bug   Resolved   Minor   Not an Issue
                           is incoherent




                                                                                                          119 of 868
Zend Framework   ZF-3804   Don't assume a fetch mode in the      Bug                          Resolved   Major   Fixed
                           DbSelect adapter




Zend Framework   ZF-3844   Missing one equal sign in Paginator   Coding Standards Violation   Resolved   Minor   Won't Fix
                           component




                                                                                                                             120 of 868
Zend Framework   ZF-3822   Paginator Control Example error   Bug   Resolved   Minor   Fixed




                                                                                              121 of 868
Zend Framework   ZF-3760   Incorrect query being used with      Bug   Resolved   Major   Duplicate
                           PostgreSQL, Zend_Db_Select and order
                           by




Zend Framework   ZF-3778   DbSelect Adapter Counting rows.     Bug    Resolved   Major   Duplicate




                                                                                                     122 of 868
Zend Framework   ZF-3740   Counting results does not work in   Bug   Resolved   Major   Fixed
                           postgresql with order by in query




                                                                                                123 of 868
Zend Framework           ZF-3737       Setting itemCountPerPage after     Bug   Resolved   Major   Fixed
                                       setCurrenPageNumber gives wrong
                                       results




Generated at Sun Mar 03 19:18:02 UTC 2013 using JIRA 4.4.3#663-r165197.




                                                                                                           124 of 868
         Assignee             Reporter    Created          Updated         Resolved
Frank Brückner      Richard Rumpel       1/3/2013 16:59   1/3/2013 17:54   1/3/2013 17:10




                                                                                            125 of 868
Unassigned   Guillaume ORIOL   4/22/2010 2:00   11/20/2012 21:38




                                                                   126 of 868
Unassigned   Saman Darougheh           8/15/2010 13:50   11/20/2012 21:38




Unassigned   Ramon Henrique Ornelas   10/17/2010 15:50   11/20/2012 21:37




                                                                            127 of 868
Unassigned   Pekka Järvinen   7/16/2010 0:30   11/20/2012 21:37




Unassigned   Damir Mitrovic   8/12/2010 0:15   11/20/2012 21:37




                                                                  128 of 868
Unassigned   Nicholas Calugar   10/14/2009 9:22   11/20/2012 20:53   11/20/2012 20:53




Unassigned   Mickael Perraud    12/24/2008 4:50   11/20/2012 20:53   11/20/2012 20:53




                                                                                        129 of 868
Unassigned   Matthew Ratzloff   8/13/2009 13:15   11/20/2012 20:52   11/20/2012 20:52




                                                                                        130 of 868
Ralph Schindler   Andrey   10/26/2010 2:58   5/30/2012 12:58




                                                               131 of 868
Ramon Henrique Ornelas   Mike Wossen   11/8/2010 8:02   5/30/2012 12:58




                                                                          132 of 868
Adam Lundrigan   Roger Hunwicks   4/29/2009 0:03   5/29/2012 2:31   5/29/2012 2:31




                                                                                     133 of 868
Jurrien Stutterheim   Alexandru Pruteanu   5/18/2012 12:06   5/18/2012 15:36




                                                                               134 of 868
Adam Lundrigan   Robert Fisher   4/22/2011 23:02   5/5/2012 2:34   5/5/2012 2:34




                                                                                   135 of 868
Michael Moussa   julien PAULI   6/11/2009 14:19   5/5/2012 2:33   5/5/2012 2:31




                                                                                  136 of 868
Adam Lundrigan   Ionut Dinu   9/14/2010 2:43   5/5/2012 2:32   5/5/2012 2:32




                                                                               137 of 868
Adam Lundrigan   Peter Culak   8/15/2011 13:30   3/12/2012 1:07   3/12/2012 1:07




                                                                                   138 of 868
Jurrien Stutterheim   Alexander Grimalovsky   1/13/2012 13:50   1/13/2012 13:52




                                                                                  139 of 868
Marco Kaiser   Andris Causs   12/2/2009 4:18   12/8/2011 12:19   12/8/2011 12:19




                                                                                   140 of 868
Ramon Henrique Ornelas   Sebastian Zan   6/4/2010 10:27   11/8/2011 12:06




                                                                            141 of 868
Jurrien Stutterheim   Mizuki Yamanaka   9/29/2011 14:22   9/29/2011 14:30




                                                                            142 of 868
Jurrien Stutterheim   Andreas Beder   9/23/2011 7:32   9/27/2011 12:56




Thomas Weidner        netroby         5/30/2011 9:05    9/9/2011 21:56   9/9/2011 21:56




                                                                                          143 of 868
Ramon Henrique Ornelas   Bartlomiej Dudala   11/18/2010 5:30   9/9/2011 21:48   4/10/2011 19:04




                                                                                                  144 of 868
Jurrien Stutterheim   GUYARD Vincent   8/17/2011 22:09   8/17/2011 22:09




                                                                           145 of 868
Jurrien Stutterheim   Dae Daluz   8/22/2008 7:34   8/17/2011 22:04   8/22/2008 14:01




                                                                                       146 of 868
Jurrien Stutterheim   Christian Opitz   8/16/2011 10:13   8/16/2011 10:16




                                                                            147 of 868
Jurrien Stutterheim   Mariusz   7/18/2011 13:38   7/18/2011 13:38




                                                                    148 of 868
Jurrien Stutterheim      Eugene Morgan             6/2/2011 14:16   6/2/2011 14:16




Ramon Henrique Ornelas   Ramon Henrique Ornelas   8/22/2009 13:55   4/24/2011 2:13




                                                                                     149 of 868
Ramon Henrique Ornelas   Maxime Aoustin   4/19/2011 2:55   4/24/2011 2:12   4/24/2011 2:11




                                                                                             150 of 868
Ramon Henrique Ornelas   Master Surfer   7/31/2009 10:39   4/10/2011 19:03   2/17/2011 19:54




                                                                                               151 of 868
Jurrien Stutterheim   Yuriy Chernichenko   3/29/2011 17:44   3/29/2011 17:44




                                                                               152 of 868
Ramon Henrique Ornelas   Muhammad Shakeel   7/6/2009 7:22   2/18/2011 19:56




                                                                              153 of 868
Ramon Henrique Ornelas   Ian Smith   1/14/2011 3:31   2/18/2011 7:41   2/18/2011 7:41




                                                                                        154 of 868
Ramon Henrique Ornelas   rythem shah               2/5/2011 10:09   2/17/2011 20:19




Ramon Henrique Ornelas   Ramon Henrique Ornelas   2/17/2011 19:01   2/17/2011 19:09   2/17/2011 19:09




                                                                                                        155 of 868
Ramon Henrique Ornelas   Dieter Provoost   8/4/2010 2:13   1/25/2011 9:23




                                                                            156 of 868
Ramon Henrique Ornelas   Jan Sorgalla   1/20/2010 13:10   1/25/2011 9:21




                                                                           157 of 868
Ramon Henrique Ornelas   Marcin Wójcik   12/30/2010 4:38   1/22/2011 8:15   1/22/2011 8:15




                                                                                             158 of 868
Thomas Weidner   Mickael Perraud   7/20/2009 2:53   12/8/2010 23:43   11/12/2009 5:35




                                                                                        159 of 868
Ryan Mauger   Razan Shrestha   11/26/2010 3:10   11/26/2010 3:15   11/26/2010 3:15




                                                                                     160 of 868
Richard Tuin       Lekš
               Aleš e     6/15/2010 9:13   11/20/2010 3:12   11/20/2010 3:12




                                                                               161 of 868
Marc Hodgins   Jakob Schumann   11/4/2010 9:39   11/8/2010 11:48   11/8/2010 11:48




                                                                                     162 of 868
Ramon Henrique Ornelas   Marc Bennewitz (private)   10/13/2010 14:32   10/20/2010 12:20   10/20/2010 12:20




                                                                                                             163 of 868
Marc Bennewitz (private)   Marc Bennewitz (private)   10/20/2010 9:25   10/20/2010 11:59   10/20/2010 11:59




                                                                                                              164 of 868
Ramon Henrique Ornelas   Chinh       8/27/2010 10:52   8/27/2010 14:26   8/27/2010 14:26




Ramon Henrique Ornelas   Ryan Horn   12/4/2009 15:28    8/21/2010 6:04    8/21/2010 6:04




                                                                                           165 of 868
Ramon Henrique Ornelas   Markus      2/14/2010 9:36    8/21/2010 5:32    8/21/2010 5:31

Ramon Henrique Ornelas   starflash    6/3/2010 2:45   8/20/2010 17:16   8/20/2010 17:16




                                                                                          166 of 868
Ramon Henrique Ornelas   Dieter Provoost    8/4/2010 2:15     8/8/2010 6:37    8/8/2010 6:37




Ramon Henrique Ornelas   James Stuart      7/19/2010 7:58   7/20/2010 10:28   7/19/2010 8:09




                                                                                               167 of 868
Matthew Weier O'Phinney   Darius Bohni    7/20/2010 6:36    7/20/2010 7:54    7/20/2010 6:51




Ramon Henrique Ornelas    Mario Dees     3/10/2010 16:38   7/18/2010 17:11   7/18/2010 17:11




                                                                                               168 of 868
Ramon Henrique Ornelas   Benjamin            5/31/2010 4:58   7/17/2010 15:47   7/17/2010 15:47




Jurrien Stutterheim      Tomáš Fejfar       2/14/2009 10:17   7/17/2010 15:39   6/18/2009 16:58




Ramon Henrique Ornelas   Matthias Brendel     7/9/2010 6:21    7/9/2010 12:48    7/9/2010 12:48




                                                                                                  169 of 868
Matthew Ratzloff   michael depetrillo   11/12/2008 12:27   6/18/2010 2:51




                                                                            170 of 868
Jurrien Stutterheim   Phil Brown   12/8/2008 20:11   6/7/2010 12:34   3/30/2009 18:05




                                                                                        171 of 868
Marco Kaiser          Nicolas Ruflin      6/2/2010 11:46    6/3/2010 5:03   6/2/2010 23:08




Jurrien Stutterheim   Kazusuke Sasezaki   8/31/2009 6:38   6/2/2010 23:12   6/2/2010 23:12




                                                                                             172 of 868
Marco Kaiser   Minh Son Nguyen   10/6/2009 2:22   5/26/2010 4:19   5/26/2010 4:19




Marco Kaiser   Minh Son Nguyen   7/24/2009 3:13   5/26/2010 4:19   5/26/2010 4:19




                                                                                    173 of 868
Marco Kaiser   Michal Korus   1/6/2010 17:15   5/26/2010 4:19   5/26/2010 4:19




                                                                                 174 of 868
Bradley Holt               Bradley Holt     12/29/2008 14:40   5/25/2010 18:47   5/25/2010 18:47




Wil Moore III (wilmoore)   flaves forward    12/29/2009 7:14    5/23/2010 2:18   5/22/2010 10:22




                                                                                                   175 of 868
Matthew Ratzloff   Matthew Ratzloff   9/9/2008 13:29    3/19/2010 4:48   10/8/2008 18:39




Mickael Perraud    Mickael Perraud    1/31/2010 1:24   3/18/2010 12:16    3/12/2010 2:05




                                                                                           176 of 868
Mickael Perraud   Mickael Perraud   7/21/2009 4:38   3/18/2010 7:56   8/18/2009 15:11




                                                                                        177 of 868
Marc Bennewitz (private)   John Worthington   10/22/2009 16:49     3/1/2010 4:59     3/1/2010 4:59




Thomas Weidner             Wil Sinclair         1/9/2009 14:17   2/28/2010 10:35   2/28/2010 10:35




                                                                                                     178 of 868
Marc Bennewitz (private)   asinan   1/28/2010 5:25   2/27/2010 18:19   2/27/2010 18:19




                                                                                         179 of 868
Jurrien Stutterheim   Sven Franke   2/24/2010 23:42   2/25/2010 7:13   2/25/2010 7:13




                                                                                        180 of 868
Matthew Weier O'Phinney   Matthew Ratzloff   9/1/2008 8:56   2/25/2010 4:51   2/23/2010 8:35




                                                                                               181 of 868
Jurrien Stutterheim   Tomas Moravec   12/16/2008 1:17   2/17/2010 6:59   2/21/2009 16:52




                                                                                           182 of 868
Jurrien Stutterheim   Yuri Timofeev            1/23/2009 1:57    2/17/2010 6:59   2/21/2009 16:55




Satoru Yoshida        Sudheer Satyanarayana    1/6/2010 12:29   1/11/2010 18:55   1/11/2010 18:55


Jurrien Stutterheim   M.Ozan Hazer            8/25/2009 13:22   12/17/2009 2:30   12/17/2009 2:30




                                                                                                    183 of 868
Marc Bennewitz (private)   Marc Bennewitz (private)   10/17/2009 3:29   11/25/2009 1:43   10/22/2009 14:23




Ramon Henrique Ornelas     Andrei Iarus                8/26/2009 0:23   11/2/2009 18:01    11/2/2009 18:01




                                                                                                             184 of 868
Jurrien Stutterheim   Ramon Henrique Ornelas    7/14/2009 6:07     11/2/2009 6:58    7/19/2009 12:46




Jurrien Stutterheim   Jan-Christoph Ihrens     6/15/2009 10:14   10/15/2009 10:56   10/15/2009 10:56




                                                                                                       185 of 868
Jurrien Stutterheim   Master Surfer   6/25/2009 12:58   8/29/2009 9:00   6/25/2009 14:03




                                                                                           186 of 868
Jurrien Stutterheim   Vladislav   8/17/2009 12:58   8/26/2009 8:12   8/26/2009 8:12




                                                                                      187 of 868
Simon Mundy    Hector Virgen   7/22/2008 15:45   8/25/2009 17:16   7/23/2008 11:21




julien PAULI   julien PAULI     5/20/2009 8:30   8/17/2009 23:15    6/3/2009 14:27




                                                                                     188 of 868
Jurrien Stutterheim   Benjamin Eberlei   8/15/2009 2:04   8/16/2009 5:30   8/16/2009 5:30




                                                                                            189 of 868
Jurrien Stutterheim   Adam Kusmierz   7/15/2009 4:53   7/31/2009 21:14   7/19/2009 0:22




                                                                                          190 of 868
julien PAULI   Adam Kusmierz   7/6/2009 11:22   7/31/2009 20:49   7/7/2009 9:58




                                                                                  191 of 868
Jurrien Stutterheim   Hristo Angelov   7/17/2009 4:46   7/30/2009 0:09   7/30/2009 0:09




                                                                                          192 of 868
Jurrien Stutterheim   Jim Safley   8/6/2008 11:57   7/29/2009 8:07   7/29/2009 8:07




                                                                                      193 of 868
Jurrien Stutterheim   Emanuele Deserti   1/8/2009 0:25   7/29/2009 7:51   7/29/2009 7:51




                                                                                           194 of 868
Jurrien Stutterheim   Sean McSomething   12/22/2008 14:44   7/29/2009 7:19   7/29/2009 7:19




Jurrien Stutterheim   franek               6/26/2009 6:21   7/29/2009 7:04   7/29/2009 7:04




                                                                                              195 of 868
Jurrien Stutterheim   Michael Moussa   7/23/2009 7:51   7/23/2009 7:59   7/23/2009 7:57




                                                                                          196 of 868
Jurrien Stutterheim   Ryan Mauger            6/23/2009 8:42    7/7/2009 10:05    7/7/2009 10:05




Jurrien Stutterheim   Jurrien Stutterheim   6/18/2009 22:03   6/18/2009 22:10   6/18/2009 22:10




                                                                                                  197 of 868
Jurrien Stutterheim   Anselm Föhr    5/6/2009 9:14   6/18/2009 21:24   6/18/2009 21:24




Jurrien Stutterheim   Keith Pope    1/16/2009 3:21   6/18/2009 20:51   6/18/2009 20:51




                                                                                         198 of 868
Jurrien Stutterheim   Nikolay Goldschmidt   4/16/2009 17:55   6/18/2009 20:13   6/18/2009 20:13




                                                                                                  199 of 868
Jurrien Stutterheim   Bogdan Albei          12/17/2008 2:02   6/18/2009 19:41   6/18/2009 19:41




Jurrien Stutterheim   Jurrien Stutterheim   6/18/2009 17:39   6/18/2009 17:45   6/18/2009 17:45




                                                                                                  200 of 868
Jurrien Stutterheim   Panupan Sriautharawong   3/6/2009 9:42   6/18/2009 17:24   6/18/2009 17:24




                                                                                                   201 of 868
Matthew Ratzloff   Dalibor Karlovic   5/26/2009 2:49   6/9/2009 7:48




                                                                       202 of 868
Jurrien Stutterheim   purple ankh   12/18/2008 16:15   6/8/2009 14:31   6/8/2009 14:30




                                                                                         203 of 868
Matthew Ratzloff   Radek Antoniuk   4/12/2009 17:29   6/8/2009 7:53   6/8/2009 7:53




Matthew Ratzloff   Endi             11/17/2008 6:52   6/8/2009 7:47   6/8/2009 7:47




                                                                                      204 of 868
Matthew Ratzloff   purple ankh   1/3/2009 10:09   6/8/2009 7:41   6/8/2009 7:41




                                                                                  205 of 868
Jurrien Stutterheim   Jiri Helmich   5/26/2009 15:11   5/30/2009 20:31   5/30/2009 20:31




                                                                                           206 of 868
Jurrien Stutterheim   Richard Noya   5/25/2009 4:23   5/30/2009 18:40   5/30/2009 18:40




                                                                                          207 of 868
Jurrien Stutterheim   julien PAULI      11/5/2008 7:06    5/20/2009 8:36   12/23/2008 2:25




Jurrien Stutterheim   Dmitry Shirokov    2/3/2009 2:16   2/21/2009 16:00   2/21/2009 16:00




                                                                                             208 of 868
Jurrien Stutterheim   Jurrien Stutterheim    2/21/2009 15:23   2/21/2009 15:25   2/21/2009 15:25


Jurrien Stutterheim   Brian P. Harris       12/12/2008 11:24   2/21/2009 15:05   2/21/2009 15:05




Jurrien Stutterheim   Brian P. Harris       12/12/2008 11:27   2/17/2009 11:21   12/13/2008 6:22




                                                                                                   209 of 868
Jurrien Stutterheim   Jurrien Stutterheim   1/11/2009 12:21   1/13/2009 0:55   1/13/2009 0:55




                                                                                                210 of 868
Jurrien Stutterheim   Armando Padilla   1/2/2009 17:07   1/8/2009 7:52   1/8/2009 7:52




                                                                                         211 of 868
Jurrien Stutterheim   Chris Lock   12/24/2008 5:15   12/27/2008 12:37   12/24/2008 5:29




                                                                                          212 of 868
Matthew Ratzloff   Matthew Ratzloff   11/8/2008 7:25   11/13/2008 14:10   11/8/2008 7:34




                                                                                           213 of 868
Jurrien Stutterheim   Roger Hunwicks   10/22/2008 3:09   11/13/2008 14:10   10/22/2008 3:22




                                                                                              214 of 868
Jurrien Stutterheim   Jukka Dahlbom         10/27/2008 2:09   11/13/2008 14:10   10/29/2008 11:02




Jurrien Stutterheim   Jurrien Stutterheim   10/15/2008 8:10   11/13/2008 14:10    10/15/2008 8:24




                                                                                                    215 of 868
Jurrien Stutterheim   Thomas Weidner   10/11/2008 14:36   11/13/2008 14:10   10/30/2008 13:50




                                                                                                216 of 868
Mickael Perraud   Brian Drysdale   10/16/2008 5:41   11/13/2008 14:10   11/4/2008 13:05




                                                                                          217 of 868
Jurrien Stutterheim   Laura Dean           10/21/2008 7:23   11/13/2008 14:10   10/30/2008 13:36




Jurrien Stutterheim   Roger Hunwicks       10/22/2008 3:42   11/13/2008 14:10    10/22/2008 8:37




Jurrien Stutterheim   Alexander Veremyev    11/6/2008 9:07   11/13/2008 14:10     11/8/2008 3:39




                                                                                                   218 of 868
Jurrien Stutterheim   Jurrien Stutterheim   10/22/2008 12:38   11/13/2008 14:09   10/22/2008 12:45


julien PAULI          julien PAULI            11/6/2008 2:43     11/6/2008 2:44     11/6/2008 2:44




julien PAULI          julien PAULI            11/5/2008 4:50     11/6/2008 2:38     11/6/2008 2:38




                                                                                                     219 of 868
Mickael Perraud       Mickael Perraud          11/4/2008 13:07    11/4/2008 13:50    11/4/2008 13:50




Jurrien Stutterheim   Sudheer Satyanarayana   10/29/2008 13:45   10/30/2008 14:49   10/30/2008 13:14




Jurrien Stutterheim   Jurrien Stutterheim      10/22/2008 8:34    10/22/2008 8:35    10/22/2008 8:35




                                                                                                       220 of 868
Matthew Ratzloff      Dolf Schimmel (Freeaqingme)   10/19/2008 10:59   10/19/2008 12:55   10/19/2008 12:54




Matthew Ratzloff      Jurrien Stutterheim             7/30/2008 9:55   10/19/2008 12:53    10/8/2008 22:27

Jurrien Stutterheim   Hector Virgen                 10/15/2008 11:49   10/16/2008 10:09   10/16/2008 10:09




                                                                                                             221 of 868
Jurrien Stutterheim   Jurrien Stutterheim   8/24/2008 14:37   10/10/2008 19:30   9/24/2008 13:53




Jurrien Stutterheim   Eric Hokanson         8/27/2008 12:52   10/10/2008 19:26    9/18/2008 5:57




                                                                                                   222 of 868
Jurrien Stutterheim   Karol Grecki           9/3/2008 9:33   10/10/2008 19:25   9/18/2008 5:57




Matthew Ratzloff      Stanislav Anisimov   7/23/2008 13:25   10/10/2008 19:23    8/4/2008 7:41




                                                                                                 223 of 868
Jurrien Stutterheim   Kamil Nowakowski    7/23/2008 2:11   10/10/2008 19:22   7/23/2008 3:53




Jurrien Stutterheim   Hector Virgen      7/22/2008 15:49   10/10/2008 19:20   7/23/2008 9:43




                                                                                               224 of 868
Matthew Ratzloff   Yannick Lyn Fatt   8/13/2008 10:46   10/10/2008 19:19   8/29/2008 7:52




                                                                                            225 of 868
Jurrien Stutterheim   Mina R Waheeb     8/19/2008 19:10   10/10/2008 19:18    8/20/2008 8:14




Jurrien Stutterheim   Ralph Schindler   10/7/2008 10:18   10/10/2008 19:16   10/8/2008 12:40




                                                                                               226 of 868
Matthew Ratzloff   Kristof Vansant   10/8/2008 4:30   10/10/2008 19:14   10/10/2008 19:14




                                                                                            227 of 868
Jurrien Stutterheim   Jurrien Stutterheim   7/28/2008 0:45   10/10/2008 14:41   10/2/2008 11:35




                                                                                                  228 of 868
Jurrien Stutterheim   Benjamin-Timm Broich   9/13/2008 2:25   10/10/2008 13:58   10/10/2008 13:58




                                                                                                    229 of 868
Matthew Ratzloff   Jurrien Stutterheim   9/17/2008 23:22   10/8/2008 22:32   10/8/2008 22:31




Matthew Ratzloff   Daniel Skinner        9/30/2008 14:59   9/30/2008 15:49   9/30/2008 15:49




                                                                                               230 of 868
Matthew Ratzloff   Weber Chris   9/19/2008 1:29   9/29/2008 20:41   9/29/2008 20:41




                                                                                      231 of 868
Jurrien Stutterheim   Denis Baklikov   9/26/2008 3:23   9/26/2008 4:11   9/26/2008 4:11




                                                                                          232 of 868
Jurrien Stutterheim   Denis Baklikov   9/25/2008 3:58   9/25/2008 4:08   9/25/2008 4:08




                                                                                          233 of 868
Matthew Ratzloff   Simon Corless   9/4/2008 13:58   9/5/2008 21:38   9/5/2008 21:38




                                                                                      234 of 868
Matthew Ratzloff   Jason Eisenmenger   9/5/2008 12:00   9/5/2008 21:07   9/5/2008 21:07




                                                                                          235 of 868
Matthew Ratzloff   Matthew Ratzloff   9/1/2008 9:05   9/4/2008 11:38   9/3/2008 19:40




                                                                                        236 of 868
Matthew Ratzloff   Aristide R. ZOUNGRANA   9/3/2008 9:27   9/3/2008 20:41   9/3/2008 20:41




                                                                                             237 of 868
Matthew Ratzloff   Martin Hujer   8/24/2008 3:47   9/3/2008 20:37   9/3/2008 20:37




                                                                                     238 of 868
Matthew Ratzloff   Jurrien Stutterheim   7/23/2008 10:13   9/3/2008 20:29   9/3/2008 20:29




                                                                                             239 of 868
Matthew Ratzloff   Matthew Ratzloff     9/1/2008 9:15   9/3/2008 20:27   9/3/2008 20:27




Matthew Ratzloff   Matthew Ratzloff    9/3/2008 10:44   9/3/2008 19:12   9/3/2008 19:12


Matthew Ratzloff   Matthew Ratzloff   8/22/2008 14:40   9/3/2008 19:10   9/3/2008 19:10


Matthew Ratzloff   Matthew Ratzloff    9/3/2008 10:47   9/3/2008 10:54   9/3/2008 10:54




                                                                                          240 of 868
Matthew Ratzloff   Radek Antoniuk   8/22/2008 12:13   8/22/2008 14:58   8/22/2008 14:58




Matthew Ratzloff   Vito              8/22/2008 2:51    8/22/2008 8:46    8/22/2008 8:46




                                                                                          241 of 868
Jurrien Stutterheim   Hastimal   8/22/2008 0:21   8/22/2008 0:37   8/22/2008 0:37




                                                                                    242 of 868
Jurrien Stutterheim   coolmic   8/14/2008 8:32   8/21/2008 3:52   8/21/2008 3:52




                                                                                   243 of 868
Matthew Ratzloff      Matthew Ratzloff   7/29/2008 14:59   8/7/2008 20:29   8/7/2008 20:29




Jurrien Stutterheim   Hugo HAMON           8/4/2008 1:51    8/4/2008 7:47    8/4/2008 7:47




                                                                                             244 of 868
Jurrien Stutterheim   Martin Hujer   7/31/2008 14:54   8/3/2008 15:24   8/3/2008 15:24




                                                                                         245 of 868
Matthew Ratzloff      Eduardo Marinho   7/25/2008 15:12   7/28/2008 8:10   7/28/2008 8:10




Jurrien Stutterheim   Joe H              7/28/2008 8:06   7/28/2008 8:10   7/28/2008 8:10




                                                                                            246 of 868
Jurrien Stutterheim   Kamil Nowakowski   7/24/2008 7:33   7/24/2008 7:51   7/24/2008 7:51




                                                                                            247 of 868
Jurrien Stutterheim   Jurrien Stutterheim   7/24/2008 4:21   7/24/2008 4:57   7/24/2008 4:57




                                                                                               248 of 868
Affects Version/s   Fix Version/s              Component/s   Due Date Votes Watchers
                                    Zend_Paginator                        0        1




                                                                               249 of 868
1.10.2   Zend_Paginator   1       1




                              250 of 868
1.10.7   Zend_Paginator   0       0




1.10.8   Zend_Paginator   1       1




                              251 of 868
1.10.6   Zend_Paginator   0       1




1.10.7   Zend_Paginator   0       0




                              252 of 868
        Zend_Paginator   0       0




1.7.1   Zend_Paginator   0       0




                             253 of 868
1.9.1   Zend_Paginator   0       1




                             254 of 868
1.10.6   Zend_Db_Select, Zend_Paginator   2       1




                                              255 of 868
1.8.0, 1.8.1, 1.8.2, 1.8.3, 1.8.4, 1.8.5,      Zend_Paginator   3       4
1.9.0, 1.9.1, 1.9.2, 1.9.3, 1.9.4, 1.9.5,
1.9.6, 1.9.7, 1.9.8, 1.10.0, 1.10.1, 1.10.2,
1.10.3, 1.10.4, 1.10.5, 1.10.6, 1.10.7,
1.10.8, 1.11.0




                                                                    256 of 868
1.7.8, 1.8.0   Zend_Db_Table, Zend_Paginator   2       3




                                                   257 of 868
1.11.11   Zend_Paginator   0       0




                               258 of 868
1.11.5   Zend_Paginator   1       2




                              259 of 868
1.8.2   1.12.0   Zend_Paginator   9      15




                                      260 of 868
1.10.8   Zend_Paginator   2       5




                              261 of 868
1.11.7   Zend_Paginator   1       2




                              262 of 868
1.11.11   Zend_Paginator   0       0




                               263 of 868
1.9.3, 1.9.4, 1.9.5, 1.9.6   1.11.12   Zend_Paginator   2       3




                                                            264 of 868
1.10.5   Zend_Paginator   1       3




                              265 of 868
1.11.9   Zend_Paginator   0       0




                              266 of 868
1.9.8, 1.11.10                        Zend_Paginator   0       0




1.11.6           Next Major Release   Zend_Paginator   0       0




                                                           267 of 868
1.11.6, Next Major Release   Zend_Paginator   0       1




                                                  268 of 868
1.11.10   Zend_Paginator   0       0




                               269 of 868
1.6.0RC2   1.6.1   Zend_Paginator   0       0




                                        270 of 868
1.11.10   Zend_Paginator   0       1




                               271 of 868
1.11.9   Zend_Paginator   1       1




                              272 of 868
1.11.4   Zend_Paginator   0       0




1.9.1    Zend_Paginator   0       1




                              273 of 868
1.10.0, 1.11.5   Zend_Paginator   0       0




                                      274 of 868
1.9.0, 1.9.1, 1.9.2, 1.9.3, 1.9.4   1.11.6   Zend_Paginator   0       3




                                                                  275 of 868
1.11.4   Zend_Paginator   1       1




                              276 of 868
1.8.4   Zend_Db_Select, Zend_Paginator   0       2




                                             277 of 868
1.11.2   1.11.4   Zend_Paginator   0       2




                                       278 of 868
1.10.8            Zend_Paginator   0       0




1.11.3   1.11.4   Zend_Paginator   0       1




                                       279 of 868
1.10.1   Zend_Paginator   2       3




                              280 of 868
Zend_Paginator   2       3




                     281 of 868
1.11.1   1.11.3   Zend_Paginator   0       1




                                       282 of 868
Zend_Acl, Zend_Amf, Zend_Application,       0       1
Zend_Auth, Zend_Cache,
Zend_Captcha, Zend_CodeGenerator,
Zend_Config, Zend_Config_Writer,
Zend_Controller, Zend_Db,
Zend_Db_Adapter_Db2,
Zend_Db_Adapter_Mysqli,
Zend_Db_Adapter_Oracle,
Zend_Db_Profiler, Zend_Db_Select,
Zend_Db_Table, Zend_Dojo,
Zend_Feed, Zend_Feed_Reader,
Zend_File_Transfer, Zend_Filter,
Zend_Filter_Inflector, Zend_Filter_Input,
Zend_Form, Zend_Gdata,
Zend_InfoCard, Zend_Json,
Zend_Json_Server, Zend_Layout,
Zend_Ldap, Zend_Loader, Zend_Log,
Zend_Mail, Zend_Mail_Storage,
Zend_Paginator, Zend_Pdf,
Zend_ProgressBar, Zend_Reflection,
Zend_Search_Lucene,
Zend_Server_Reflection,
Zend_Service_Akismet,
Zend_Service_Amazon,
Zend_Service_Amazon_Ec2,
Zend_Service_Audioscrobbler,
Zend_Service_Delicious,
Zend_Service_Flickr,
Zend_Service_Nirvanix,




                                                283 of 868
Zend_Paginator   0       0




                     284 of 868
Zend_Paginator   0       1




                     285 of 868
1.11.0   1.11.1   Zend_Paginator   0       1




                                       286 of 868
1.11.1   Zend_Paginator   0       1




                              287 of 868
1.11.0   1.11.0   Zend_Paginator   0       0




                                       288 of 868
1.10.5   1.10.8   Zend_Paginator   0       0




         1.10.0   Zend_Paginator   0       2




                                       289 of 868
1.10.1   1.11.0   Zend_Paginator   1       1

1.10.5            Zend_Paginator   0       2




                                       290 of 868
1.10.1   Zend_Paginator   0       1




1.10.6   Zend_Paginator   0       1




                              291 of 868
1.10.6            Zend_Paginator   0       1




1.10.2   1.10.7   Zend_Paginator   0       1




                                       292 of 868
                  Zend_Paginator   0       2




         1.8.4    Zend_Paginator   0       0




1.10.6   1.10.7   Zend_Paginator   0       1




                                       293 of 868
1.6.2, 1.7 Preview Release   Zend_Paginator   1       0




                                                  294 of 868
1.7.1   Zend_Paginator   0       0




                             295 of 868
1.10.5   1.11.0   Zend_Paginator   0       0




         1.10.6   Zend_Paginator   0       0




                                       296 of 868
1.9.3   1.10.5   Zend_Paginator   6       3




1.8.4   1.10.5   Zend_Paginator   0       0




                                      297 of 868
1.6.0   1.10.5   Zend_Paginator   3       5




                                      298 of 868
1.7.2   1.11.0          Zend_Paginator   0       1




1.9.6   1.9.8, 1.10.4   Zend_Paginator   1       0




                                             299 of 868
1.6.0    1.6.2    Zend_Paginator                         1       2




1.10.0   1.10.0   Zend_Application_Resource,             0       0
                  Zend_Cache, Zend_Controller,
                  Zend_Currency,
                  Zend_Feed_Pubsubhubbub,
                  Zend_Feed_Reader, Zend_Feed_Writer,
                  Zend_Filter, Zend_Http_Client,
                  Zend_Http_Response, Zend_Log,
                  Zend_Oauth, Zend_Paginator,
                  Zend_Pdf, Zend_Queue,
                  Zend_Service_WindowsAzure,
                  Zend_Tool, Zend_Validate, Zend_View,
                  Zend_XmlRpc_Server




                                                             300 of 868
1.10.0   Zend_Acl, Zend_Amf, Zend_Application,       0       0
         Zend_Auth, Zend_Auth_Adapter_Ldap,
         Zend_Auth_Adapter_OpenId,
         Zend_Cache, Zend_Captcha,
         Zend_CodeGenerator, Zend_Config,
         Zend_Config_Writer,
         Zend_Console_Getopt, Zend_Controller,
         Zend_Crypt, Zend_Db,
         Zend_Db_Adapter_Db2,
         Zend_Db_Adapter_Mysqli,
         Zend_Db_Adapter_Oracle,
         Zend_Db_Profiler, Zend_Db_Select,
         Zend_Db_Table, Zend_Debug,
         Zend_Dojo, Zend_Dom_Query,
         Zend_Feed, Zend_Feed_Reader,
         Zend_File_Transfer, Zend_Filter,
         Zend_Filter_Inflector, Zend_Filter_Input,
         Zend_Form, Zend_Gdata,
         Zend_Http_Client, Zend_Http_Cookie,
         Zend_Http_CookieJar,
         Zend_Http_Response,
         Zend_Http_Server, Zend_InfoCard,
         Zend_Json, Zend_Json_Server,
         Zend_Layout, Zend_Ldap, Zend_Loader,
         Zend_Locale, Zend_Log, Zend_Mail,
         Zend_Mail_Storage, Zend_Measure,
         Zend_Memory, Zend_Mime,
         Zend_Navigation, Zend_OpenId,
         Zend_Paginator, Zend_Pdf,




                                                         301 of 868
1.9.1            Zend_Cache, Zend_Paginator   0       0




1.7.2   1.10.3   Zend_Paginator               0       0




                                                  302 of 868
1.10.0   Zend_Cache, Zend_Paginator   0       0




                                          303 of 868
1.10.0, 1.10.1, 1.10.2   Zend_Paginator   0       1




                                              304 of 868
1.6.0RC3   1.6.1, 1.10.2   Zend_Paginator   0       1




                                                305 of 868
1.7.1   Zend_Paginator   0       3




                             306 of 868
1.7.3                                       Zend_Paginator              0       2




1.7.8, 1.8.0, 1.8.1, 1.8.2, 1.8.3, 1.8.4,   Zend_Paginator              0       0
1.9.0, 1.9.1, 1.9.2, 1.9.3, 1.9.4, 1.9.5,
1.9.6, 1.9.7, 1.10.0
1.9.2                                       Zend_Paginator, Zend_View   0       0




                                                                            307 of 868
1.9.4                        1.9.7   Zend_Paginator   1       1




1.8.4, 1.9.0, 1.9.1, 1.9.2           Zend_Paginator   0       0




                                                          308 of 868
1.8.4   Zend_Paginator   0       0




1.8.2   Zend_Paginator   0       1




                             309 of 868
1.8.4   1.9.0   Zend_Db_Select, Zend_Paginator   0       0




                                                     310 of 868
1.9.0   Zend_Paginator   0       0




                             311 of 868
1.6.0RC1           Zend_Paginator   1       1




           1.8.3   Zend_Paginator   2       5




                                        312 of 868
1.9.1   Zend_Paginator   0       1




                             313 of 868
1.8.4   1.9.0   Zend_Paginator   0       1




                                     314 of 868
1.8.3, 1.8.4   1.9.0   Zend_Paginator   0       2




                                            315 of 868
1.8.4   Zend_Paginator   1       0




                             316 of 868
1.6.0RC1   1.6.1   Zend_Paginator   1       3




                                        317 of 868
Zend_Paginator   0       1




                     318 of 868
                Zend_Paginator   0       0




1.8.4   1.9.0   Zend_Paginator   0       0




                                     319 of 868
1.8.4   Zend_Paginator   0       1




                             320 of 868
1.8.4           Zend_Paginator   3       2




        1.8.4   Zend_Paginator   0       0




                                     321 of 868
1.8.4   Zend_Paginator   0       1




1.8.4   Zend_Paginator   0       1




                             322 of 868
1.7.8   1.8.4   Zend_Paginator   0       1




                                     323 of 868
1.7.1   1.8.4   Zend_Paginator   1       1




        1.8.4   Zend_Paginator   0       0




                                     324 of 868
1.7.2   1.8.4   Zend_Paginator   3       1




                                     325 of 868
1.8.1   Zend_Paginator   0       0




                             326 of 868
1.7.0, 1.7.1, 1.7.2   Zend_Paginator   0       1




                                           327 of 868
                      Zend_Db_Adapter_Mysqli,   0       0
                      Zend_Paginator




1.7 Preview Release   Zend_Paginator            1       1




                                                    328 of 868
1.7.0, 1.7.1, 1.7.2   Zend_Paginator   0       0




                                           329 of 868
1.8.0   Zend_Paginator   0       0




                             330 of 868
1.8.1   Zend_Paginator   0       0




                             331 of 868
1.8.0   Zend_Paginator   1       2




        Zend_Paginator   0       0




                             332 of 868
        Zend_Paginator   0       0


1.7.1   Zend_Paginator   0       2




1.7.1   Zend_Paginator   0       1




                             333 of 868
Zend_Paginator   0       1




                     334 of 868
Zend_Paginator   0       0




                     335 of 868
Zend_Paginator   0       1




                     336 of 868
1.6.2   1.7.0   Zend_Paginator   0       0




                                     337 of 868
1.6.2   1.7.0   Zend_Paginator   0       0




                                     338 of 868
1.6.2   1.7.0   Zend_Paginator   0       0




        1.7.0   Zend_Paginator   0       0




                                     339 of 868
1.6.2, 1.7 Preview Release   1.7.0   Zend_Paginator   0       0




                                                          340 of 868
1.6.1, 1.6.2   1.7.0   Zend_Paginator   1       2




                                            341 of 868
1.6.1   1.7.0   Zend_Paginator   0       0




1.8.0   1.7.0   Zend_Paginator   0       0




1.7.0   1.7.0   Zend_Paginator   0       0




                                     342 of 868
1.7.0   Zend_Paginator   0       0


        Zend_Paginator   0       0




        Zend_Paginator   0       1




                             343 of 868
                                    Zend_Paginator   0       0




1.6.1, 1.6.2, 1.7 Preview Release   Zend_Paginator   0       1




1.7 Preview Release                 Zend_Paginator   0       0




                                                         344 of 868
1.6.0, 1.6.1           Zend_Paginator              0       0




1.6.1          1.6.2   Zend_Paginator              0       0

1.6.1                  Zend_Paginator, Zend_View   0       0




                                                       345 of 868
                                 Zend_Paginator   1       0




1.6.0RC3, 1.6.0, 1.6.1   1.6.2   Zend_Paginator   3       4




                                                      346 of 868
1.6.0      1.6.2   Zend_Paginator   0       1




1.6.0RC1   1.6.0   Zend_Paginator   0       1




                                        347 of 868
1.6.0RC1   1.6.0   Zend_Paginator   0       0




1.6.0RC1   1.6.1   Zend_Paginator   0       0




                                        348 of 868
1.6.0RC2   1.6.1   Zend_Paginator   0       1




                                        349 of 868
1.6.0   1.6.1   Zend_Paginator   0       1




1.6.1   1.6.2   Zend_Paginator   0       0




                                     350 of 868
1.6.0, 1.6.1   1.6.2   Zend_Paginator   1       0




                                            351 of 868
1.6.2   Zend_Paginator   3       1




                             352 of 868
1.6.0, 1.6.1   Zend_Paginator   0       2




                                    353 of 868
        Zend_Paginator   0       0




1.6.1   Zend_Paginator   0       1




                             354 of 868
1.6.1   1.6.2   Zend_Paginator   0       1




                                     355 of 868
1.6.1   Zend_Paginator   0       1




                             356 of 868
1.6.1   Zend_Paginator   0       0




                             357 of 868
1.6.0   1.6.1   Zend_Paginator   0       0




                                     358 of 868
1.6.0   1.6.1   Zend_Paginator   0       0




                                     359 of 868
1.6.0RC3   1.6.1   Zend_Paginator   0       0




                                        360 of 868
1.6.0   Zend_Paginator   0       0




                             361 of 868
1.6.0RC2   Zend_Paginator   0       1




                                362 of 868
Zend_Paginator   0       0




                     363 of 868
1.6.0RC3   1.6.1   Zend_Paginator   0       0




1.6.0              Zend_Paginator   0       0


1.6.0RC2   1.6.1   Zend_Paginator   0       0


1.6.0              Zend_Paginator   0       0




                                        364 of 868
1.6.0RC2   Zend_Paginator   0       0




1.6.0RC2   Zend_Paginator   0       0




                                365 of 868
1.6.0RC2   Zend_Paginator   0       0




                                366 of 868
Zend_Paginator   0       0




                     367 of 868
1.6.0RC1   1.6.1   Zend_Paginator   0       0




1.6.0RC1           Zend_Paginator   0       0




                                        368 of 868
1.6.0RC1   1.6.1   Zend_Paginator   0       1




                                        369 of 868
1.6.0RC1   Zend_Paginator   0       1




1.6.0RC1   Zend_Paginator   0       0




                                370 of 868
1.6.0RC1   1.5.3   Zend_Paginator   0       0




                                        371 of 868
1.6.0RC1   1.5.3   Zend_Paginator   0       0




                                        372 of 868
Images   Original Estimate   Remaining Estimate   Time Spent Work Ratio   Sub-Tasks




                                                                                      373 of 868
374 of 868
375 of 868
376 of 868
377 of 868
378 of 868
379 of 868
380 of 868
0   0   0%




             381 of 868
382 of 868
383 of 868
384 of 868
385 of 868
386 of 868
387 of 868
388 of 868
389 of 868
390 of 868
391 of 868
392 of 868
393 of 868
394 of 868
395 of 868
396 of 868
397 of 868
398 of 868
0   0   0%




             399 of 868
400 of 868
0   0   0%




             401 of 868
402 of 868
403 of 868
404 of 868
405 of 868
406 of 868
0   900   ZF-7476, ZF-7497, ZF-7498, ZF-7524,
          ZF-7525, ZF-7526, ZF-7527, ZF-7528,
          ZF-7529, ZF-7530, ZF-7531, ZF-7532,
          ZF-7533




                                                407 of 868
408 of 868
409 of 868
410 of 868
411 of 868
412 of 868
413 of 868
414 of 868
415 of 868
416 of 868
417 of 868
418 of 868
419 of 868
420 of 868
421 of 868
422 of 868
423 of 868
424 of 868
425 of 868
426 of 868
427 of 868
428 of 868
429 of 868
_thumb_11683.png




                   430 of 868
431 of 868
432 of 868
433 of 868
434 of 868
435 of 868
436 of 868
0   0   0%




             437 of 868
438 of 868
439 of 868
0   0   0%




             440 of 868
0   0   0%




             441 of 868
0   0   0%




             442 of 868
0   0   0%




0   0   0%




             443 of 868
444 of 868
445 of 868
446 of 868
447 of 868
448 of 868
449 of 868
3600   3600   0%




                   450 of 868
451 of 868
452 of 868
453 of 868
454 of 868
455 of 868
456 of 868
457 of 868
458 of 868
459 of 868
460 of 868
461 of 868
462 of 868
463 of 868
1800   1800   0%




                   464 of 868
900   900   0%




                 465 of 868
900   900   0%




                 466 of 868
467 of 868
468 of 868
469 of 868
470 of 868
471 of 868
472 of 868
473 of 868
474 of 868
475 of 868
476 of 868
477 of 868
478 of 868
479 of 868
480 of 868
481 of 868
482 of 868
483 of 868
484 of 868
485 of 868
486 of 868
487 of 868
488 of 868
489 of 868
490 of 868
491 of 868
492 of 868
493 of 868
494 of 868
495 of 868
496 of 868
Linked Issues                   Description               Security Level   Progress Σ Progress   Σ Time Spent
                DbSelect adatper don't reset ORDER BY
                on count query, this leads to an
                exception if your DbSelect object uses
                order function.

                This patch should resolve this problem.

                diff -Naur DbSelect.php
                /tmp/DbSelect.php
                --- DbSelect.php 2012-11-29
                14:24:44.394282798 +0100
                +++ /tmp/DbSelect.php 2013-01-03
                18:05:39.429203374 +0100
                @@ -111,6 +111,7 @@
                $select->reset(Select::COLUMNS);
                $select->reset(Select::LIMIT);
                $select->reset(Select::OFFSET);
                + $select->reset(Select::ORDER);

                $select->columns(array('c' => new
                Expression('COUNT(1)')));




                                                                                                         497 of 868
Use case:
retrieve paginated data from database,
serialize them in JSON and return it to
populate a dojox.data.JsonRestStore on
the client side.

Here is a code sample of the model:
{code}
// ...
$select = $this->select();
$adapter = $select->getAdapter();
$adapter-
>setFetchMode(Zend_Db::FETCH_ASS
OC);
$paginator = new Zend_Paginator(
new
Zend_Paginator_Adapter_DbSelect($sel
ect));
{code}

And the corresponding code sample of
the view script:
{code}
// ...
$this->response->setHeader('Content-
Type', 'application/json');
$paginator = $this->paginator;
echo $paginator->toJson();
{code}




                                          498 of 868
In order to use the methods that do not
require the constructor, it would be of
high use to not require the adapter inside
the constructor, but have some
setAdapter() method. I wanted to add the
Paginators Page (as im using my own
Extension, it has some additional
features for that) to my sql select, but i
had to recreate the Adapter.

This is my Code:
protected function _createPaginator()
{
$Adapter = new
Zend_Paginator_Adapter_Array(array());

$Paginator = new
StudCon_Paginator($Adapter);
$PageNumber = $Paginator-
>getCurrentPageNumber();
$PageRange = $Paginator-
>getPageRange();
$select = $this->getSelect()-
>limitPage($PageNumber,
$PageRange);
//echo $select;die();
$ClubMapper = new
Application_Model_Mapper_Club();
$Data = $ClubMapper-
Zend_Paginator to storage of data in
cache makes use of tags only that some
cache backend are supported tags.




                                             499 of 868
I'm using Zend_Paginator as DB to DB
converter looper in CLI program.
Problem is that now memory usage is 6
GB because script runs for multiple days.
So Zend_Paginator should clear previous
page data (internal array) as default or it
should have method to do so.

Hi.

When iterating Zend_Pagination object
created with
Zend_Pagination_Adapter_Array which
uses array:

array(2) {
[127443] => string(8) "12345678"
[1270236] => string(8) "12345678"
}

array indexes are reset. In function:

/**
* Returns an array of items for a page.
*
* @param integer $offset Page offset
* @param integer $itemCountPerPage
Number of items per page
* @return array
*/
public function getItems($offset,
$itemCountPerPage)
{
return array_slice($this->_array, $offset,
$itemCountPerPage);
}




                                              500 of 868
My use case for this function is I was
displaying a large dataset on a page
using Zend_Paginator, but wanted the
capability to export a page range as
CSV. Here is the class I wrote that
extends Zend_Paginator:

{code:title=My_Paginator.php}
class My_Paginator extends
Zend_Paginator
{
/**
* Returns the items for a given page
range.
*
* @return Traversable
*/
public function
getItemsByPageRange($startPageNumb
er, $endPageNumber)
{
$startPageNumber = $this-
>normalizePageNumber($startPageNum
ber);
$endPageNumber = $this-
>normalizePageNumber($endPageNum
ber);

if ($startPageNumber >=
Actually, Zend_Paginator_DbSelect &
Zend_Paginator_DbTableSelect tests are
written for Pdo_Sqlite and Oracle. New
issues appear with the different
behaviors of databases. We have to
rewrite the tests to be able to easily test
against all database adapters.



                                              501 of 868
Working with a data grid component and
Zend_Paginator can be a bit clumsy
when there are sorting and grouping
parameters defined at run time that may
or may not exist.

We probably need to expose sorting and
grouping functionality from the pagination
adapters, enforced via an interface. For
the purposes of backwards compatibility,
this would likely be a separate interface
from the regular adapter interface.
Arrays, for example, may be sorted via a
heap implementation (but this would not
be required for this ticket; the database
adapters would be the primary focus).

The ultimate goal of this ticket and ZF-
5376 ("Allow Zend_Paginator to Accept
An Infinite Item Count Per Page") is to
make Zend_Paginator objects flexible
enough that they can be used as a
universal data access mechanism.




                                             502 of 868
ZF-10659   I have connection to MSSql.

           Then I'm triing to create select for
           paginator select adapter from several
           other selects.
           $select = $db->select()->union($selects);
           echo $select->__toString(); //looks fine,
           and executing in sql anager successfully

           But when I use this select in paginator I
           have wrong rows. Because "select top
           10" in query affects only on first select in
           unioned query.

           Sorry for my english.




                                                          503 of 868
ZF-10455, ZF-10599, ZF-11305   Last page of paginator doesn't work
                               correctly with mssql/sqlsrv driver.
                               On the last page it displays items from
                               previous page as well.
                               For example if we have 2 pages (70 rows
                               total):
                               1. (1-50)
                               2. (50-70)
                               Then second page will display rows 20-
                               70, not 50-70.


                               Code sample:
                               $select = ..some select from foo..
                               $adapter = new
                               Zend_Paginator_Adapter_DbSelect($sel
                               ect);
                               $paginator = new
                               Zend_Paginator($adapter);
                               $paginator->setItemCountPerPage(50);
                               $paginator-
                               >setCurrentPageNumber($this-
                               >_getParam('page'));


                               Reason:
                               mssql limit function workaround(e.g.
                               select top *(select top *(query)desc ) asc)
                               (see Db/Adapter/Pdo/Mssql.php )




                                                                             504 of 868
ZF-4692   Zend_Db_Table_Row_Abstract::findDep           0%   0%
          endentRowset find the child rows for a
          particular table for a
          Zend_Db_Table_Row object.

          It does this by building a
          Zend_Db_Table_Select object and then
          calling Zend_Db_Table_Abstract::fetchAll
          to return the rows:
          {noformat}
          public function
          findDependentRowset($dependentTable,
          $ruleKey = null, Zend_Db_Table_Select
          $select = null)
          {
          $db = $this->_getTable()->getAdapter();

          <snip> Build Zend_Db_Table_Select
          object $select </snip>

          return $dependentTable-
          >fetchAll($select);
          }
          {noformat}

          Sometimes it is more useful to have
          direct access to the $select object than it
          is to the rowset. My use case is using
          Zend_Paginator to display a paginated




                                                                  505 of 868
When enabling Zend_Paginator with
Zend_Cache and DbSelect paginator
adapter, the cached file md5() hash is
always different. So you get only cache
miss.
The problem is here.
{code}
public function
getItemsByPage($pageNumber)
{
$pageNumber = $this-
>normalizePageNumber($pageNumber);

// THE HASH IS DIFFERENT HERE
FROM -> see next down
if ($this->_cacheEnabled()) {
$data = self::$_cache->load($this-
>_getCacheId($pageNumber));
if ($data !== false) {
return $data;
}
}

$offset = ($pageNumber - 1) * $this-
>getItemCountPerPage();

$items = $this->_adapter-
>getItems($offset, $this-
>getItemCountPerPage());




                                          506 of 868
ZF-6989, ZF-10447   This is related to
                    http://framework.zend.com/issues/brows
                    e/ZF-10447

                    But I hope this may help.

                    Using the standard serialization of the
                    adapter I noticed two things ( other than
                    the DB reconnect ): -
                    1)
                    Zend_Paginator::_getCacheInternalId()
                    is called three times ( in my usage ), the
                    first md5 serialization differs from the
                    other two, probably because the last two
                    modify the _select of the adapter.
                    2) The md5 changes on every
                    subsequent page load, why I don't know
                    at this stage.

                    I tried moving away from the serialization
                    of the object to a string representation of
                    the _select of the adapter ( added a
                    getSelect() method ) this had the same
                    effect as 1) but the subsequent loads did
                    provide the same hashed strings, which
                    was an improvement.

                    I then added a static cache within the
                    Zend_Paginator::_getCacheInternalId()




                                                                  507 of 868
ZF-8731, ZF-7366, ZF-7379, ZF-8019,   When using Zend_Db_Profiler_Firebug
ZF-11668, ZF-10447, ZF-11318, ZF-     there are a few properties that store
9947, ZF-10447                        microtime values which when serializing
                                      the DbSelect adapter cause it to produce
                                      a different hash value each time.
                                      Because this hash value is used to
                                      identify what cached data to load,
                                      Zend_Cache is unable to find any cache
                                      associated to this identifier.

                                      The solution is to use __sleep() or
                                      Serializable interface




                                                                                 508 of 868
ZF-6989, ZF-6989, ZF-11318   Hi all.
                             I'll be brief.

                             First problem: please see my last
                             comment at
                             http://framework.zend.com/issues/brows
                             e/ZF-6989 because that problem is still
                             on even if the task is closed.

                             The second problem:

                             {code:java}
                             protected function _getCacheInternalId()
                             {
                             return md5(serialize(array(
                             $this->getAdapter(), $this-
                             >getItemCountPerPage())));
                             }
                             {code}

                             is a bad ideea. By serializing the
                             paginator adapter the db adapter calls
                             __sleep which sets the isConnected flag
                             to false. The next call to the db makes a
                             new connection to the db and [this is
                             what happened to me] can loose any
                             temporary tables i created. The answer
                             to this problem is fixing the first one.




                                                                         509 of 868
ZF-6989   Zend_Paginator still buggy in release-
          1.11.7 (using version from svn tag).

          When cacheing enabled:

          I think what's happening is:
          when saving result to cache
          _getCacheInternalId uses select object
          to generate id. This select object does
          have LIMIT and OFFSET set
          (Zend_Paginator line 788 adds that to
          select).
          Later when paginator tries to get results
          from cache _getCacheInternalId returns
          different id because it does not contain
          LIMIT and OFFSET.

          Also it seems that adding profiler is
          causing select object to be different on
          every request due to adding microtimes
          to certain properties so I'm not sure
          whether this has been fixed already but it
          seems it's still an issue in 1.11.7

          Cheers

          Peter




                                                       510 of 868
{{Zend_Paginator_Adapter_DbSelect}}
creates invalid SQL query for rows
counting in a case if given query have
{{GROUP BY}} clause with use of
column alias instead of column itself. For
example attempt to count rows for the
following query:

{code:sql}select a as some_column, b as
other_column
from some_table
where some_column='value'
group by some_column{code}

will produce SQL query:

{code:sql}select count(distinct
some_column)
from some_table
where some_column='value'{code}

which will fail because there is no
{{some_column}} column in table.




                                             511 of 868
I have a Zend_Db_Select object that
does several one-to-many joins on
multiple tables. I am passing that select
object to view's "paginationControl"
helper. The number of rows I get is, for
example, 5 but the paginator control's
"totalItemCount" property says 11.

Here is some example code:

Zend_Db_Select generation in the
controller action
Note ->distinct()
{code}
$select = $c->getAdapter()->select()-
>distinct();
$select->from(array('c' => 'table0'), array(
'*',
));
$select->joinLeft(array('t' => 'table1'),
'c.id = t.id',
array()
);
$select->joinLeft(array('f' => 'table2'),
'c.id = f.id',
array()
);
{code}




                                               512 of 868
ZF-6989   1. My controller:
          {code:none}
          public function indexAction()
          {

          $typeTopics = $this->_getParam('type');
          $select = $topics->prepareSelect(
          array($typeTopics=>0) );

          $paginator = new Zend_Paginator( new
          Zend_Paginator_Adapter_DbTableSelect
          ( $select ) );
          Zend_View_Helper_PaginationControl::s
          etDefaultViewPartial('pagination.phtml');
          $paginator->setCurrentPageNumber(
          $this->getRequest()->getParam( 'page',
          1 ) );
          $paginator->setItemCountPerPage( 40 );
          $paginator->setPageRange(32);

          $this->view->paginator = $paginator;

          }
          {code}
          2. In Zend_Paginator added :
          {code:none}
          protected function _getCacheInternalId()
          {
          echo md5(serialize(array(




                                                      513 of 868
Zend_Paginator_Adapter_Interface -
getItems()'s param is $offset and
$itemCountPerPage.
I suggest not $offset but $page.
Certainly we have $page because that
time is paginator controlling.
$offset is little hard to use.

Now we must write ...example
{code}
$offset = ($page - 1) *
$itemCountPerPage;
$items = $paginator->getAdapter()-
>getItems($offset, $itemCountPerPage);
{code}

I want to ...
{code}
$items = $paginator->getAdapter()-
>getItems($page, $itemCountPerPage);
{code}

And that needs the modifications, for
example in
Zend_Paginator_Adapter_DbSelect,
{code}
// Before
public function getItems($offset,
$itemCountPerPage)




                                         514 of 868
I have a more or less complex query,
with 4 joins, a sum and group aggregate
function ..
Anyway, while using the
Zend_Paginator_Adapter, the query
doesn't result anything ..
i would say that
Zend_Paginator_Adapter_DbSelect::get
CountSelect is the souce of all evil :)




http://framework.zend.com/manual/en/le
arning.paginator.together.html
{code}
$select = $db->select()->from('posts')-
>sort('date_created DESC');
{code}
should be
{code}
$select = $db->select()->from('posts')-
>order('date_created DESC');
{code}

{code}
foreach ($this->paginator as $item) {
echo '<li>' . $item->title . '</li>';
}
{code}
should be
{code}
foreach ($this->paginator as $item) {
echo '<li>' . $item["title"] . '</li>';
}
{code}




                                          515 of 868
I have a query with having clause.
The binds data are empty here:

line #217
{noformat}
$rowCount = $db->select()->from($this-
>_select);
{noformat}

my workaround:
{noformat}
$rowCount = $db->select()->bind($this-
>_select->getBind())->from($this-
>_select);
{noformat}




                                         516 of 868
The bug ZF-4032 shouldn't have been
closed :

http://framework.zend.com/issues/brows
e/ZF-4032

this query give me an error on the count
throught the function getCountSelect :

$query = parent::select(true)-
>setIntegrityCheck(false)->distinct(true)
->from(array('fu1'=>$this->_name), null)
-
>join(array('b'=>Model_Table_Blabla::$n
ame), 'b.facebook_uid =
fu1.facebook_uid', null)
-
>join(array('v'=>Model_Table_Vote::$na
me), 'v.id_blabla = b.id_blabla', null)
->join(array('fu2'=>$this->_name),
'v.facebook_uid = fu2.facebook_uid')
->where('fu1.facebook_uid = ?',
$array['facebook_user']-
>getFacebookUid());

------------

When using the
Zend_Paginator_Adapter_DBselect() on




                                            517 of 868
When using the
Zend_Paginator_Adapter_DBselect() on
a select statement as such;

$select = $this->db->select()
->from("IPLog", "DISTINCT(IP)");

or

$select = $this->db->select()
->from("IPLog", "IP")
->DISTINCT(true);

the counting of rows goes wrong, since
in my case there's 2 unique IP's in the
table, but I get 43 since there's 43 rows
in total. This causes my paginator
controls to show more pages then there
really are. The problem seems to be that
the count() method of the DBselect
adapter resets the columns, without
checking for result limitting expressions.


//update;

Thanks updating to latest svn and using
the group by did the trick, doesn't work
with 1.6.0RC2 though, so any change




                                             518 of 868
When Session is enabled i get the
following exception from
Zend_Paginator_SerializableLimitIterator
:

{code}
Uncaught exception
'OutOfBoundsException' with message
'Cannot seek to 10 which is behind offset
0 plus count 10' in
C:\Zend\ZendServer\share\ZendFramew
ork\library\Zend\Paginator\SerializableLi
mitIterator.php:80
Stack trace:
#0
C:\Zend\ZendServer\share\ZendFramew
ork\library\Zend\Paginator\SerializableLi
mitIterator.php(80): LimitIterator-
&gt;seek(10)
#1 [internal function]:
Zend_Paginator_SerializableLimitIterator-
&gt;unserialize('a:4:{s:2:&quot;it&quot;;O
...')
#2
C:\Zend\ZendServer\share\ZendFramew
ork\library\Zend\Session.php(480):
session_start()
#3
C:\Zend\Apache2\htdocs\pikee_zf\applic




                                             519 of 868
I use new version Zend Framework.
1.11.9
I'm trying to cache paginator data and I
still have a problem with cache files.
Every time the new cache file is created.


My sample code:

...
$skladnia->order('idxmat.nazwa1 ASC');
$adapter = new
Zend_Paginator_Adapter_DbSelect($skl
adnia);
$adapter->setRowCount($rowCount);

$paginator = new
Zend_Paginator($adapter);
$fO = array('lifetime' => 21600,
'automatic_serialization' => true);
$bO = array('cache_dir' =>
APPLICATION_PATH . '/../data/cache/');
$cache = Zend_Cache::factory('Core',
'File', $fO, $bO);
$paginator->setCache($cache);

$paginator-
>setItemCountPerPage($itemPerPage)
->setPageRange($pageRange)




                                            520 of 868
The SQL query for limiting and offsetting
results isn't being created properly for
DB2 running on the IBM i (a.k.a., iSeries,
AS/400).

In my use case, the paginator is set to 20
items per page, and there are 26 items.

It works fine for page 1 ("fetch first 20
rows only" is appended to the end of the
SQL query).

For page 2, however, the SQL being
created by
Zend_Paginator_Adapter_DbSelect is
like this:

{{SELECT z2.* FROM ( SELECT
ROW_NUMBER() OVER() AS
"ZEND_DB_ROWNUM", z1.* FROM (
SELECT field1, field2, field3 FROM
table1 INNER JOIN table2 ON somefield
= someotherfield WHERE (field4 = 'foo')
ORDER BY field1 DESC ) z1 ) z2
WHERE z2.zend_db_rownum
BETWEEN 21 AND 40}}

... and it returns the first six rows (that is,
rows 1-6, not rows 21-26), ordered by
In method render
call for helper paginationControl

$view->paginationControl($this , $this-
>getViewPartial() , $this-
>getScrollingStyle() );




                                                  521 of 868
ZF-10659   I found this bug using Zend_Paginator
           when requesting for the last page of the
           paginator.
           if we have a dataset of 12 items and
           want to display 5 items per page like this:

           $paginator = new \Zend_Paginator(new
           \Zend_Paginator_Adapter_DbSelect($sel
           ect));
           $paginator->setCurrentPageNumber(3);
           $paginator->setItemCountPerPage(5);
           $currentItem = $paginator-
           >getCurrentItems();

           If we try to access the last page where
           we should have 2 items (12 - offset) we
           instead get 5 items because the limit
           does not change (it's always "$this-
           >getItemCountPerPage()").
           To return the right number of result for
           the last page, we have to calculate the
           new limit. This is only happening when
           using a
           "Zend_Paginator_Adapter_DbSelect"
           and MSSQL as MSSQL will always
           return records (because there is no
           offset functionality for MSSQL).
           The correction is done directly into
           Zend_Paginator (the root of the bug)




                                                         522 of 868
I use a Paginator with DBSelect for         0%   0%
querying the database. See the following
code:
{code}
$select = $this->db->select();
$select->from(array("v" => "table"),
array("DateDayFormat" => new
Zend_Db_Expr("DATE_FORMAT(v.First
VisitTime, '%d.%m.%Y')"),
"PageCalls" => new
Zend_Db_Expr("SUM(v.PageCalls)"),
))
->group("DATE(v.FirstVisitTime)")
->order("DATE(v.FirstVisitTime) DESC");
$paginator = new Zend_Paginator(new
Zend_Paginator_Adapter_DbSelect($sel
ect));
$paginator->setItemCountPerPage(20);
$paginator-
>setCurrentPageNumber($this-
>_getParam("page", 1));
$this->view->paginator = $paginator;
{code}

The select should return 6.5 pages, but
there are 42 pages. the 7th to the 42nd
page are empty.
this problem occurs also with other
selects, so it seems to be a bug - or did




                                                      523 of 868
I have read here
http://framework.zend.com/issues/brows
e/ZF-8731 - fixed with r22302
I do not understand. Does not work!
I use a simple way:
$paginator =
Zend_Paginator::factory($select);
Zend_Paginator::setCache($cache);
My $select it
Zend_Paginator_Adapter_DbSelect or
Zend_Paginator_Adapter_DbTableSelect
But when i call $paginator-
>getCurrentItems(), the method
getItemsByPage() twice made the call
$this->_getCacheId($pageNumber) (read
and write cache), but the second time is
called after calling $this->_adapter-
>getItems(), which changes _adapter,
and key cache is formed from the
adapter. Are you sure that now
everything is working correctly?

I'm using framework version 1.11.4
Thank you for help or explanation




                                           524 of 868
It is mentioned in the bug 5956            0%   0%
[http://framework.zend.com/issues/brows
e/ZF-5956] that the problem with Zend
Paginator while selecting UNION query is
fixed in revision 16144 but i have
checked out for the latest Trunck today
but the problem persists.

We are still getting this crash:
exception 'Zend_Db_Select_Exception'
with message 'No table has been
specified for the FROM clause'

The code looks like below:

Lets say $select1 and $select2 are
Zend_Db_Selects that give identical
fields.

Then we do $select1 UNION $select2:
$select = $db->select()-
>union(array($select1, $select2));

$paginator =
Zend_Paginator::factory($select);

The above exception raises at this level
i.e.
'Zend_Db_Select_Exception' with




                                                     525 of 868
Zend_Paginator_Adapter_DbSelect-
>getCountSelect() - the count query
produced by this method fails if the
original Zend_Db_Select contains "order
by" (and using
Zend_Db_Adapter_Sqlsrv).

The sql generated by the
Zend_Db_Select object is ok:

$select = $db->select()
->from(array('icp' => 'icn_ptnt'),
array('Surname', 'Firstname'))
->join(array('apm' =>
'abx_patient_medications'),
'icp.Patient_No = apm.patient_id',
array())
->group(array('Surname', 'Firstname'))
->order(array('Surname'));

SELECT "icp"."Surname",
"icp"."Firstname" FROM "icn_ptnt" AS
"icp"
INNER JOIN "abx_patient_medications"
AS "apm" ON icp.Patient_No =
apm.patient_id GROUP BY "Surname",
"Firstname" ORDER BY "Surname" ASC

However, an error is encoutered once




                                          526 of 868
I have a big query and a lots of data.So i
have to use pagination.But i have to write
the query in which all the data are
fetched and then pass in the pagination
class. but i want the only 15 row and
query should be like that limit 15 and only
when i click on page 2 then another 15-
30 query should be executed. So it
consume less time and if i want to see
only 1st page then i don't wait for more
time. Now i have to wait until all the data
are not fetched.Is there any kind of way
to write a paging query that i want?


When running tests in the
Zend/Paginator/ the following failure is
present.
{code}
PHP Fatal error: Call to a member
function query() on a non-object in
/var/www/zf-
trunk/tests/Zend/Paginator/Adapter/DbSe
lect/OracleTest.php on line 121
{code}

Problem in the
Zend_Paginator_Adapter_DbSelect_Ora
cleTest::tearDown()




                                              527 of 868
ZF-8886   When using the paginationcontrol view
          helper, the count()-method on the
          adapter get's called twice through the
          methods _calculatePageCount() and
          getTotalItemCount().

          {noformat}
          protected function
          _calculatePageCount()
          {
          return (integer) ceil($this->getAdapter()-
          >count() / $this-
          >getItemCountPerPage());
          }
          {noformat}

          and

          {noformat}
          public function getTotalItemCount()
          {
          return count($this->getAdapter());
          }
          {noformat}

          The return value of the adapter's count()-
          method should be held in a class
          member:




                                                       528 of 868
ZF-10260   I don't see a reason for line 712:
           {code}
           $this->_pageCount = $this-
           >_calculatePageCount();
           {code}

           This could be changed to:
           {code}
           $this->_pageCount = null;
           {code}

           Page count would be then lazy loaded.




                                                   529 of 868
When using custom $rowCount as
shown on example in
[manual|http://framework.zend.com/man
ual/en/zend.paginator.usage.html#zend.p
aginator.usage.dbselect]:

{code:none}
$row_count->from(
array('table_name'),
array(
Zend_Paginator_Adapter_DbSelect::RO
W_COUNT_COLUMN => new
Zend_Db_Expr('COUNT(DISTINCT id)')
)
);
{code}
it throws 'Row count column not found'
exception, because there is wrong
checking for ROW_COUNT_COLUMN
when using 'AS_field' => 'db_expr'.
Current assigment:
{code:none}
$columns = $rowCount-
>getPart(Zend_Db_Select::COLUMNS);
$countColumnPart = $columns[0][1];
{code}
is not aware of 'AS' part, which is stored
in $columns[0][2], and throws exception.




                                             530 of 868
ZF-8085, ZF-10798   Some files contain CRLF:                        100%   100%    900
                    {code}
                    find . -name '*.php' -print0 | xargs -0 sed -
                    -regexp-extended --in-place 's/\r\n/\n/g'
                    {code}

                    Some files contain TABS:
                    {code}
                    find . -name '*.php' -print0 | xargs -0 sed -
                    -regexp-extended --in-place 's/\t/ /g'
                    {code}

                    Some files contain endline spaces:
                    {code}
                    find . -name '*.php' -print0 | xargs -0 sed -
                    -regexp-extended --in-place 's/[ ]*$//g'
                    {code}

                    By running this 3 commands on the top
                    of standard directory. It could be applied
                    to library and tests.

                    After that, a pre-commit hook could be
                    added to test all of them (but it's another
                    history ;) )




                                                                                  531 of 868
I am trying to send extra parameter to
links of paging. I am using Zend
Paginator. currently link is

/user/list/page/2

I want to send additional parameters as
well

/user/list/address/a/page/2

Here is the detail of my code:

//In Controller:
$page=$this->_getParam('page',1);
$paginator =
Zend_Paginator::factory($rowSet);
$paginator->setItemCountPerPage(50);
$paginator-
>setCurrentPageNumber($page);

$this->view->clientList = $paginator;
$this->view->paginator=$paginator;
//In View:
<?php echo $this-
>paginationControl($this->paginator,
'Sliding', 'pagination_control.phtml'); ?>

I want to pass the parameters from text




                                             532 of 868
This is really really small sugestion how
this method could get improved. Now it
takes two types of arguments:
Zend_Db_Select or integer. It would be
nice if it would accept string containing
integers like "54" and not just plain
integers 54. I came accross this problem
when I called this method with result of
some count query.

// old lines
} else if (is_integer($rowCount)) {
$this->_rowCount = $rowCount;
} else {

// replacement lines
} else if (is_integer($rowCount) ||
preg_match('#^\d+$#', $rowCount)>0) {
$this->_rowCount = (int)$rowCount; //
(almost) save cast
} else {

This way programmer wouldn't have to
worry to cast string to integer on method
invocation.




                                            533 of 868
Zend_Paginator_Adapter_Interface
contains the method signature and
docblock for count() but the signature is
commented out.

This is irritating because an IDE would
return the docblock for
Countable::count().
There should either be a note in the
methods or class' docblock why it is
commented out, or the method + her
docblock should be removed completely
or the comment removed.




                                            534 of 868
{noformat}
phpunit Zend/Paginator/AllTests.php
PHPUnit 3.4.15 by Sebastian Bergmann.

.Segmentation fault
{noformat}

{noformat}
php Zend/Paginator/AllTests.php
PHPUnit 3.4.15 by Sebastian Bergmann.

.Segmentation fault
{noformat}

{noformat}
phpunit Zend/PaginatorTest.php
PHPUnit 3.4.15 by Sebastian Bergmann.

.Segmentation fault
{noformat}

{noformat}
php -v
PHP 5.3.3 (cli) (built: Oct 6 2010
19:15:53)
Copyright (c) 1997-2010 The PHP Group
Zend Engine v2.3.0, Copyright (c) 1998-
2010 Zend Technologies




                                          535 of 868
{noformat}
phpunit Zend/Paginator/AllTests.php
PHPUnit 3.4.15 by Sebastian Bergmann.

............................................................
60 / 177
....F.......................................................
120 / 177
.........................................................

Time: 1 second, Memory: 16.50Mb

There was 1 failure:

1)
Zend_PaginatorTest::testArrayAccessIn
ClassSerializableLimitIterator
Failed asserting that <null> matches
expected <integer:0>.

/home/mabe/workspace/zf-
trunk/tests/Zend/PaginatorTest.php:1019

FAILURES!
Tests: 177, Assertions: 370, Failures: 1.
{noformat}




                                                               536 of 868
The way _getCacheInternalId() generate
the md5 has at the moment only use
classname of the adapter, not the object
variables

return md5(serialize(array(
get_class($this->getAdapter()),
$this->getItemCountPerPage()
)));

So say I have multiple paginated lists
that use the same DBTable adapter,
each list is a result of a different DB
query, they will be mixed if I use caching
for the paginator.

The solution could be replacing
get_class with get_object_vars, but that
requires making adapter variables public
instead of protected.
{code:php}

$paginator = new Zend_Paginator(new
Zend_Paginator_Adapter_Null(2));
$paginator->setCurrentPageNumber(1);
$paginator->setItemCountPerPage(50);
$pages = $paginator->getPages();

// Will be 2
echo $pages->totalItemCount;

// Will be 50
echo $pages->lastItemNumber;


{code}




                                             537 of 868
ZF-9920, ZF-10180   I think there should also be static
                    defaultPageRange set/get Properties
                    File: Zend_Paginator.php
                    Method: protected function
                    _getCacheInternalId() on line 1013
                    protected function _getCacheInternalId()
                    {
                    return md5(serialize(array(
                    get_class($this->getAdapter()),
                    $this->getItemCountPerPage()
                    )));
                    }

                    If the getAdapter() return a
                    Zend_Paginator_Adapter_DbSelect
                    object, it will always be
                    'Zend_Paginator_Adapter_DbSelect'. So
                    $select->where('type = ?', news) and
                    $select->where('type = ?', 'blog') will
                    have the same cache id.




                                                               538 of 868
          When using the paginationcontrol view
          helper, the count()-method on the
          adapter get's called twice through the
          methods _calculatePageCount() and
          getTotalItemCount().

          {noformat}
          protected function
          _calculatePageCount()
          {
          return (integer) ceil($this->getAdapter()-
          >count() / $this-
          >getItemCountPerPage());
          }
          {noformat}

          and

          {noformat}
          public function getTotalItemCount()
          {
          return count($this->getAdapter());
          }
          {noformat}

          The return value of the adapter's count()-
          method should be held in a class
          member and this method should be used
          in _calculatePageCount() so the same
ZF-9174   It would be helpful to have default page
          range be available as a static property on
          Zend_Paginator. There is already a static
          property for default item count per page.
          At the moment, to maintain consistent
          pagination controls, the page range must
          be set on each individual instance of
          Zend_Pagintator.

          Patch against 1.10.6 to follow.


                                                       539 of 868
I'm not sure if this is a bug.

When u use an Zend_Paginator and
assign a view with additional variables.
The variables are not available inside the
view script (phtml).

{code}
$paginator = new Zend_Paginator(new
Zend_Paginator_Adapter_Null(100));
$paginator->setCurrentPageNumber(1);
$paginator->setItemCountPerPage(10);
$paginator->setPageRange(10);
$this->view->assign('paginator',
$paginator);
$this->view->assign('someOther',
"value10");
{code}

<paginator.phtml>
{code}
echo $this->someOther; --> will be null
{code}

it seems that the
Zend_View_Helper_Partial clears the
variables inside the cloneView() method
and the PaginationControl executes this
method:
$item = $page[$itemNumber - 1] will
throw an exception because
Zend_Paginator_SerializableLimitIterator
does not implement ArrayAccess




                                             540 of 868
ZF-9174, ZF-5785   Zend_Paginator should offer
                   setDefaultPageRange().

                   How it should work:
                   Zend_Paginator::setDefaultPageRange(i
                   nt $count); //would change from 10 to
                   $count
ZF-9920            Zend_Paginator should offer
                   setDefaultItemCountPerPage().

                   Scenario:
                   Someone is using Zend_Paginator in his
                   project and suddenly realizes that he
                   don't want default 10 items per page, but
                   he didn't use $paginator-
                   >setDefaultItemCountPerPage(10) - so
                   he can't use replace.

                   How it should work:
                   Zend_Paginator::setDefaultItemCountPe
                   rPage(int $count); //would change from
                   10 to $count
                   The specified return type of
                   Zend_Paginator_AdapterAggregate::get
                   PaginatorAdapter() should be
                   Zend_Paginator_Adapter_Interface
                   instead of
                   Zend_Paginator_Adapter_Abstract.
                   Please update the doc-comment.




                                                               541 of 868
You currently have to create a new view
script for every paginator instance you
want to use on a single page.

This is caused by the paginator view
script setting the url page parameter. If
each paginator instance uses the same
view script then when you paginate one
you will paginate all.

Here is the code to fix this.

I would like to commit it to the trunk but I
wanted someone else to review this first.

{code}
class Paginator extends Zend_Paginator
{
public $pageName = 'page';

public function getPages($scrollingStyle
= null)
{
$pages =
parent::getPages($scrollingStyle);

$pages->pageName = $this-
>pageName;




                                               542 of 868
Given a query with named parameter
placeholders, eg
{code}
SELECT * FROM TABLE WHERE
STATUS = :status
{code}

there's currently no way to pass the array
of bind variables to the pagination
adapter for use in the getItems() or
count() / setRowCount() methods.

Given that this is the recommended
method of parameter passing (at least
for non-string values), shouldn't it be
supported by the adapter?




                                             543 of 868
In release 1.10.5 the following code in
Zend_Paginator was changed:
{code}
return md5(serialize($this->getAdapter())
. $this->getItemCountPerPage());
{code}
to
{code}
return md5(serialize(array(
get_class($this->getAdapter()),
$this->getItemCountPerPage()
)));
{code}
This assumes that a
Zend_Paginator_Adapter class is used
only once in the whole application. I'm
using a modified version of the DbSelect
adapter so that the adapter is loaded
with different Zend_Db_Select objects.
But with the current caching
implementation, this always leads to the
same cache id because only the class
name and the item counter are serialized
which are the same for all objects.




1.8.0 or over : Zend_Pageinator's
method clearPageItemCache() has this
code.

$cleanTags =
self::CACHE_TAG_PREFIX;

I think that there is no reason, and
removing it is better.



                                            544 of 868
ZF-6989   File Zend_Paginator.php
          method: public function
          getItemsByPage($pageNumber) on line
          737

          issue:

          Method will check if cache enable and
          cache ID exists it will return the cached
          data.
          {code}
          if ($this->_cacheEnabled()) {
          $data = self::$_cache->load($this-
          >_getCacheId($pageNumber));
          if ($data !== false) {
          return $data;
          }
          }
          {code}

          If cache is enable but does not exists It
          will get data and cached with a cache ID.

          {code}
          if ($this->_cacheEnabled()) {
          self::$_cache->save($items, $this-
          >_getCacheId($pageNumber),
          array($this->_getCacheInternalId()));
          }
ZF-6989   Problem, Cache is duplicate when It was
          created before. I used Mysqli Adaptor
          Table Select for this case.
          I think md5(Page_Apdator ) is not good
          in this case.




                                                      545 of 868
ZF-6989   Hello,

          I found a bug in Zend_Paginator. If we
          enable caching of queries to the
          database through Zend_Paginator:
          {code}
          $cache = Zend_Cache::factory('Core',
          'File', $frontendOptions,
          $backendOptions);
          Zend_Paginator::setCache($cache);
          {code}
          ....and then run the page with the
          following code:
          {code}
          $news = new
          Default_Model_DbTable_News();
          $select = $news->select();
          $paginator =
          Zend_Paginator::factory($select);

          $page = (int)$this->_getParam('page', 1);
          $paginator->setItemCountPerPage(1);
          $paginator-
          >setCurrentPageNumber($page);
          $this->view->result = $paginator;
          {code}
          ...it will execute 4 queries:

          0.00359 connect NULL




                                                      546 of 868
It would be nice if Zend_Paginator
supported an infinite item count per page
by passing in a zero (0) as the argument
to the setItemCountPerPage method.
This would be useful when one wants
allow the user to select the item count
per page, e.g. "show 25, 50, 100, All
items per page". Currently passing a
negative one (-1) provides this
functionality but is not an intended
feature according to this email exchange
with Matthew Ratzloff:

On Mon, Dec 29, 2008 at 5:18 PM,
Matthew Ratzloff
<matt@builtfromsource.com> wrote:
> Hi Bradley,
> Sorry about the confusion, I misread
your requirement. The -1 trick is in
> fact not an intended feature (if it were,
it would be 0, to be in line with
> typical PHP API), but if it works, use it
for now. Whatever fix will just
> test for < 1, so your code should be
forward-compatible.
> I highly encourage you to file an
enhancement ticket so that this can be
> implemented properly. If you do,
please copy and paste this e-mail
the function
getPagesInRange($lowerBound,
$upperBound) gets sometimes passed
float type arguments instead of int's. this
causes the function to never complete
because the the for loop never reaches
its exit-condition.

system: win32 vista / php 5.3.0 / apache
2.2.11 / mysqld (various versions)


                                              547 of 868
          PaginationControl does not currently
          support modules, although
          Zend_View_Helper_Partial does.
          Change the method call to support this
          by making the $partial parameter accept
          either a string or an array composed of a
          module and a partial.
ZF-7335   I will add them. Currently we have this
          page:
          http://framework.zend.com/wiki/display/Z
          FDEV/Subversion+Standards#Subversio
          nStandards-TipSVNautoprops




                                                      548 of 868
ZF-9029   I will add them if necessary.
          Currently we have this page:
          http://framework.zend.com/wiki/display/Z
          FDEV/Subversion+Standards#Subversio
          nStandards-TipSVNautoprops
          If it's important, perhaps we could add it
          into coding standards.




                                                       549 of 868
I am having difficulty in saving the db
selection following the initial selection.

My development environment is XP,
xampp, mySql
Apache/2.2.12 (Win32) DAV/2
mod_ssl/2.2.12 OpenSSL/0.9.8k
mod_autoindex_color PHP/5.3.0
mod_perl/2.0.4 Perl/v5.10.0

I am able to save the select statement as
a session[] variable. This works except
for the warning message. (noted in the
docs)

Using Zend_Session as a replacement
for session gives the error message:
'Cannot send headers; headers already
sent in ...

I am able to use Zend_Session variables
where the paginator is not involved.

I also have tried to use Zend_cache as
shown in the paginator documentation.

The code for the Model with the
paginator is:




                                             550 of 868
Zend_Paginator and cache. How can I
read the datas that I have sent to cache

zend_cache---
Zend_Paginator_1_42242d5fa3c4e4b77
58810c276163e8a

but I can't read.

$request = $this->getRequest();
$q = new Model();
$paginator = Zend_Paginator::factory($q-
>fetchAll());
$paginator-
>setCurrentPageNumber($request-
>getParam('p'));
$paginator->setItemCountPerPage(40);
$this->view->q = $paginator;

$fO = array('lifetime' => 3600,
'automatic_serialization' => true);
$bO = array('cache_dir'=>
APPLICATION_PATH . '/cache/');
$cache = Zend_cache::factory('Core',
'File', $fO, $bO);
Zend_Paginator::setCache($cache);




                                           551 of 868
ZF-4151   When using Zend_Paginator I ran into a
          problem since the 1.10.x versions.

          In some 1.9.x code I'm using something
          like this:
          {code}
          // $total is set some where in the code,
          could be some query result.
          // After some code, we get the following
          'settings'.
          $total = 0;
          $page = 1;
          $itemsPerPage = 5;

          // Create paginator with null adapter.
          $paginator = new Zend_Paginator(new
          Zend_Paginator_Adapter_Null($total));
          $paginator-
          >setCurrentPageNumber($page);
          $paginator-
          >setItemCountPerPage($itemsPerPage);

          // Get in in view.
          $this->view->paginator = $paginator;
          {code}

          Works fine in 1.9.x, in 1.10.x I get an
          error because of some array error.




                                                     552 of 868
ZF-9260   I've been playing around with
          Zend_Paginator using the
          Zend_Paginator_Adapter_Iterator. All
          went pretty good, until I passed
          Zend_Paginator 0 items/pages. I get the
          following exception:

          {quote}
          exception 'OutOfBoundsException' with
          message 'Seek position 0 is out of range'

          #0 [internal function]: ArrayIterator-
          >seek(0)
          {quote}

          Now this exception is not a suprise, after
          all......it's seeking 0. The question I have
          is how to handle this exception? I use a
          foreach loop in my view to iterate over
          each item in the paginator and that's
          what's causing the exception:

          {code}
          foreach ($this->paginator as $item){}
          {code}

          Should I always check if there are 0
          pages/items in the view and not start the
          foreach loop? Doing so would require a




                                                         553 of 868
ZF-5231, ZF-5620   The SQL query builded through
                   Zend_Db_Select and executed in
                   phpMyAdmin (it work's as i expected):

                   SELECT DISTINCT `sety`.`set_id`,
                   `sety`.`nazev`, `sety`.`imgs`, (SELECT
                   GROUP_CONCAT(divka_id
                   SEPARATOR '|') FROM sety_divky AS
                   sd2 WHERE sety_divky.set_id =
                   sd2.set_id) AS `divka_id`, (SELECT
                   GROUP_CONCAT(jmeno SEPARATOR
                   '|') FROM sety_divky AS sd2 JOIN divky
                   ON sd2.divka_id = divky.divka_id
                   WHERE sety_divky.set_id = sd2.set_id)
                   AS `divka`, `galerie`.`nazev` AS `galerie`,
                   `skupina`.`nazev` AS `skupina` FROM
                   `sety` INNER JOIN `sety_divky` ON
                   sety.set_id = sety_divky.set_id LEFT
                   JOIN `galerie` ON sety.galerie_id =
                   galerie.galerie_id LEFT JOIN `skupina`
                   ON galerie.skupina_id =
                   skupina.skupina_id ORDER BY
                   `galerie`.`nazev` asc, `sety`.`nazev` asc

                   same query executed in Zend_Paginator
                   through
                   Zend_Paginator_Adabter_DbSelect
                   throws SQL error
                   SQLSTATE[23000]: Integrity constraint




                                                                 554 of 868
ZF-5278   PATCH:

          $ diff -u
          Zend/Paginator/Adapter/DbSelect.php
          Zend/Paginator/Adapter/DbSelect.php.ne
          w
          --- Zend/Paginator/Adapter/DbSelect.php
          2008-11-04 23:49:22.000000000 +0200
          +++
          Zend/Paginator/Adapter/DbSelect.php.ne
          w 2009-01-26 22:44:30.000000000
          +0200
          @@ -163,7 +163,7 @@
          if ($part[1] == '*' || $part[1] instanceof
          Zend_Db_Expr) {
          $columns[] = $part[1];
          } else {

          - $columns[] = $rowCount->getAdapter()-
          >quoteIdentifier($part[1], true);

          + $columns[] = $rowCount->getAdapter()-
          >quoteIdentifier($part[0] . '.' . $part[1],
          true);

          }
          }


          Attaching patch with improvement.


          I'm using




                                                        555 of 868
          If you use the iterator adapter and a
          serializing cache like the following you
          will crash php:
          {code}
          <?php


          set_include_path('/tmp/zf/trunk/library/');
          require_once
          'Zend/Loader/Autoloader.php';
          $autoloader =
          Zend_Loader_Autoloader::getInstance();
          $view = new Zend_View();

          try {
          $frontendOptions = array(
          'caching' => true,
          'lifetime' => 72000,
          'automatic_serialization' => true
          );
          $backendOptions = array(
          'cache_dir' => '/tmp/invite_vcfront' //
          Directory where to put the cache files
          );
          $cache =
          Zend_Cache::factory('Core','File',
          $frontendOptions,$backendOptions);
          Zend_Paginator::setCache($cache);

ZF-7259   When having a Select with an orWhere
          method called (and the searched fieldX
          is from a table left joined to the first one),
          it will fail (in the adapter's method count()
          ) with a message like (fieldsX not found).

          The solution is to reset also the where
          part of the Select (in the
          getCountSelect() adapter's method ).


                                                           556 of 868
ZF-7127, ZF-7689   i am find an problem using
                   Zend_Paginator_Adapter_DbSelect,
                   my object is used the WHERE and
                   launched an exception


                   added to the method getCountSelect

                   $rowCount-
                   >reset(Zend_Db_Select::WHERE)
                   When using
                   Zend_Paginator_ScrollingStyle_Elastic e.
                   g. with a pageRange of 3 and a number
                   of 10 pages, the following page links are
                   generated:

                   page 1:
                   [1] 2 3

                   page 2:
                   1 [2] 3 4

                   page 3:
                   1 2 [3] 4 5

                   [...]

                   page 8:
                   6 7 [8] 9 10

                   page 9:
                   6 7 8 [9] 10
                   (should be 7 8 [9] 10)

                   page 10:
                   6 7 8 9 [10]
                   (should be 8 9 [10])




                                                               557 of 868
ZF-7259   Until version 1.8.3 the following code
          worked perfectly but with the update to
          ZF 1.8.4 the following error occurs:
          SQLSTATE[42S22]: Column not found:
          1054 Unknown column 'c.ModuleName'
          in 'where clause'

          $select = $this->db->select();
          $select->from(array("c" =>
          "mvc_pagecalls"),
          array("ModuleName", "ControllerName",
          "ActionName", "ObjectID"))
          ->group("c.ModuleName")
          ->group("c.ControllerName")
          ->group("c.ActionName")
          ->group("c.ObjectID")
          ->where("c.ModuleName = ?", 'admin');
          $paginator = new Zend_Paginator(new
          Zend_Paginator_Adapter_DbSelect($sel
          ect));
          $paginator->setItemCountPerPage(20);
          $paginator-
          >setCurrentPageNumber($this-
          >_getParam("page", 1));
          $this->view->paginator = $paginator;

          so i tried to dump the sql-string ($select-
          >__tostring) and execute it in the
          phpmyadmin. The query was valid and




                                                        558 of 868
I tried to paginate my data from DB, i
learned many tutorials about
zend_paginator, but nothing helped me...
Now some PHP:


__IN MODEL__
{code}

$db=Zend_Registry::get('db');
$select = $db->select()->from($this-
>_name)-
>where('category=\''.mysql_real_escape
_string($type).'\'');
$dat['paginator'] =
Zend_Paginator::factory($select);
$dat['paginator']-
>setCurrentPageNumber($data['offset']);
$dat['paginator']-
>setItemCountPerPage(20);
// all variables are set and correct, i
checked
{code}
__IN CONTROLLER__
{code}
$this->view->paginator=$this-
>setsegments($data); //here is our
$dat['paginator'] from model
echo ( $this->view->paginator instanceof




                                           559 of 868
ZF-3239   Instances of Zend_Db_Table_Select do
          not work with Zend_Paginator unless you
          specify a from clause (which is
          redundant for Zend_Db_Table_Select).

          <?php

          // Does not work
          $table = new MyTable();
          $select = $table->select();
          $paginator =
          Zend_Paginator::factory($select); //
          Throws exception "No table has been
          specified for the FROM clause"

          // This works
          $table = new MyTable();
          $select = $table->select()
          ->from($table); // Required by
          Zend_Paginator
          $paginator =
          Zend_Paginator::factory($select); //
          Works

          ?>

          Zend_Paginator makes cache ids from
          spl_object_hash($this), which changes
          throught HTTP request making Paginator
          unable to load its data back from cache,
          and also making it duplicate them in the
          cache.




                                                     560 of 868
The IteratorAggregate Interface is a nice   0%   0%
way to write Iterators that contain only
small deviations from any existing
iterator.

I have a patch to propose the same for
Zend_Paginator, an interface called
"Zend_Paginator_AdapterAggregate"
which has the method
getPaginatorAdapter() that creates a
Paginator Adapter.

This interface must be supported in two
locations of Zend_Paginator, the factory
method and the constructor.

Here is the testcode, that shows the
behaviour:

{code}
class
Zend_Paginator_TestArrayAggregate
implements
Zend_Paginator_AdapterAggregate
{
public function getPaginatorAdapter()
{
return new
Zend_Paginator_Adapter_Array(array(1,




                                                      561 of 868
This is another bug, which isn't properly
fixed at ZF-7207. I think this error is
created by ZF-5785.

Paginator doesn't use
"_defaultItemCountPerPage" and show
all items instead of only
_itemCountPerPage, if I don't set
$paginator-
>setItemCountPerPage($number);

To fix this bug, you should replace all
$this->_itemCountPerPage to $this-
>getItemCountPerPage(), as I said in ZF-
7207.




                                            562 of 868
If you don't specify ItemCountPerPage
(using setItemCountPerPage(int); or only
call getItemCountPerPage();) on
Zend_Paginator object , you'll get
warning "Division by zero".

Stacktrace:
{code}
Warning: Division by zero in
\library\Zend\Paginator.php on line 995
Call Stack
# Time Memory Function Location
(...)
6 1,2761 11095744 Zend_Paginator-
>getPages( ) ..\MyController.php:197
7 1,2761 11095744 Zend_Paginator-
>_createPages( ) ..\Paginator.php:791
8 1,2761 11097256 Zend_Paginator-
>count( ) ..\Paginator.php:1006
9 1,2761 11097408 Zend_Paginator-
>_calculatePageCount( )
..\Paginator.php:471
{code}

You should use
"getItemCountPerPage()" internally in
Zend_Paginator class instead of private
var, or initialize this private variable in
constructor.




                                              563 of 868
Hi there,                             0%   0%

I have problem after Zend_Paginator
tries to get the number of results.

Here is the example:

{code:title=OK|borderStyle=solid}
$users = new Users();
$rows = $users->fetchAll($select);
{code}

{code:SQL|title=Performed
query|borderStyle=solid}
SELECT
`users`.`id`,
`users`.`first_name`,
`users`.`last_name`,
`users`.`position`,
`users`.`username`,
`users`.`email`,
(
SELECT time
FROM events
WHERE
events.target_id = users.id
AND
action = 'eventLogin'
AND




                                                564 of 868
When using                                   0%   0%
Zend_Paginator_Adapter_Null,
Zend_Paginator::_pages-
>lastItemNumber is set incorrectly. This
is because
Zend_Paginator_Adapter_Null::getItems(
) returns an empty array, which
Zend_Paginator::getItemsByPage() casts
to an empty ArrayIterator, which, in turn,
sets Zend_Paginator::_pages-
>lastItemNumber to an incorrect number.
Shouldn't
Zend_Paginator_Adapter_Null::getItems(
) return an array containing the number
of empty values equal to
Zend_Paginator_Adapter_Null::_count ?
Am I overlooking something?

Here's a patch:

Index: Paginator/Adapter/Null.php
===============================
===============================
=====
--- Paginator/Adapter/Null.php (revision
10727)
+++ Paginator/Adapter/Null.php (working
copy)
@@ -58,7 +58,7 @@




                                                       565 of 868
Emanuele Deserti:                            0%   0%
How I can identify the last item in my
paginator?
NOT the last in the current page, but the
last item in the last page.

For example: I have 100 items paginated
into 5 pages (20 items per page); I need
to display custom content only for the
100th (the last of all).

I've tried with getTotalItemCount(),
getCurrentItemCount() and so on but
without success...
Also googled around and look into API
core doc but nothing useful found...

---

Matthew Razloff:
You should be able to do something like
this (after setting up the paginator):

$item = end($paginator-
>getItemsByPage(count($paginator)));

Untested, but that should at least put you
on the right track.




                                                       566 of 868
The documention for                        0%   0%
Zend_View_Helper_PaginationControl::s
etDefaultViewPartial() says:
{{@param string $partial View partial}}

When the parameter can also be an
array containing a filename and a
module name - which can lead to
confusion when trying to set the default
partial to something in another module.


In                                         0%   0%
http://framework.zend.com/manual/en/ze
nd.paginator.usage.html
{quote}
You could then access paginator values
from a template like so:
{$pages.pageCount}
{quote}

should be replaced by :
{$pages->pageCount}




                                                     567 of 868
ZF-6989   Caching is not working correctly when
          using Zend_Paginator to paginate
          Zend_Db_Select results. The values are
          being cached (I can see the files in my
          cache location), but they are not being
          used.

          The problem is that the cache IDs are
          being generated incorrectly.

          {code:title=Feed.php}
          class Dashboard_Feed extends
          Zend_Db_Table_Abstract
          {
          protected $_name = 'FEED';
          protected $_primary = 'FEED_ID';
          }
          {code}

          {code:title=FeedController.php}
          $feed = new Dashboard_Feed(
          Zend_Registry::get('db') );
          $select = $feed->select()-
          >order('FEED_TITLE' );

          $paginator = Zend_Paginator::factory(
          $select );
          $paginator->setCache(
          Zend_Registry::get('cache') );




                                                    568 of 868
If itemCountPerPage is set to 0 or
setItemCountPerPage is not called, a
divide by 0 warning may be raised.

This could be avoided by either setting
some default item count per page, or
throwing an exception if the
_calculatePageCount method is called
without first setting a valid
itemCountPerPage.

Throwing an exception should be
prefered, as userland code could set the
value to 0 if there is incorrect filtering.
Relying on a php warning should not be
correct however.

There is some code duplication going on
in Paginator's DbSelect adapter. It needs
to be cleaned up. Maybe add some
documentation in the process.




                                              569 of 868
Zend_Paginator_Adapter_DbSelect
seems to create a wrong query for
getting the count when the query has a
'HAVING' in it.

Simplified example:

$select = $db->select()
->from('user', 'user_id AS foo')
->having('foo > ?', 4);

// query is: SELECT `user`.`user_id` AS
`foo` FROM `user` HAVING (foo > 4)

$paginator = new Zend_Paginator(new
Zend_Paginator_Adapter_DbSelect($sel
ect));

Created query is:
SELECT COUNT(*) AS
`zend_paginator_row_count` FROM
`user` HAVING (foo > 4)

which is obviously not working.

Haven't tested it yet in 1.8.0.

BR
anselm
setRowCount() is only mentioned briefly,
it would be nice to have an example of
how you use your own select object.




                                           570 of 868
Hello,

OS: centos x64
PHP: PHP 5.1.6 (cli) (built: Apr 7 2009
08:00:18) x64
DB: psql (PostgreSQL) 8.3.7 x64

Zend_Paginator_Adapter_DbSelect
make incorrect SQL query when use join
keyword.
It make few columns as argument that
passed to DISTINCT function than
DISTINCT function make multi column
result that COUNT function didn't
understand.

The error is:
{quote}
"Fatal error: Uncaught exception
'Zend_Db_Statement_Exception' with
message 'SQLSTATE[42883]: Undefined
function: 7 ERROR: function count(bigint,
character varying, character varying)
does not exist at character 8 HINT: No
function matches the given name and
argument types. You might need to add
explicit type casts." when use
Zend_Paginator with joinLeft functions.
{quote}




                                            571 of 868
The DbSelect adapter fails under Oracle,
because Oracle does not support
statements like:
{code}SELECT COUNT(DISTINCT
column1, column2, column3) FROM
table_name{code}

Instead, in Oracle, the statement should
be:
{code}SELECT COUNT(DISTINCT
column1||column2||column3) FROM
table_name{code}

I made a quick fix by changing
Zend/Paginator/Adapter/DbSelect.php,
but then this would only support
Oracle(which is no problem in my case)
The fix is not perfect, there is a chance
of failure, but I suppose the '###' string
could be changed to something unique.
{code}
187,188d186
< //ORACLE COUNT(DISTINCT
col1||col2..) fix
< $groupPart = str_replace(",", "||'###'||",
$groupPart);
{code}

Sample code:
The construction of the COUNT query in
Paginator's DbSelect adapter should be
moved into its own method, called
getCountSelect(). This makes the code
more readable and the generated
queries easier to test.




                                               572 of 868
Lets say $select1 and $select2 are
Zend_Db_Selects that give identical
fields.

Then we do $select1 UNION $select2:
$select = $db->select()-
>union(array($select1, $select2));

If we do:
print_r($this->_db->fetchAll($select));

It will return arrays of the expected union
of $select1 and $select2

But when we try to make our paginator:
$paginator =
Zend_Paginator::factory($select);

We get a crash:
exception 'Zend_Db_Select_Exception'
with message 'No table has been
specified for the FROM clause'

The expected result is no crash.

The workaround (inefficient) right now is
just to give the factory the whole array:
Zend_Paginator::factory($this->_db-
>fetchAll($select));




                                              573 of 868
Currently, when you don't set the partial   0%   0%
for paginationControl, it just throws an
exception. But, IMHO, you could render a
decent paginator without it being
required. Say

{code}
<ul class="paginator">
<li class="first"><a
href="#">&laquo;</a></li>
<li class="previous"><a
href="#">&lsaquo;</a></li>
<li><a href="#">1</a></li>
<li><a href="#">2</a></li>
<li class="current"><span>4</span></li>
<li><a href="#">5</a></li>
<li class="next"><a
href="#">&rsaquo;</a></li>
<li class="last"><a
href="#">&raquo;</a></li>
</ul>
{code}

This would lower the requirements for
using it.




                                                      574 of 868
// Method A
{code}
$rowCount = $db->select()->from( 'table'
, array(
Zend_Paginator_Adapter_DbSelect::RO
W_COUNT_COLUMN => 'COUNT(*)' ) );
print( $rowCount."<br />" );
$paginator->getAdapter()-
>setRowCount( $rowCount ); //
Exception thrown here.
{code}

// Method B
{code}
$rowCount = $db->select()->from( 'table'
)
->reset( Zend_Db_Select::COLUMNS )
->columns( new Zend_Db_Expr(
'COUNT(*) AS '.$db->quoteIdentifier(
Zend_Paginator_Adapter_DbSelect::RO
W_COUNT_COLUMN ) ) );
print( $rowCount."<br />" );
$paginator->getAdapter()-
>setRowCount( $rowCount ); // Works
fine.
{code}

I am using a query for pagination which
involves subqueries, unions, grouping




                                           575 of 868
As described in the summary.
Zend_Paginator Db_Select should use
FOUND_ROWS to setRowCount by
default when using Mysqli adapter.
Now it requires hacking the columns and
creating a separate select to get it, and in
big databases (10M records) this is a
huge problem.
http://dev.mysql.com/doc/refman/5.0/en/i
nformation-
functions.html#function_found-rows


I have some construction like this:

$_paginator =
Zend_Paginator::factory($query);
$_paginator-
>setCurrentPageNumber($page);
$items = $_paginator-
>setItemCountPerPage($perPage);

foreach ($items as &$item) {
$item['some_key'] = 'some value'
}

Until revision 11970 - this works fine
After revision 11970 - throw an
exception:: "An iterator cannot be used
with foreach by reference"




                                               576 of 868
The Elastic ScrollingStyle for
Zend_Paginator returns the following
page ranges for the following example
pages. (Assuming 100 pages and an
example page range of 5.)

// 1 :: 1,2,3,4,5
// 2 :: 1,2,3,4,5,6
// 3 :: 1,2,3,4,5,6,7
// 4 :: 1,2,3,4,5,6,7,8
// 5 :: 1,2,3,4,5,6,7,8,9
// 6 :: 2,3,4,5,6,7,8,9,10
// 50 :: 46,47,48,49,50,51,52,53,54
// 95 :: 91,92,93,94,95,96,97,98,99
// 96 :: 92,93,94,95,96,97,98,99,100
// 97 :: 92,93,94,95,96,97,98,99,100
// 98 :: 92,93,94,95,96,97,98,99,100
// 99 :: 92,93,94,95,96,97,98,99,100
// 100 :: 92,93,94,95,96,97,98,99,100

To be balanced the returned page
ranges should be:
// 1 :: 1,2,3,4,5
// 2 :: 1,2,3,4,5,6
// 3 :: 1,2,3,4,5,6,7
// 4 :: 1,2,3,4,5,6,7,8
// 5 :: 1,2,3,4,5,6,7,8,9
// 6 :: 2,3,4,5,6,7,8,9,10
// 50 :: 46,47,48,49,50,51,52,53,54




                                        577 of 868
Based on
http://framework.zend.com/issues/brows
e/ZF-6352 it seems that there is a
problem while unserializing the object.

{code:php}
$paginatorObject =
serialize($paginatorObject );
$paginatorObject =
unserialize($paginatorObject );

//broken UTF-8
foreach ($paginatorObject as $result) {
var_dump($result);
}
{code}

{code:php}
//itareate to preserve UTF-8
foreach ($paginatorObject as $result) {
}

$paginatorObject =
serialize($paginatorObject );
$paginatorObject =
unserialize($paginatorObject );

//working UTF-8
foreach ($paginatorObject as $result) {




                                          578 of 868
The method setRowCount() of class
Zend_Paginator_Adapter_DbSelect
creates an SQL query to retrieve the
number of rows of a selection.
It does so, by trying to recieve an
element of the resultset via the constant
ROW_COUNT_COLUMN.
This value is in our Zend_Framework
application returned in UPPERCASE.
This we control via de ini-file line:

resources.db.params.options.caseFoldin
g=1

However the constant is in
LOWERCASE, while this really can vary
per application.
I solved this in our case by temporarily
changing the value of the constant in
uppercase.
But my suggestion would be to not
address the result value by name, but by
retrieving the first column by number,
somewhat like $this-
>_rowcount=$result[0] in stead of
$result[self::ROW_COUNT_COLUMN]




                                            579 of 868
It could be very usefull to provide a way
for Zend_Paginator to cache its data.

When Zend_Paginator reads actual data,
it stores them into a sort of cache :
$_pageItems, but those data does not
persist throught HTTP requests as they
are just stored in an object property.
If Zend_Paginator could be given a
Zend_Cache_Core instance, it could use
it to store data in a 'real' cache, making
seeking throught the pages easier and
quicker.
Also, this would prevent the final user
from inventing such a system.


toJson() method does not working for
DbTableSelect adapter, it's returns
nothing.

LIttle patch:

{code}
public function toJson()
{
if ($this->getCurrentItems() instanceof
Zend_Db_Table_Rowset_Abstract) {
return Zend_Json::encode($this-
>getCurrentItems()->toArray());
} else {
return Zend_Json::encode($this-
>getCurrentItems());
}

}
{code}




                                             580 of 868
                   Use the
                   Zend_Db_Select::SQL_WILDCARD
                   constant instead of '*'
ZF-5233, ZF-5278   Zend_Paginator_Adapter_DbSelect does
                   not take into account aliased tables when
                   Zend_Db_Select::DISTINCT is active
                   inside count() method. On line 164 and
                   166 the table alias part of the column is
                   completely disregarded. This has severe
                   issues when joining tables with foreign
                   key relationships having the same
                   column name.

ZF-5231            Edit the code starting on line 162 of
                   Zend_Paginator_Adapter_DbSelect and
                   replace lines 162-168 with the following
                   block:

                   foreach ($columnParts as $part) {
                   if ($part[1] == '*' || $part[1] instanceof
                   Zend_Db_Expr) {
                   $columns[] = empty($part[0]) ? $part[1] :
                   $part[0].'.'.$part[1];
                   } else {
                   $columns[] = empty($part[0])
                   ? $rowCount->getAdapter()-
                   >quoteIdentifier($part[1], true)
                   : $rowCount->getAdapter()-
                   >quoteIdentifier($part[0].'.'.$part[1], true);
                   }
                   }




                                                                    581 of 868
It should be possible to provide a plugin
that processes the data retrieved from
the adapter. This can be used to create
your custom models from the paginated
data, without subclassing any Paginator
classes.

The patched getItemsByPage method
would look something like this:
{code}
public function
getItemsByPage($pageNumber)
{
$pageNumber = $this-
>normalizePageNumber($pageNumber);

if ($this->_cacheEnabled()) {
$data = self::$_cache->load($this-
>_getCacheId($pageNumber));
if ($data !== false) {
return $data;
}
}

$offset = ($pageNumber - 1) * $this-
>_itemCountPerPage;

$items = $this->_adapter-
>getItems($offset, $this-




                                            582 of 868
Not sure if this has been pointed out yet
but when using Zend_Paginator the View
functionality is not supported on a default
PHP installation unless you set the
short_open_tag=On in the php.ini file.

From the php.ini file
" Using short tags is discouraged when
developing code meant for redistribution
since short tags may not be supported
on the target server."

Sorry if this has been fixed or pointed out
already.
Armando Padilla




                                              583 of 868
I wanted to give the user the ability to
return all rows from the DB on the same
page, so in a user interface you can
select 'All' which then sends a 0 to
setItemCountPerPage()

This produces a warning of divide by 0
when it runs _calculatePageCount
internally, therefore we should probably
test to see if _itemCountPerPage is 0 or
null first, and return a 0 if it is?
Something like :

{noformat}
/**
* Calculate the page count
*
* @return integer
*/
protected function
_calculatePageCount()
{
if ( $this->_itemCountPerPage > 0 )
return (integer) ceil($this->_adapter-
>count() / $this->_itemCountPerPage);
return 0;
}
{noformat}




                                           584 of 868
This functionality will let users set
properties on future scrolling styles that
have more complex requirements.

{code}
// View code
$example = new
My_Paginator_ScrollingStyle_Example();
$example->setSomeProperty(3)
->setAnotherProperty(true);
print $this->paginationControl($this-
>paginator, $example,
'pagination_control.phtml');
{code}




                                             585 of 868
The parameter definition for
Zend_Paginator_Adapter_Interface::getIt
ems is different to the ones for
Zend_Paginator_Adapter_DbSelect and
Zend_Paginator_Adapter_DbTableSelect
.

The Interface definition is:
{code:none} /**
* Returns a collection of items for a
page.
*
* @param integer $pageNumber Page
number
* @param integer $itemCountPerPage
Number of items per page
* @return mixed
*/
public function getItems($pageNumber,
$itemCountPerPage);
}{code}
whereas the DbSelect definition is:
{code:none} /**
* Returns an array of items for a page.
*
* @param integer $offset Page offset
* @param integer $itemCountPerPage
Number of items per page
* @return array




                                          586 of 868
The comments for
Zend_Paginator_Adapter_Interface claim
that getItems-method should
take $pageNumber as its first parameter.
However, every adapter implementation
and paginator itself
use $offset as their first parameter.

Adapter_Interface method declaration
and documentation read as follows:
/**
* Returns a collection of items for a
page.
*
* @param integer $pageNumber Page
number
* @param integer $itemCountPerPage
Number of items per page
* @return mixed
*/
public function getItems($pageNumber,
$itemCountPerPage);

While they should be something along
the lines of:
/**
* Returns a collection of items for a
page.
*
What the summary says =)

Currently it returns a DbSelect adapter,
because of BC reasons. With ZF-2013
fixed, BC problems shouldn't be an issue
anymore =)




                                           587 of 868
Tested under WinXP, PHP5.2.5             0%   0%
{code}
5)
testFactoryReturnsDbSelectAdapter(Zen
d_PaginatorTest)
Zend_Db_Adapter_Exception: The sqlite
driver is not currently installed
C:\Voxtronic\3rdParty\Zend
Framework\library\Zend\Db\Adapter\Pdo\
Abstract.php:11
6
C:\Voxtronic\3rdParty\Zend
Framework\library\Zend\Db\Adapter\Pdo\
Sqlite.php:137
C:\Voxtronic\3rdParty\Zend
Framework\library\Zend\Db\Adapter\Abst
ract.php:414
C:\Voxtronic\3rdParty\Zend
Framework\library\Zend\Db\Adapter\Pdo\
Abstract.php:22
0
C:\Voxtronic\3rdParty\Zend
Framework\library\Zend\Db\Select.php:6
39
C:\Voxtronic\3rdParty\Zend
Framework\library\Zend\Paginator\Adapt
er\DbSelect.php
:112
C:\Voxtronic\3rdParty\Zend




                                                   588 of 868
ZF-4751   When using Zend_Paginator in                0%   0%
          Conjunction with a Zend_Db_Select
          Object on Oracle, an E_NOTICE is
          raised in
          Zend_Paginator_Adapter_DbSelect.

          Output:
          {noformat}
          Notice: Undefined index:
          zend_paginator_row_count in
          C:\Web\lib\Zend\Paginator\Adapter\DbSe
          lect.php on line 107
          {noformat}

          This happens when the Adapter attempts
          to retrieve the ROW_COUNT_COLUMN
          from the result array. The column name
          is defined in lower case, however
          Oracles default behavior is to return all
          column names in upper case, unless you
          explicitly wrap the column alias name in
          double quotes.

          Possible fixes for this might be:
          1. In Zend_Paginator_Adapter_DbSelect
          change value declared for
          ROW_COUNT_COLUMN to an upper
          case string.
          2. Check that the array key exists in




                                                                589 of 868
Currently the itemCountPerPage variable          0%   0%
is not available in view partials which
makes it hard to change from user
controls. Adding the following single line
in the _createPages function would fix
the problem:

$pages->itemCountPerPage = $this-
>getItemCountPerPage();




Zend_Paginator_Adapter_Interface is
missing the documentation for count() as
of Rev12071. In Rev10200 it was:
{code:none}
/**
* Returns the total number of rows in the
collection.
*
* @return integer
*/
//public function count();
{code}

{panel}
9) testToJson(Zend_PaginatorTest)
Failed asserting that two strings are
equal.
expected string
<\{"0":1,"1":2,"2":3,"3":4,"4":5,"5":6,"6":7,"
7":8,"8":9,"9":10}>
difference <
xxxxxxxxxxxxxxxxxxxxxxxxxxxxx???????
????????????????????????>
got string
<\{"__className":"ArrayIterator"}>
{panel}


                                                           590 of 868
Zend_Paginator should support toJson(),
so it can be more easily serialized for use
with XHR requests.
Class
Zend_View_Helper_Paginationcontrol
shows
{code}
public function
paginationControl(Zend_Paginator
$paginator = null, $scrollingStyle = null,
$partial = null, $params = null)
{
if ($paginator === null) {
if (isset($this->view->paginator) and $this-
>view->paginator !== null) {
$paginator = $this->view->paginator;
//....
{code}

validation of $paginator is not deep
enought, I suggest :
{code}
if (isset($this->view->paginator) and $this-
>view->paginator !== null and $this-
>view->paginator instanceof
Zend_Paginator) {
{code}
Zend_Paginator::setItemCountPerPage()
should take care about a value of zero as
a division is calculated just after thus
showing a PHP warning.




                                               591 of 868
There were 6 errors:

1)
testGroupByQueryReturnsOneRow(Zend
_Paginator_Adapter_DbSelect_OracleTe
st)
Zend_Db_Statement_Oracle_Exception:
936 ORA-00936: Expression absente
SELECT z2.*
FROM (
SELECT ROWNUM AS
zend_db_rownum, z1.*
FROM (
SELECT COUNT(DISTINCT *number)
AS "zend_paginator_row_count" FROM
"test"
) z1
) z2
WHERE z2.zend_db_rownum
BETWEEN 1 AND 1000
D:\web\ZendFramework\standard\trunk\li
brary\Zend\Db\Statement\Oracle.php:24
4
D:\web\ZendFramework\standard\trunk\li
brary\Zend\Db\Statement.php:283
D:\web\ZendFramework\standard\trunk\li
brary\Zend\Db\Adapter\Abstract.php:430
D:\web\ZendFramework\standard\trunk\li
brary\Zend\Db\Select.php:639
Currently, to fetch the total number of
items you use the method
$paginator->getAdapter()->count();

Having a method like $pagination-
>countAllItems() is more convenient.
Page cache should be accessible so it
can be inspected and cleared to save
memory.


                                          592 of 868
ZF-3809                               The Zend_Db_Table-adapter for the
                                      paginator component isn't mentioned in
                                      the reference guide.

                                      I suppose it should ;)
ZF-4094, ZF-4052, ZF-4177, ZF-4640,   Catch-all issue for documentation issues.
ZF-4430
                                      Currently, an instance of Zend_Paginator
                                      cannot be passed in to
                                      Zend_View_Helper_PartialLoop.

                                      From within a view script:
                                      <?php
                                      // $this->paginator is a Zend_Paginator
                                      echo $this->partialLoop('item.phtml',
                                      $this->paginator);
                                      ?>

                                      The code above throws an exception
                                      "PartialLoop helper requires iterable
                                      data".

                                      If Zend_Paginator_Adapter_Interface
                                      implemented Traversable, it would be
                                      possible to use the items in the paginator
                                      with PartialLoop. The current workaround
                                      is to use a foreach loop and
                                      Zend_View_Helper_Partial:

                                      <?php
                                      foreach ($this->paginator as $item) {
                                      echo $this->partial('item.phtml', $item);
                                      }
                                      ?>




                                                                                   593 of 868
ZF-3809   See
          http://www.ajaxray.com/blog/2008/08/24/j
          oin-problems-with-zend_paginator-and-
          zend_db_select-objects/ for details. This
          might already be fixed.

ZF-3809   Getting this regression in v1.6.0RC3 in
          Zend_Paginator with the DbSelect
          adapter. Works fine with previous
          1.6.0RC versions.

          Fatal error: Uncaught exception
          'Zend_Paginator_Exception' with
          message 'Row count column not found'
          in /var/www/ZendFramework-
          1.6.0RC3/library/Zend/Paginator/Adapter
          /DbSelect.php:102 Stack trace: #0
          /var/www/ZendFramework-
          1.6.0RC3/library/Zend/Paginator/Adapter
          /DbSelect.php(175):
          Zend_Paginator_Adapter_DbSelect-
          >setRowCount(Object(Zend_Db_Select))
          #1 /var/www/ZendFramework-
          1.6.0RC3/library/Zend/Paginator.php(702
          ): Zend_Paginator_Adapter_DbSelect-
          >count() #2 /var/www/ZendFramework-
          1.6.0RC3/library/Zend/Paginator.php(476
          ): Zend_Paginator-
          >_calculatePageCount() #3
          /var/www/html/working/stones/index.php(
          73): Zend_Paginator-
          >setItemCountPerPage(20) #4 {main}
          thrown in /var/www/ZendFramework-
          1.6.0RC3/library/Zend/Paginator/Adapter
          /DbSelect.php on line 102




                                                      594 of 868
ZF-3809   I have some code built with early version
          of Paginator when it was still in 1.6RC
          It stop working after recent upgrade, it
          can't handle a select query with a
          DISTINCT clause

          Zend_Db_Statement_Mysqli_Exception'
          with message 'Mysqli prepare error: You
          have an error in your SQL syntax; check
          the manual that corresponds to your
          MySQL server version for the right
          syntax to use near '*) AS
          zend_paginator_row_count FROM `foo`
          AS `a` WHERE (active = 1)' at line 1' in
          Zend/Db/Statement/Mysqli.php:84

          Stack trace:
          #0
          /home/sites/ZendLibrary/Zend/Db/Statem
          ent.php(109):
          Zend_Db_Statement_Mysqli-
          >_prepare("SELECT COUNT(DISTINCT
          *) AS zend_paginator_row_count FROM
          `foo` AS `a` WHERE (active = 1)")
          #1
          /home/sites/ZendLibrary/Zend/Db/Adapte
          r/Mysqli.php(343): Zend_Db_Statement-
          >__construct(Array(1), "SELECT
          COUNT(DISTINCT *) AS
          Counting the total items for the select
          query returns null when select has limit
          and offset parts
          "Row count column not found" exception
          throwes




                                                      595 of 868
Add to paginator possibility to get item
count per page


{code}
$pages->itemCountPerPage = $this-
>getItemCountPerPage();
{code}
Zend_Paginator will break if you set the
current page number before setting the
item count per page. It seems that
setting the page number executes the
select query to retrieve the items.

<?php

$page = 1;
$itemsPerPage = 5;

// Not working
$paginator =
Zend_Paginator::factory($select);
$paginator-
>setCurrentPageNumber($page);
$paginator-
>setItemCountPerPage($itemsPerPage);
$items = $paginator->getItems(); //
Incorrectly returns 10 items (the default
count per page)

// This works
$paginator =
Zend_Paginator::factory($select);
$paginator-
>setItemCountPerPage($itemsPerPage);
$paginator-
>setCurrentPageNumber($page); // Must


                                            596 of 868
On the following page on the [Usage of
Zend_Paginator|http://framework.zend.co
m/manual/en/zend.paginator.usage.html]
, the class name for
*Zend_Paginator_Adapter_array* has a
lowercase *a* for array instead of an
uppercase *A* as per the ZF Coding
Standards.

Incorrect:
{code}$paginator = new
Zend_Paginator(new
Zend_Paginator_Adapter_array($array));
{code}

Correct:
{code}$paginator = new
Zend_Paginator(new
Zend_Paginator_Adapter_Array($array));
{code}

I know it's a pretty trivial issue, but just
thought it would be good for it to be
consistent with the ZF Coding Standards.




                                               597 of 868
I have two issues in the
Zend_Paginator_Adapter_DbSelect class
:

1- The class checks if
(!isset($result[self::ROW_COUNT_COL
UMN])) then throw excpetion, why? some
databases like MySQL when inner joining
empty tables returns empty record set
which makes the adapter fails. It should
not throw exception just set the row
count to zero is fair enough.

Example: SELECT COUNT(*) FROM
ANY_EMPTY_TABLE GROUP BY
TABLE_PRIMARY_KEY; // this will return
empty record set

2- The class fetch the count by reseting
Zend_Db_Select::COLUMNS,
Zend_Db_Select::ORDER and
Zend_Db_Select::LIMIT_OFFSET. Also
should clear the
Zend_Db_Select::GROUP, Because
some databases or all! return a count of
each group as a recordset. The count
function mainly effected by the GROUP
BY modifier.

Should be more dynamic in nature to
allow for custom adpaters as well as
flags to specify the adapter to be
returned.




                                           598 of 868
inconsistent variable names in example

You use pageNumber and page in the
example. Because of this the example
won't work!

in 34.2.1.

$paginator-
>setCurrentPageNumber($this-
>_getParam('pageNumber'));

34.2.2.1.

<!--
See
http://developer.yahoo.com/ypatterns/pat
tern.php?pattern=searchpagination
-->

<?php if ($this->pageCount): ?>
<div class="paginationControl">
<!-- Previous page link -->
<?php if (isset($this->previous)): ?>
<a href="<?= $this->url(array('page' =>
$this->previous)); ?>">&lt; Previous</a> |
<?php else: ?>
<span class="disabled">&lt;
Previous</span> |




                                             599 of 868
ZF-3734   It is currently not possible to retrieve a
          Zend_Db_Table_Rowset from
          Zend_Paginator. This is due to the fact
          that it's not possible to get the table
          instance from a Zend_Db_Table_Select
          query.
          A workaround for this problem could be
          an additional setTable() method in the
          DbSelect adapter. If a table is provided
          using this method, the DbSelect adapter
          will return a Rowset.




                                                       600 of 868
I think that there is something wrong with
the Zend/Paginator.php file thats
included in ZF 1.6.0.
In 1.6.0-RC1 everything works fine, than
after updating to RC2 same code does
not works like it worked in RC1. After
updating to 1.6.0 the error is still there.

The following code works perfect under
RC1:

$select = $db->select()
->from('foo')
->where("bar LIKE ?", "%baz%");

$paginator = new Zend_Paginator(new
Zend_Paginator_Adapter_DbSelect($sel
ect));
$paginator->setItemCountPerPage(5);
$paginator-
>setCurrentPageNumber($page);

Now under 1.6.0 (and RC2) the code
does not work anymore. Every page
displays always 8 results (the total
number of entries found bei the select
query). Under RC1 the 5 results set with
setItemCountPerPage are successfully
displayed, this version works.




                                              601 of 868
          Paginating Zend_Search_Lucene results
          is something that's in fact already
          supported through the Iterator (or
          perhaps even the Array) adapter.
          However, it might be worth investigating
          if a specialized Lucene adapter would
          provide some benefit when paginating
          search results. For example, result
          caching would be a welcome feature.
          Alexander's email about the workings of
          ZSL and the Zym_Search_Lucene
          implementation (which supports caching)
          could be used as reference.

ZF-3809   The Zend_Paginator documentation
          should describe how to pass parameters
          to the PaginationControl partial via the
          view helper. It is currently not apparent
          that you can easily pass paramters to the
          partial.

          A simple method signature such as :

          paginationControl(Zend_Paginator
          $paginator, $paginationType,
          $paginationPartialScript, Array
          $partialParameters = array);

          Would be sufficient.




                                                      602 of 868
I have a view in my administration which
shows me my news articles, there
two lists one which shows the last ten
active news another one which shows
the last 10 inactive articles.

If a publish two articles, the first
paginator shows the two articles, but
the second paginator also shows me that
2 articles were found but lists
none, this is not true there are two active
articles but no inactive
article, i don't understand why the scond
paginator shows me that two
articles were found..?

can somebody help me? ;)

heres my source:

indexAction:

// active articles listing
$db = Zend_Registry::get('db');
$db-
>setFetchMode(Zend_Db::FETCH_ASS
OC);

$articlesTable = new Articles();




                                              603 of 868
Currently count method does not work
with multiply fields in GROUP BY section

{noformat}
/**
* The DISTINCT and GROUP BY
queries only work when selecting one
column.
* The question is whether any RDBMS
supports DISTINCT for multiple columns,
without workarounds.
*/
{noformat}

I want to suggest another implementation
of count method.

{noformat}
public function count()
{
if ($this->_rowCount === null) {
$rowCount = clone $this->_select;

$rowCount-
>reset(Zend_Db_Select::COLUMNS)
->reset(Zend_Db_Select::FROM)
->reset(Zend_Db_Select::WHERE)
->reset(Zend_Db_Select::HAVING)
->reset(Zend_Db_Select::ORDER)




                                           604 of 868
Casting to string does not work properly
in Zend_Paginator_Adapter_DbSelect on
line 96

if (false === strpos((string)
$columns[0][1],
self::ROW_COUNT_COLUMN)) {

(string) $columns[0][1] return only
"Object id #..." and not execute
__toString method

to get string value of expression object
__toString method should be called
directly

my php version is:
PHP 5.1.4 (cli) (built: Aug 12 2008
11:58:38)

this link may be helpful
http://bugs.php.net/bug.php?id=33270




                                           605 of 868
It would be a good idea for
Zend_Paginator to filter or validate (as
appropriate) that the page number being
set is actually a number. The docs state
it is good practice to make sure it's a
number in the route but this may not
always be possible, or the feature may
be used in another way. Therefore
Zend_Paginator should make sure the
data given to it is of the correct type.

The same should also apply to
setItemCountPerPage() and any other
functions which require user input.




                                           606 of 868
Here is the current method:
{code}
public function
getItemsByPage($pageNumber)
{
$pageNumber = $this-
>normalizePageNumber($pageNumber);

if (isset($this-
>_pageItems[$pageNumber])) {
return $this-
>_pageItems[$pageNumber];
}

$offset = ($pageNumber - 1) * $this-
>_itemCountPerPage;

$items = $this->_adapter-
>getItems($offset, $this-
>_itemCountPerPage);

if (!$items instanceof Iterator) {
$items = new ArrayIterator($items);
}

$this->_pageItems[$pageNumber] =
$items;

return $items;




                                       607 of 868
From Simon Corless:

{quote}
It would be good if the view helper tried
to detect the paginator instance in the
view itself. The docs suggest calling it
$view->paginator would it not make
sense for the helper to use this by default
unless another instance is supplied in the
helper call?
{quote}

Not sure this is possible, but worth
looking into.




                                              608 of 868
Hi,

I have created a datagrid component,
and i would like to use the same
pagination control for the pager of all my
datagrid component in my pages.
In the same html page, i can use multiple
datagrid component, and i want to
customize with other parameters.

Really I want this in the pagination
control (You can observe the new
variable "$this->pageName"):

<!-- Numbered page links -->
<?php foreach ($this->pagesInRange as
$page): ?>
<?php if ($page != $this->current): ?>
<a href="<?php echo $this-
>url(array($this->pageName => $page));
?>"><?php echo $page; ?></a> |
<?php else: ?>
<?php echo $page; ?> |
<?php endif; ?>
<?php endforeach; ?>


In place of:
<!-- Numbered page links -->




                                             609 of 868
I called {code}$paginator-
>setPageRange(0);{code} because I
supposed, it can list all pages. It was just
experiment :)

But it shows errors:
{code}
Warning: min() [function.min]: Array must
contain at least one element in
Zend\Paginator.php on line 735
Warning: max() [function.max]: Array
must contain at least one element in
Zend\Paginator.php on line 736
{code}




                                               610 of 868
Currently the Array adapter doesn't
preserve the keys of the input. E.g:
{code}
array(
'foo' => 'foo',
'bar' => 'bar,
'baz' => 'baz'
}

// or

array(
11 => 'foo',
12 => 'bar',
13 => 'baz'
)

// would become

array(
0 => 'foo',
1 => 'bar',
2 => 'baz'
)
{code}
I'm curious to see if there's a use case
where you might want to preserve the
keys before I start adding support for
preserving the keys to Paginator.




                                           611 of 868
From SiCo007 <simon@sico.co.uk>:

{quote}
I would like to suggest that in the
documentation the code for the
suggested paginaton techniques is
changed slightly to make the id attribute
in <div id="paginationControl"> a class
attribute instead... <div
class="paginationControl">.

Nothing major but people will be copying
the code and it's best practice to have
one id of said name per page, it's quite
common however to display multiple
paginators per page.
{quote}


There seems to be a lot of
misconceptions about this.

The default scrolling style set via
Zend_Paginator::setDefaultScrollingStyle
() is not honored.
For instance, no one realizes you can
supply your own COUNT query.




                                            612 of 868
It should provide a static method
setParams.

'm using Paginator like this:
$select = $this->db->select()
->from(array('mh' => 'merlin_hotel'))
->join(array('mt' => 'merlin_trip') ,'mt.id =
mh.trip_id', array() );
$select->where('mh.region = ?',$region);

$paginator =
Zend_Paginator::factory($select);
$paginator-
>setCurrentPageNumber((int)$this-
>getRequest()->getParam('page'));
$this->view->paginator = $paginator;
$this->render("results")

but the links that are being rendered later
in the pagination_control.phtml do not
contain the query parameters that were
set before.
To achieve that, I have to pass the
params from controller to the viewscript
and then from the view script to
pagination view script and again then
merge with 'page' param which is
pointless and not making it easier at all.

I couldn't find a way to pass a new
variable to the paginationControl()
template. If there's a way, please add it
to the documentation.

I.e., how can I pass a view variable to the
'paginate.phtml' template rendered by
this call?
$this->paginationControl($this-
>paginator, 'Sliding', 'prevnext.phtml')

                                                613 of 868
Their should be Sorting on Database
columns along with the pagination. Their
should be a parameters in
zend_paginator class for sortings
columns arrays, want sort or not
(boolean) etc.

It will be great helpful to everyone
because everyone want grid with
pagination along with sorting of data.




                                           614 of 868
Sorry for my bad english..

I have tried to use
Zend_Paginator_Adapter_Array,
because I don't use Zend_Db,

First I have tried this :

$paginator =
Zend_Paginator::factory(range(1,
ceil($nbPost / $postPerPage)))

if $nbPost = 195 and $postPerPage = 15
$paginator iterator will go from 1 to 10

but
$paginator->count() will return 2



then I have tried this:

$paginator =
Zend_Paginator::factory(range(1,
$nbPost ));
$paginator-
>setItemCountPerPage($postPerPage);

Great, it works..... but




                                           615 of 868
As reported by Andy Collington:

Line 84 of
Zend_Paginator_Adapter_DbSelect
needs to have the fetch mode set, such
as:

$result = $rowCount-
>query(Zend_Db::FETCH_ASSOC)-
>fetch();

Because on line 86 it assumes the
results are retrieved in an array format
but it's possible that someone has set the
default fetch mode to be a class (as I
had).
File : Zend/Paginator.php
Line : 344

There is an equal symbol missing :

if ($pageNumber == null) {
$pageNumber = $this-
>getCurrentPageNumber();
}

Instead of :

if ($pageNumber === null) {
$pageNumber = $this-
>getCurrentPageNumber();
}




                                             616 of 868
[Item
pagination|http://framework.zend.com/m
anual/en/zend.paginator.usage.html#zen
d.paginator.usage.rendering.example-
controls] control example:

'First page' and 'Last page' links are
active all the time. I suppose, that if you
are on the page number 1, you can't go
to the 'First page' (same with the last
page).

Best practices don't recommend link
which doesn't visually change anything.

It should be done [this
way|http://pastebin.com/m6355e72f].

Patch:
{code}
Index:
documentation/manual/en/module_specs
/Zend_Paginator-Usage.xml
===============================
===============================
=====
---
documentation/manual/en/module_specs
/Zend_Paginator-Usage.xml (revision




                                              617 of 868
Code:

{noformat}
$select = $table->select()->from($table)-
>order('mycolumn asc');
$paginator =
Zend_Paginator::factory($select);
{noformat}

Profiler shows the following query being
used:

{noformat}
SELECT COUNT(*) AS
zend_paginator_row_count FROM
"table" ORDER BY "mycolumn" asc
{noformat}
... which results in a grouping error, as
expected.

"Zend_Pagiinator_Adapter_DbSelect"
function count() needs to also reset the
ORDER clause because COLUMNS
resets, therefor if you rename a column
with AS, the ORDER BY clause will not
see the column created with AS in the
select statement.

I solved this problem by adding:
reset(Zend_Db_Select::ORDER) after
line 134.




                                            618 of 868
This does not work in postgresql
{code}
SELECT COUNT(*) AS
zend_paginator_row_count FROM users
order by name asc
{code}

it throws error
ERROR: column "users.name" must
appear in the GROUP BY clause or be
used in an aggregate function

You shoud shoul also reset order by
{code}
$rowCount = clone $this->_select;
$rowCount-
>reset(Zend_Db_Select::COLUMNS)
->reset(Zend_Db_Select::ORDER)
>columns($expression);
{code}




                                      619 of 868
If you call itemCountPerPage after
setCurrentPageNumber you'll get wrong
results.
E.g.:
{code}
$paginator =
Zend_Paginator::factory(array('item1',
'item2'));
$paginator->setCurrentPageNumber(2)
->setItemCountPerPage(1);
{code}
Because the items per page is set to 10,
the normalizePageNumber method which
is called by setCurrentPageNumber will
normalize the page number to 1.
However, after setting the itemcount per
page to 1, there are supposed to be two
pages. However, the
setCurrenPageNumber method already
set the page number to 1.




                                           620 of 868
Σ Remaining Estimate   Σ Original Estimate   Labels   Tags




                                                             621 of 868
622 of 868
623 of 868
624 of 868
Zend_Paginator




                 625 of 868
626 of 868
627 of 868
628 of 868
0   0




        629 of 868
Cache, DbSelect, Zend_Pageinator




                                   630 of 868
Zend_Paginator




                 631 of 868
state:need-feedback, state:patch-ready-
for-review, zf-caretaker-adamlundrigan,
zf-crteam-review




                                          632 of 868
633 of 868
paginator   paginator




                        634 of 868
635 of 868
636 of 868
zf-caretaker-adamlundrigan




                             637 of 868
db, paginator




                638 of 868
                 dbadapter, paginator




Zend_Paginator   Zend_Paginator




                                        639 of 868
640 of 868
Zend_Paginator_Adapter_DbSelect




                                  641 of 868
642 of 868
643 of 868
Zend_Paginator   Cache, Paginator




                                    644 of 868
db2, zend_paginator




paginator, zend_paginator,
zend_view_helper




                             645 of 868
getItemsByPage




                 646 of 868
0   0




        647 of 868
648 of 868
0   0   DB_Select, Paginator, UNION




                                      649 of 868
650 of 868
651 of 868
652 of 868
653 of 868
654 of 868
0




    655 of 868
656 of 868
657 of 868
658 of 868
659 of 868
660 of 868
661 of 868
662 of 868
663 of 868
664 of 868
665 of 868
666 of 868
667 of 868
Zend_Pageinator




                  668 of 868
Zend_Cache, Zend_Paginator




                             669 of 868
670 of 868
671 of 868
672 of 868
673 of 868
674 of 868
675 of 868
676 of 868
677 of 868
678 of 868
Db_Statement, Paginator, SQL,
ambiguous, field




                                679 of 868
count, dbselect, paginator




                             680 of 868
Elastic, ScrollingStyle, Zend_Paginator




                                          681 of 868
682 of 868
683 of 868
684 of 868
0   0




        685 of 868
all, itemCountPerPage, page, paginator




                                         686 of 868
division, warning, zero




                          687 of 868
0   0   Zend_Paginator, having,
        number_of_results, where




                                   688 of 868
0   0




        689 of 868
0   0




        690 of 868
0   0




0   0   smarty, zend_paginator




                                 691 of 868
zend_cache, zend_db_select,
zend_paginator




                              692 of 868
Zend_Paginator, divide_by_0




                              693 of 868
count, paginator, select




docs, setRowCount




                           694 of 868
distinct, group, join, joinleft,
zend_paginator




                                   695 of 868
696 of 868
factory, select, union, zend_db_select




                                         697 of 868
3600   3600   helper, paginator, view




                                        698 of 868
699 of 868
700 of 868
701 of 868
paginator, unserialize, utf-8




                                702 of 868
703 of 868
json, pagnator, zend_db_table




                                704 of 868
705 of 868
706 of 868
707 of 868
708 of 868
709 of 868
710 of 868
711 of 868
1800   1800




              712 of 868
900   900




            713 of 868
900   900




            714 of 868
715 of 868
716 of 868
717 of 868
718 of 868
719 of 868
720 of 868
721 of 868
722 of 868
723 of 868
724 of 868
725 of 868
726 of 868
727 of 868
728 of 868
729 of 868
730 of 868
731 of 868
732 of 868
733 of 868
734 of 868
735 of 868
736 of 868
737 of 868
738 of 868
739 of 868
740 of 868
741 of 868
742 of 868
743 of 868
744 of 868
Fix Version Priority




                       745 of 868
746 of 868
747 of 868
748 of 868
749 of 868
750 of 868
751 of 868
752 of 868
753 of 868
754 of 868
755 of 868
756 of 868
757 of 868
758 of 868
759 of 868
760 of 868
761 of 868
762 of 868
763 of 868
764 of 868
765 of 868
766 of 868
767 of 868
768 of 868
769 of 868
770 of 868
771 of 868
772 of 868
773 of 868
774 of 868
775 of 868
776 of 868
777 of 868
778 of 868
779 of 868
780 of 868
781 of 868
782 of 868
783 of 868
784 of 868
785 of 868
786 of 868
787 of 868
788 of 868
789 of 868
790 of 868
791 of 868
792 of 868
793 of 868
794 of 868
795 of 868
796 of 868
797 of 868
798 of 868
799 of 868
800 of 868
801 of 868
802 of 868
803 of 868
804 of 868
805 of 868
806 of 868
807 of 868
808 of 868
809 of 868
810 of 868
811 of 868
812 of 868
813 of 868
814 of 868
815 of 868
816 of 868
817 of 868
818 of 868
819 of 868
820 of 868
821 of 868
Nice to Have




               822 of 868
823 of 868
824 of 868
825 of 868
826 of 868
827 of 868
828 of 868
829 of 868
830 of 868
831 of 868
832 of 868
833 of 868
834 of 868
835 of 868
Nice to Have




               836 of 868
Should Have




              837 of 868
Nice to Have




Must Have




               838 of 868
839 of 868
840 of 868
841 of 868
842 of 868
843 of 868
844 of 868
845 of 868
846 of 868
847 of 868
Should Have




              848 of 868
849 of 868
850 of 868
851 of 868
852 of 868
853 of 868
854 of 868
855 of 868
856 of 868
857 of 868
858 of 868
859 of 868
860 of 868
861 of 868
862 of 868
863 of 868
864 of 868
865 of 868
866 of 868
867 of 868
Must Have




            868 of 868

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:2
posted:3/5/2013
language:Unknown
pages:868