Skip to content
Browse files

Bugfix in paging to past journals

  • Loading branch information...
1 parent 2bcd196 commit addfb8dc4093f0276e0ccffb776c1832510189e1 @jamiemccarthy jamiemccarthy committed Nov 3, 2005
Showing with 3 additions and 2 deletions.
  1. +3 −2 plugins/Journal/Journal.pm
View
5 plugins/Journal/Journal.pm
@@ -70,7 +70,8 @@ sub getsByUids {
my $t_o = $options->{titles_only};
my $uids_list = join(",", @$uids);
my $order = "ORDER BY journals.date DESC";
- $order .= " LIMIT $start, $limit" if $limit;
+ my $order_limit = $order;
+ $order_limit .= " LIMIT $start, $limit" if $limit;
# The list may be quite large, potentially hundreds or even
# thousands of users, forming a significant portion of all the
@@ -86,7 +87,7 @@ sub getsByUids {
'id, uid',
'journals',
"uid IN ($uids_list)",
- $order);
+ $order_limit);
return unless $journals_hr && %$journals_hr;
# Second, pull nickname from users for the uids identified.

0 comments on commit addfb8d

Please sign in to comment.
Something went wrong with that request. Please try again.