By dwueppel on

Hopefully this isn't duplicated anywhere, but a search turned up no answers.

I've recently installed the views 5.x-1.6 module and created a new view. I've added some filtering criteria and added a sorting method. I then indicated in the page view that I was to see the page using the list view, and that I want 10 items per page and to use the pager. The problem is that I am unable to see the pager on the page. I've tried this under my own custom theme, the default themes. I've done some investigation into this and the only odd thing I can see is that the total_rows value found in the $view variable passed into the view listing is returning an empty value.

I'm getting rather frustrated at the moment trying to figure out why this isn't working. I have even created a new view that has no filters and no sorting criteria just the page view with the pager enabled and the number of items per page set to 10. This still doesn't show the pager. I have verified that more than 10 items will be returned for the view (there should be well over 100 items shown actually). So I'm at a loss as to why the pager is not being displayed.

Do I need to add a custom template to display a pager myself? Am I missing something? Do I need to add an additional module for this feature to work? Any help would be greatly appreciated.

⋅ Categories: Drupal 5.x

Comments

dwueppel’s picture

dwueppel commented

So after much digging I found that the cause of this was due to a problem with the Postgresql database implementation. The postgresql code uses a DISTINCT ON (field) field inside a sub select, which postgres doesn't like, so I 've changed the code to make this just a DISTINCT field, I've posted a bug report as well regarding this.

kscott22’s picture

kscott22 commented

I'm having a similar problem, but I don't think it's the same issue. I'm using Views 6.x-2.8, and the pagers aren't showing up for SOME users. Any ideas what could cause this? (Are there some permission settings that I'm missing?)