Well looking at github issue tracker i see that there is an issue related to my problem with the DbSelect Adapter of the Paginator so i'm following there.
https://github.com/zendframework/zf2/issues/2656 Thanks. 2012/11/20 Jean Rumeau [via Zend Framework Community] < [email protected]> > Hey Ralph thanks for replying. > > Im using MySQL > > I did try changing the alias, but the query ended up being the same just > with another alias for categories. > > I thought it my be a problem with my grouping but the query works well > without pagination. > > I think the adapter should wrap the original select object and alias the > COUNT(1) as it does in ZF1, but i wasn't sure to open an issue yet. > > Thanks. > > > > ------------------------------ > If you reply to this email, your message will be added to the discussion > below: > > http://zend-framework-community.634137.n4.nabble.com/ZF2-Paginator-DbSelect-not-counting-rows-as-expected-tp4658186p4658188.html > To unsubscribe from [ZF2] Paginator DbSelect not counting rows as > expected, click > here<http://zend-framework-community.634137.n4.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4658186&code=cnVtZWF1QGdtYWlsLmNvbXw0NjU4MTg2fC0xMzIxNTU1MzMy> > . > NAML<http://zend-framework-community.634137.n4.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml> > -- View this message in context: http://zend-framework-community.634137.n4.nabble.com/ZF2-Paginator-DbSelect-not-counting-rows-as-expected-tp4658186p4658208.html Sent from the Zend Framework mailing list archive at Nabble.com.
