DMZ 1.7.1 (DataMapper OverZealous Edition)

[eluser]OverZealous[/eluser]
@Benedikt

No, it's new to 1.7, and I didn't change the way it works with 1.7.1. The bug is because get_paged does two things:

1) It gets a count of how many items match the non-paged query.
2) It gets all of the items for the current page.

The first step is the issue, because it is trying to count the total number of items.

BUT, I just thought of a possible work-around! :cheese:

Re-write your queries like this, and it might work:

Code:

if ( $u->exists() ) {
  $posts = new Post();
  $posts->where_related($u);
  $posts->where('status <', 9);
  $posts->order_by('_created', 'DESC');
  $posts->get_paged_iterated();
}

Basically, you are tricking DMZ to not try to be so smart and short-circuit the count query.

Let me know if that works! (If so, I think I need to fix the count query!)