If anyone is getting 1064 errors in admin features in oscommerce after the upgrade such as the newsletter manager etc the following will fix it. The problem is related to the feature having no data to return.

In admin/includes/classes/split_page_results.php approx line 35

Find

$offset = ($max_rows_per_page * ($current_page_number - 1));
$sql_query .= " limit " . $offset . ", " . $max_rows_per_page;

Between enter:

if ($offset < 0)
{
$offset = 0 ;
}

So it now reads:

$offset = ($max_rows_per_page * ($current_page_number - 1));
if ($offset < 0)
{
$offset = 0 ;
}
$sql_query .= " limit " . $offset . ", " . $max_rows_per_page;