How to fix Newsletter Manager ?

[Yovav]

Dear all.

 

I get this error on Admin -> Newsletter Manager:

 

 

Newsletter Manager

 

Newsletters Size Module Sent Status Action

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

 

[TEP STOP]

 

 

 

How can I fix it ?

[Yovav]

?

 

:blink:

[Guest]

http://www.oscommerce.com/community/bugs,1605/search,sql

[Yovav]

Thanks! - the bottom post worked for me:

 

 

29 Sep 2005 19:21:49 hpdl (AT) oscommerce (DOT) com

 

Thanks for the report, here is the official fix:

 

Line 67 in catalog/includes/classes/split_page_results.php must be changed from:

 

$this->sql_query .= " limit " . $offset . ", " . $this->number_of_rows_per_page;

 

to:

 

$this->sql_query .= " limit " . max($offset, 0) . ", " . $this->number_of_rows_per_page;

 

Line 38 in catalog/admin/includes/classes/split_page_results.php must be changed from:

 

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

 

to:

 

$sql_query .= " limit " . max($offset, 0) . ", " . $max_rows_per_page;

[Guest]

Thank you!!!! This is the very same problem I was having. The fix worked wonderfully.

 

Thanks