Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Newsletter Manager


wilmatrix

Recommended Posts

Hi this is the error that I get within trying to configure my Newsletter manager. I also get the same error when trying to access tax zones.

 

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-20, 20' at line 1

 

select newsletters_id, title, length(content) as content_length, module, date_added, date_sent, status, locked from newsletters order by date_added desc limit -20, 20

 

Please help

Link to comment
Share on other sites

I had this problem previously, and this is the fix.

 

In admin/includes/classes/split_page_results.php you'll see this code:

 

$offset = ($max_rows_per_page * ($current_page_number - 1));

$sql_query .= " limit " . $offset . ", " . $max_rows_per_page;

 

Sandwich these lines between the ones above:

 

if ($offset < 0)

{

$offset = 0 ;

}

 

Vger

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...