Several parts of admin section shouldn’t not work in oscommerce-2.2ms2 installation on Fedora Core 4 due to some issues with MySQL 4.1 In order to fix them the following lines in admin/includes/classes/split_page_results.php:
$offset = ($max_rows_per_page * ($current_page_number - 1));$sql_query .= " limit " . $offset . ", " . $max_rows_per_page;
should be changed to:
$offset = ($max_rows_per_page * ($current_page_number - 1));if ($offset < 0){$offset = 0 ;}$sql_query .= " limit " . $offset . ", " . $max_rows_per_page;

Posts