Hi, I'm having a similar problem but not because of pagination I have a record in products table and site_products table with product_id of record on products table and site_id which is an integer In my index configuration I have left joined site_products table and selecting site_id on site_products as site_id.
Now when I search on product for this name, it returns some results one of which has site_product record for a particular site_id But when I search on product for the same name using 'with' site_id providing the integer for site_id it doesnt show any result How do I fix this? why is this happening? On Thursday, 31 March 2011 17:40:20 UTC+5:30, Surbhi wrote: > > Thank you James, this solved my issue. :) > > Regards, > Surbhi. > > On Wed, Mar 30, 2011 at 2:15 PM, James Healy <[email protected]<javascript:> > > wrote: > >> On 30 March 2011 19:42, Surbhi <[email protected] <javascript:>> wrote: >> > Now when I exclude marketspace_id from the search query I do not get >> > the complete results. I should be getting 26 results but getting only >> > 20 results. >> >> http://freelancing-god.github.com/ts/en/searching.html#pagination >> >> James >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Thinking Sphinx" group. >> To post to this group, send email to [email protected]<javascript:> >> . >> To unsubscribe from this group, send email to >> [email protected] <javascript:>. >> For more options, visit this group at >> http://groups.google.com/group/thinking-sphinx?hl=en. >> >> > -- You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/thinking-sphinx. For more options, visit https://groups.google.com/d/optout.
