Fatal error: Call to undefined method SelectQuery::setCountQuery()

I get this error message only when I sort the result by one of these options:
"Closest match...", "Furthest match...", "Vocabulary..."

I am getting the same error with the same set up as you Talkless

The code is using:

    $count_query = db_select('taxonomy_index', 'ti');
    $count_query->addExpression('COUNT(ti.tid)', 'count');
    $query = db_select('taxonomy_index', 'ti');
    $query->setCountQuery($count_query);
    $query->fields('ti', array('nid'));
    $query->condition('ti.nid', $nids);
    $query->join('taxonomy_index', 'ti2', 'ti.tid = ti2.tid');
    $query->condition('ti2.nid', arg(1));
    $query->groupBy('ti.nid');
    $query->orderBy('count', $order);
    $results = $query->execute();

The error is on this line:

    $query->setCountQuery($count_query);

yet this is what is used for examples here:

http://drupal.stackexchange.com/questions/52431/how-do-i-add-a-pager-for...

So... it's unclear how to proceed.

What database are you using?

Talkless is right, SelectQuery/db_select() doesn't have a setCountQuery() method, so we have to extend it up as a PagerDefault.

Unknown column count comes from the last part of the code, count is not actually part of the query fields. Commenting it out solves the error:

    $query = db_select('taxonomy_index', 'ti');
    $count_query = $query->countQuery();
    $query = $query->extend('PagerDefault');
    $query->setCountQuery($count_query);
    $query->fields('ti', array('nid'));
    $query->condition('ti.nid', $nids);
    $query->join('taxonomy_index', 'ti2', 'ti.tid = ti2.tid');
    $query->condition('ti2.nid', arg(1));
    $query->groupBy('ti.nid');
    //$query->orderBy('count', $order);

However I'm assuming the orderBy has a specific purpose so the final result without it might no longer be correct.

Also I'm wondering if the Pager query is actually needed since no pagination is done here.

I looked at this again today and compared it to the code in the previous version. It doesn't help to use the PagerDefault or the count query, what's actually needed is the result of the SQL count() function but on a single field (ti.tid).

I found a way to make it work with $query->addExpression('count(ti.tid)', 'count'); instead of $query->setCountQuery($count_query);

This affects both affect both featured_content_sort_nodes_by_terms and featured_content_sort_nodes_by_vocab, i have one of them working for now, I'll try to add a patch when i have both working using the SelectQueries.

About the patch:
I've tested the changes for featured_content_sort_nodes_by_terms it seems to work for me. I've added lots of comments as well explaining the parts should be pretty easy to understand.

I don't have a good way to test featured_content_sort_nodes_by_vocab on the site i'm working on. I've changed the count to work like in the other call and fixed another problem i saw with fields being selected from the wrong table.

So both would need testing, but especially the second one.

Upgraded to 1.6 and got this error. The patch in #12 solved my problems.

Thank you