Upgrade upload suspended until problem with the pagination code in modules/pages/manufacturers_all/header_php.php is resolved. It seems that the 'splitPageResults' code does not play nicely with 'select distinct' and/or 'order by'.
Code:
if (!MANUFACTURERS_ALL_EMPTY_SHOW) { // only display manufacturers with products
$manufacturers_all_sql = "select distinct m.manufacturers_id, m.manufacturers_name, m.manufacturers_image, m.date_added, m.manufacturers_sort_order, mi.manufacturers_url, mi.manufacturers_about
from (" . TABLE_MANUFACTURERS . " m
left join " . TABLE_MANUFACTURERS_INFO . " mi on m.manufacturers_id = mi.manufacturers_id
left join " . TABLE_PRODUCTS . " p on m.manufacturers_id = p.manufacturers_id)
where m.manufacturers_id = mi.manufacturers_id
and m.manufacturers_id = p.manufacturers_id
and m.manufacturers_status = 1
and (p.products_status = 1
and p.products_quantity > 0) " .
$order_by;
} else { // display all manufacturers
$manufacturers_all_sql = "select m.manufacturers_id, m.manufacturers_name, m.manufacturers_image, m.manufacturers_sort_order, mi.manufacturers_url, mi.manufacturers_about
from (" . TABLE_MANUFACTURERS . " m
left join " . TABLE_MANUFACTURERS_INFO . " mi on m.manufacturers_id = mi.manufacturers_id)
where m.manufacturers_id = mi.manufacturers_id
and m.manufacturers_status = 1 " .
$order_by;
}
// bof Pagination
/*
$manufacturers_all_split = new splitPageResults($manufacturers_all_sql, MANUFACTURERS_ALL_MAX_DISPLAY, 'm.manufacturers_id', 'page');
if ($manufacturers_all_split->number_of_rows > 0) {
$manufacturers_all = $db->Execute($manufacturers_all_split);
while (!$manufacturers_all->EOF) {
$rows = 0;
*/
// eof Pagination
//replacing the above pagination code with the following two lines works but listing is without pagination
$manufacturers_all = $db->Execute($manufacturers_all_sql);
while (!$manufacturers_all->EOF) {
$manu_content .= '<div class="manuWrapper">';
Bookmarks