Probably solution for Pagination Error on Product pages

Go to the folder catalog/model/catalog and edit the file product.php and add-in the red color checking. (Backup before modify the file)

At line 37 ~ line 42
public function getTotalProductsByCategoryId($category_id = 0) {
$query = $this->db->query("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "product_to_category p2c LEFT JOIN " . DB_PREFIX . "product p ON (p2c.product_id = p.product_id) LEFT JOIN " . DB_PREFIX . "stock_status ss ON (p.stock_status_id = ss.stock_status_id) WHERE p.status = '1' AND p.date_available <= NOW() AND p2c.category_id = '" . (int)$category_id . "' AND ss.language_id = '" . (int)$this->language->getId() . "'");

return $query->row['total'];
}

Or you can cut and paste the entire function with this code too.

This fixed my issue!

Worked like a charm, no pagination issues anymore.
Many thanks

Thanks for this! It fixed my issue too.