Where is my Drupal View pager?

Question

I have a Drupal 6 site where I've created a view that shows a list of nodes. Nothing complicated -- except that when I choose "use pager" --> "yes" (and choose the "full pager" option), the pager doesn't show up on the page. The first page of nodes shows up, but there's no way to get to other pages.

Through googling, I saw that some people had an issue with the "Pager Element" item, so I changed that from 0 to 1 -- no luck.

This shouldn't be very complicated, but I've been at it for a while!

Help!?

ETA: I've tracked it down to the following lines in /modules/views/theme/theme.inc:

$pager_theme = views_theme_functions($pager_type, $view, $view->display_handler->display);
$vars['pager']  =  theme($pager_theme, $exposed_input, $view->pager['items_per_page'], $view->pager['element']);

The first line returns an array; the second line returns nothing.

I suspect now that this is a theming problem with the custom theme I'm using that may not have fully been correctly updated for Drupal 6 -- like, maybe I'm missing a pager template somehow? -- however, I'm quite new to Drupal and don't really understand how to further track down and fix the issue. Any advice would be much appreciated!

ETA yet again:

The pager also doesn't show up when using Garland, so it's not a theme issue after all. ALSO: I have a copy of this site set up on a development server as well, and that copy has working pagination! I've checked what I thought might be different -- files in the theme, what modules are enabled -- and it seems like pretty much everything is the same. The one thing that I know is different, however, is that the production server has a lower version of MySQL (lower than recommended for Drupal 6 -- we're waiting on the hosting company being able to change this later). Would it make sense that the old version of MySQL is unable to do pagination correctly in Drupal 6? If so, does anyone know a workaround I can do until we are able to update MySQL?

Answer 1

I had this problem and fixed it this way:

edit your view: click on "Use pager" and set "Pager element:" from 0 to 1. Save the view.

Answer 2

It was MySQL all along! Moved to a new server with the right version of MySQL, and everything is peachy keen again.