[support] pager_query problem

[Fehér János]

Hi there,

I have a problem with the pager_query() or with the theme_pager() under v4.7.
They are a bit mysterious for me, because they don't work for me correctly.
The query is "good", if copy&paste to the MySQL console, it's working.

If I set the 20 to 500 in the

$nodes = pager_query(db_rewrite_sql($sql), 20);

all of the record (400something) cappearing, but if I set the "20",
nor I don't see the theme_pager(). Vica versa: if the rownum is 2, the
pager is there.

I've tried to force the pager put the page variable into the URL, but
it hasn't helped. My query using "only" LEFT JOINs so it shouldn't be
a problem to the db_rewrite_sql() .

What Am I do wrong?

Thanks,
-- 
Aries