I attached an image, which I believe you can see.

Template is as follows:

{exp:channel:entries channel="resources" status="open" limit="5" paginate="bottom" dynamic="no"}
 <a href="http://{page_ur}">{title}</a>

    {paginate}
        Page {current_page} of {total_pages} pages {pagination_links}
    {/paginate}
{/exp:channel:entries}

In this case, there are ~1850 entries in English, 2 in French, and 0 in German. In all three languages, the “Last Page” link goes to …/P370.

In each case, the “last” link goes to …/P370/

Excellent, appreciate you taking a look.

We initially had persistence turned on, but, all three settings for it have been set to “No” for quite some time now (several months); not sure if that’s pertinent or not.

The pagination function in models/publisher_entry.php starts at line 1408 in the latest version of Publisher that’s on Devot:ee, if that’s noteworthy; in any event, it looks like it’s doing what it supposed to do, I think…

Modified with a pair of var_dumps:

public function get_pagination_entries(Channel $channel)
    {
        // Get the queries and reverse the list so it does fewer loops.
        $current_queries = array_reverse(ee()->db->queries);
        $entry_ids = array();
        $limit = 100;
        $offset = 0;
        $count = 0;
        $limit_sql = '';

        foreach ($current_queries as $query)
        {
            if (
                (strpos($query, 'SELECT t.entry_id FROM '. ee()->db->dbprefix . 'channel_titles AS t') !== FALSE) ||
                (strpos($query, 'SELECT DISTINCT(t.entry_id) FROM '. ee()->db->dbprefix .'channel_titles AS t') !== FALSE)
            ){

                var_dump($query);

                // Modify the query and use the offset and limit to grab the current
                // subset of results for the current page.
                $sql = str_replace(
                    'WHERE',
                    'LEFT JOIN exp_publisher_titles AS pt ON pt.entry_id = t.entry_id
                        WHERE pt.publisher_lang_id = '.ee()->publisher_lib->lang_id .'
                        AND pt.publisher_status = "'.ee()->publisher_lib->status .'" AND ',
                    $query
                );

                var_dump($sql);

                // Find our new set of entry_ids with original offset and limit
                $qry = ee()->db->query($sql);

                foreach ($qry->result_array() as $row)
                {
                    $entry_ids[] = $row['entry_id'];
                }

                // Remove the offset and limit so we can grab the count
                // and update the pagination class.
                $sql = preg_replace('/LIMIT [0-9,\s]+$/', '', $sql);

                $qry = ee()->db->query($sql);
                $count = $qry->num_rows();

                // Exit the loop, found what we need.
                break;
            }
        }[/code]

English:

[code]string(523) "SELECT t.entry_id FROM exp_channel_titles AS t
    LEFT JOIN exp_channels ON t.channel_id = exp_channels.channel_id LEFT JOIN exp_members AS m ON m.member_id = t.author_id WHERE t.entry_id !='' AND t.site_id IN ('1')  AND t.entry_date <  425658339  AND (t.expirati OR t.expiration_date > 1425658339) AND t.channel_id IN (9) AND t.status = 'open' AND t.status != 'closed' ORDER BY t.sticky desc, t.entry_date desc, t.entry_id desc LIMIT 0, 5
#APP/modules/channel/mod.channel.php L:277  Channel::build_sql_query() "

string(699) "SELECT t.entry_id FROM exp_channel_titles AS t
    LEFT JOIN exp_channels ON t.channel_id = exp_channels.channel_id LEFT JOIN exp_members AS m ON m.member_id = t.author_id LEFT JOIN exp_publisher_titles AS pt ON pt.entry_id = t.entry_id
                        WHERE pt.publisher_lang_id = 1
                        AND pt.publisher_status = "open" AND  t.entry_id !='' AND t.site_id IN ('1')  AND t.entry_date <  425658339  AND (t.expirati OR t.expiration_date > 1425658339) AND t.channel_id IN (9) AND t.status = 'open' AND t.status != 'closed' ORDER BY t.sticky desc, t.entry_date desc, t.entry_id desc LIMIT 0, 5
#APP/modules/channel/mod.channel.php L:277  Channel::build_sql_query() "

French:

string(523) "SELECT t.entry_id FROM exp_channel_titles AS t
    LEFT JOIN exp_channels ON t.channel_id = exp_channels.channel_id LEFT JOIN exp_members AS m ON m.member_id = t.author_id WHERE t.entry_id !='' AND t.site_id IN ('1')  AND t.entry_date <  425658406  AND (t.expirati OR t.expiration_date > 1425658406) AND t.channel_id IN (9) AND t.status = 'open' AND t.status != 'closed' ORDER BY t.sticky desc, t.entry_date desc, t.entry_id desc LIMIT 0, 5
#APP/modules/channel/mod.channel.php L:277  Channel::build_sql_query() "

string(699) "SELECT t.entry_id FROM exp_channel_titles AS t
    LEFT JOIN exp_channels ON t.channel_id = exp_channels.channel_id LEFT JOIN exp_members AS m ON m.member_id = t.author_id LEFT JOIN exp_publisher_titles AS pt ON pt.entry_id = t.entry_id
                        WHERE pt.publisher_lang_id = 2
                        AND pt.publisher_status = "open" AND  t.entry_id !='' AND t.site_id IN ('1')  AND t.entry_date <  425658406  AND (t.expirati OR t.expiration_date > 1425658406) AND t.channel_id IN (9) AND t.status = 'open' AND t.status != 'closed' ORDER BY t.sticky desc, t.entry_date desc, t.entry_id desc LIMIT 0, 5
#APP/modules/channel/mod.channel.php L:277  Channel::build_sql_query() "

Excellent!

• More than one page of results in current language: check
• One page of results in current language: check
• Zero results in current language: fail

In this instance, there are no results in German, but, it displays the pagination as if there were as many entries as the primary language (same behavior as before the bug fix, I think), output as is follows:

“Page 1 of 0 pages 1 2 3 > Letzte »”

I imagine I can work around this with a conditional, probably, but, still worth looking at at some point, I think, maybe?

Thanks again!

Excellent! Resolved, insofar as I’m concerned, thank you!